The objective of this assignment is to understand the role of ER diagrams in database design.
Tasks:1. Design an ER diagram for a library management system with the following entities:
Books (attributes: BookID, Title, Author, Genre).
Members (attributes: MemberID, Name, Address, Phone).
Loans (attributes: LoanID, DateIssued, DueDate).
2. Identify relationships (e.g., “Members borrow Books”) and specify cardinalities (e.g., one member can borrow many books).Deliverable: Submit an ER diagram and include a brief description of entities, attributes, and relationships.