Question
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
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