Answered step by step
Verified Expert Solution
Link Copied!
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

image text in transcribed

(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

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Making Databases Work The Pragmatic Wisdom Of Michael Stonebraker

Authors: Michael L. Brodie

1st Edition

1947487167, 978-1947487161

More Books

Students explore these related Databases questions