Question: BACKGROUND You are tasked with creating an Entity-Relationship Diagram (ERD) for a library management system. This system involves four main entities: Member, Book, Author, and
BACKGROUND You are tasked with creating an Entity-Relationship Diagram (ERD) for a library management system. This system involves four main entities: Member, Book, Author, and Rent. Your ERD should clearly represent the relationships between these entities according to the provided business rules. Business Rules: In this system, users are able to rent multiple books. Once they check out one or multiple books, a unique rent record will be assigned to users to track their transactions with the library. The library owns a lot of books that are written by only one author. The library owns books from authors who have also written multiple books. However, a big limitation of the library is that it has only one copy of each book. Description of entities: Member: Represents individuals registered with the library who can rent books. Book: Denotes books available in the library, each linked to a specific author. Author: Refers to the writers of the books available in the library. Rent: Records the details of the transaction when a library member rents a book. TASK REQUIREMENTS 1. Include all four entities (Member, Book, Author, Rent) in your ERD. 2. Each entity should have at least 4 attributes including the primary key. ( 4 points) 3. Include foreign keys where necessary to establish relationships between entities. ( 3 points) 4. Show cardinalities for each relationship (e.8., one-to-many, many-to-one) according to the business rules. ( 3 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
