ReturnDate
LoanDate
due date
title
LoanID
BookID
loans
LoanSlip
genre
Books
has
BorrowerID
Publication Year
FirstName
AvailableCopies
Borrowers
LastName
MembershipDate
Email
(Use the diagram below to complete question 1 (you can draw it in MS Word).
Entities Description
•
Entity Books: Stores information about books in the library.
Entity Borrowers:. Stores information of the borrower.
Entity Loanship: Records loan transactions.
•
•
2. (2 points) From the diagram in question 1, write SQL statements to create a table corresponding to the entity added in the diagram. The statement needs to show
+ 134%
Zoom
Close
