Build a ER Diagram to handle the library described below. The library handles books. Books have a
Question:
Build a ER Diagram to handle the library described below.
The library handles books. Books have a title, author, ISBN, and additional relevant data you think are needed. Booksare identified by a barcode.There can be many copies of the same ISBN but only one copy of an actual book per barcode. These booksreside 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 email addresses must also be kept. A patron can have many 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.
Systems Analysis and Design in a Changing World
ISBN: 978-1305117204
7th edition
Authors: John W. Satzinger, Robert B. Jackson, Stephen D. Burd