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)
);
To embed this project on your website, copy the following code and paste it into your website's HTML: