Question: A library database system is designed to keep track of members, books, and borrow records. The system should capture the relationships between these entities, with
A library database system is designed to keep track of members, books, and borrow records. The system should capture the relationships between these entities, with a particular focus on book borrowing history and current loans. Draw an EER diagram for each of the following scenarios, taking into account any additional constraints mentioned.
points Members can borrow multiple books, and their borrowing history needs to be recorded, including the borrow date and return date for each book.
points Books can be borrowed by multiple members, but the database should only record the current borrowers for each book, not past borrowing records.
points Each member must borrow at least two books per month to maintain active membership status.
points Each book can only be borrowed by one member at a time; once borrowed, it cannot be available to others until it is returned.
points Every book must be available for borrowing, and every member must borrow at least one book to maintain active status.
points Modify the model to accommodate the scenario where certain books can be part of book clubs where multiple members can borrow and discuss the same book simultaneously. In this case, introduce any necessary entity sets and relationship sets. Assume that for each book club, only the members currently participating in it are recorded.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
