Answered step by step
Verified Expert Solution
Link Copied!

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

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Databases questions

Question

How are writable CDs implemented?

Answered: 1 week ago

Question

For each, show how or explain why not. If Can C = 0? Can C

Answered: 1 week ago

Question

For each, show how or explain why not. If Can Can

Answered: 1 week ago