library contains books, periodicals, and DVDs (no items of other types are available and a given item belongs to only a single category). All these items can be used by the user of the library. Some...



  •  library contains books, periodicals, and DVDs (no items of other types are available and a given item belongs to only a single category). All these items can be used by the user of the library.

  • Some of the items (books, periodicals, and DVDs) are only reference items, and others can be borrowed by the users.

  • There are two types of users; registered users and temporary users. While registered users can borrow up to 100 items, the temporary users can borrow only 2 items at a time.



In the initial work of the EER modeling, your teammates have identified Item, User, and ItemCopy as entities.Which of the following statements are correct about a possible EER model for this set of requirements?



  1. The specialization/generalization hierarchy for items that involve borrowing items and reference items has an optional participation constraint.

  2. The specialization/generalization hierarchy for items that involve the books, periodicals, and DVDs has a mandatory participation constraint.

  3. The user entity will have specializations registered users and temporary users.



Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Submit New Assignment

Copy and Paste Your Assignment Here