CREATE TABLE Borrowers (
    borrower_id INT AUTO_INCREMENT PRIMARY KEY
    name VARCHAR(50) NOT NULL
    grade VARCHAR(10), UNIQUE (name,grade)
);

CREATE TABLE BorrowingRecords (
    record_id INT AUTO_INCREMENT PRIMARY KEY,
    book_id INT,
    borrower_id INT,
    borrow_date DATE,
    return_date DATE,
    FOREIGN KEY (book_id) REFERENCES 
    Books(book_id)
    FOREIGN KEY (borrowers_id) REFERENCES
    Borrowers(borrower_id)
);

Embed on website

To embed this project on your website, copy the following code and paste it into your website's HTML: