Question

c) Write an ER Diagram for the following Library database. Identify all the Entities, Relationships and Attributes. Underline the primary keys and mark the different constraints. You can add an I attribute as a primary key for an entity to make t unique if necessary.

 Library has a number of branches in the city, each branch having a name, address and librarian. Books have title, authors and publisher. A book can have multiple authors but a single publisher. Note that same author can write multiple books and same publisher can publish muitiple books. Publisher has a name, address and phone number as publisher details. Each library branch can have various number of copies of each book. A borrower, identified by a unique library card number has name, address and phone number. Borrower is a member of one library branch When a borrower loans a book, the date of issue and the due date is recorded.

Answer 1

diaqra m for Library manaag ment ame abrary ook breu managerm bralan bue dat b lis hed 5 publis he) Refun dak addrex &piry- aake ame membu hone rumbun mem name