Given the data requirements, design an Entity- Relationship diagram for the following statements. Show all entities alon

[answerhappygod]

Given The Data Requirements Design An Entity Relationship Diagram For The Following Statements Show All Entities Alon 1 (56.43 KiB) Viewed 20 times

Given the data requirements, design an Entity- Relationship diagram for the following statements. Show all entities along with minimum and maximum cardinalities. State any necessary assumption, if required. Note: You can upload the ERD image that can be either drawn by hand or online using any tool. Make sure to upload the image within the quiz duration. No extra time will be given to upload the image. Scenario: A city Library needs an information system to maintain the information on their books, members and transactions efficiently. Some of the database requirements are as follow: Information stored about books include unique ID, title, ISBN, publication year, author and publisher. A book might have many copies and a copy belongs to exactly one book. Each copy of a book is uniquely identified by copy ID and book ID. A book is written by one or many authors. An author is characterized by author ID name and date of birth.