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

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here