Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(a) [10 points) The New York Public library service wants to create a database to store details of its libraries, books, and borrowers. A requirements
(a) [10 points) The New York Public library service wants to create a database to store details of its libraries, books, and borrowers. A requirements analysis has provided the following information: A book has a unique ISBN number, a title, and one or more authors. The library service may own several copies of a given book, each of which is located in one of the service's libraries. A given library contains many books, and in order to distinguish different copies of the same book a library assigns a different copy number to each of its copies of a given book. The price that was paid for each copy is also recorded. Every library has a unique name and is either a main library or a branch library. A main library may have zero or more branch libraries and every branch library is a branch of exactly one main library. A borrower has a name and a unique ID code. A borrower can have many books on loan, but each copy of a book can only be on loan to one borrower. A borrower could borrow the same book on several occasions, but it is assumed that each such loan will take place on a different date. The ER diagram below illustrates a preliminary design of an Entity-Relationship model intended to meet the above specification. Unfortunately, this design is afflicted with errors. List as many errors as you can. Describe each error and clearly state both the nature of the problem and its solution. tito author ISBN Book ID state price copy m Borrower Borrow Loan lend Copy name no-of-branches location Library Main Branch m 1 branch
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started