Overlapping and disjoint subtypes have different approaches on how the subtype discriminator is applied.
Select an option to see the answer and solution.
Database · all questionsER Model and Business Rules
ER Model and Business Rules
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
30
Questions
2/2
Page
Pick an option on a question to see the right answer and solution.
An entity instance of a subtype represents the same entity instance of a supertype.
Select an option to see the answer and solution.
A supertype is an entity type that shares common attributes or relationships distinct from other subgroupings.
Select an option to see the answer and solution.
An ERD that has had the entities clustered will display more entities.
Select an option to see the answer and solution.
Total specialization is represented by double lines between the supertype and subtype on an EER.
Select an option to see the answer and solution.
Generalization is the process of defining more general entity types from a set of more specialized entity types.
Select an option to see the answer and solution.
It is appropriate to use a supertype/subtype relationship when there are attributes that apply to some of the instances of an entity type.
Select an option to see the answer and solution.
If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype.
Select an option to see the answer and solution.
Action assertions have traditionally been implemented within an application program.
Select an option to see the answer and solution.
An entity cluster is a set of one or more entity types and associated relationships.
Select an option to see the answer and solution.