Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Solution Section 1 Entities and Attributes Entity Attributes Library Name address Branch Name addres...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