Figure 2-27 represents members of a library issuing books and returning them to the library. The members
Question:
Figure 2-27 represents members of a library issuing books and returning them to the library. The members can be students, staff, or faculty, and their details are stored in the Member entity. A member can issue no more than 10 books. All the details on books are stored in the Books entity.
Figure 2-27
a. State the business rule for each relationship and thecardinality of each relationship, then explain them.
b. From your own understanding, identify the probableattributes and identifiers for each entity. Are there anyforeign keys in the figure?
c. Suppose the library offers books only to the staff, whocan issue only one book. Will this have an impact onthe relationship between the Members and BooksIssued entities? How? Will there be an impact on anyother entity?
d. Suppose, using this ER model, the library wishesto send an overdue mail to members who have notreturned the books in due time. Suggest how this canbe achieved. State any assumptions.
e. Is it possible to determine which schools do not have any of their students belonging to any club in that school? Explain.
Step by Step Answer:
a Relationship Member issues Books Business rule A member can issue multiple books but a book can only be issued to one member at a time Cardinality Onetomany Relationship Member returns Books Busines...View the full answer
Modern Database Management
ISBN: 9780134773650
13th Edition
Authors: Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman
