Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q4 Build a ER Diagram to handle the library described below. (PLEASE SHOW DIAGRAM VISUAL) The library handles books. Books have a title, author, IBSN,

Q4 Build a ER Diagram to handle the library described below. (PLEASE SHOW DIAGRAM VISUAL)

The library handles books. Books have a title, author, IBSN, and additional relevant data you think are needed. Books are identifiable by a barcode. There can be many copies of the same IBSN but only one copy of an actual book per barcode. These books reside in the library on shelf locations. A shelf location is made up of the aisle, row, cabinet, and shelf numbers. A book can have only one location, but shelves are wide and can contain many books. Some shelves may be left empty on purpose. The library lends books to patrons. A patron is identified by an ID. Additional information about each patron, including name, address, telephone numbers and emails. The library keeps track of which books have been lent to each patron, when the books were lend out, when they were returned. Also keep track of the categories of each book. A book can have many categories, such as MIS, Biology, Literature, etc., but must have at least one.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these General Management questions