Question: design an entity relationship (ER) model for a library management system. Your E-R model should include the following: 1.A list of entities and their

design an entity relationship (ER) model for a library management system. Your E-R model should include the

design an entity relationship (ER) model for a library management system. Your E-R model should include the following: 1.A list of entities and their attributes. (Section 1 of your document) 2.A list of relationships between entities, including the cardinality of each relationship. (Section 2 of your document) 3.A graphical representation of the ER model (hand drawn figure ONLY scanned clearly and included in your pdf document) (Section 3 of your document) In your design, consider the following requirements for the library management system: A library has many branches, and each branch has a unique name and address. Each branch has many books, and each book has a unique ISBN, title, author, and year of publication. Each branch also has many members, and each member has a unique member ID, name and address (add email address, phone number). Members can borrow books from the library, and each borrowed book has a unique loan number, loan date and return date.. Members can also place holds on books that are currently withdrawn, and each hold has a unique hold ID, suspension date, and expiration date. You should also include any additional entities and relationships that you deem necessary for the library management system. You should have at least 5 entities with at least 5 attributes each. Also, you should have at least 5 connections.

Step by Step Solution

3.44 Rating (144 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Solution Section 1 Entities and Attributes Entity Attributes Library Name address Branch Name addres... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!