Question 13 Which of the following about enhanced entity relationship modeling is/are correct? Select all that apply (note: partial (positive or negative) credits are assigned to partially correct or incorrect answers respectively; minimum score of the question is zero). When subtypes are overlapping, an additional field must be added to the supertype to act as a discriminator. Subtypes at the lowest level of a hierarchy do not inherit attributes from their ancestors. ✔ In a supertype / subtype hierarchy, attributes are assigned at the highest logical level that is possible in the hierarchy. Regardless of the business situation, a member of the supertype is always a member of more than one subtype. A subtype can become a supertype if the subtype has other subtypes beneath it.

Question 13 Which of the following about enhanced entity relationship modeling is/are correct? Select all that apply (note: partial (positive or negative) credits are assigned to partially correct or incorrect answers respectively; minimum score of the question is zero). When subtypes are overlapping, an additional field must be added to the supertype to act as a discriminator. Subtypes at the lowest level of a hierarchy do not inherit attributes from their ancestors. ✔ In a supertype / subtype hierarchy, attributes are assigned at the highest logical level that is possible in the hierarchy. Regardless of the business situation, a member of the supertype is always a member of more than one subtype. A subtype can become a supertype if the subtype has other subtypes beneath it.

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

Similar questions

What is the difference between a feeble entity set and a robust entity set?
Question: What is the anticipated modeling approach and what is the reason to choose it for any model. Note: Please need a short answer in 2/3 sentences.
Give Difference between Entity and entity cluster
What is a weak entity? Give Example.
What is NOT another name for an associative entity? Linking table Bridge entity Composite entity Strong entity
WorkHours is a weak entity. What would you do to transform it into a strong entity? Would it be desirable to change it into a strong entity? Why or why not?
QUESTION 9 is used to represent the M: N relationships between two or more entities. O A Mandatory B. Relationship degree C. Associative entity D. Optionality
A relationship between entity supertype and entity subtype is known as ___
Question 20 Which of the following might result from a many-to-many relationship? Group of answer choices exclusive subtype intersection data supertype entity recursive relationship
Is there a need for creating an associative entity? If so, draw one, if not, then suggest why?
Create an entity-relationship diagram for the three entities showing the correct cardinalities. Save and print a copy.