Answered: library contains books, periodicals,…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

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?

The specialization/generalization hierarchy for items that involve borrowing items and reference items has an optional participation constraint.
The specialization/generalization hierarchy for items that involve the books, periodicals, and DVDs has a mandatory participation constraint.
The user entity will have specializations registered users and temporary users.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions