A library keeps information about its books and borrowers, including a record of which books are currently on loan to which borrowers. Each copy is identified by an accession No, and each borrower by...


A library keeps information about its books and borrowers, including a record of which books are currently on loan to which borrowers. Each copy is identified by an accession No, and each borrower by a borrower No. Other attributes required are title, acquisition Date, acquisition Price, loan Date, borrower Name, borrower Limit. A copy has only one title. The acquisition Date and acquisition Price refer to the date the library acquired the copy and the purchase price at that time. The borrower Limit, which is the maximum number of books a borrower may have on loan at any one time, is not necessarily the same for all borrowers. Design an E-R model using Copy and Borrower for the entity types.



Dec 03, 2021
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here