Difficulty: Easy
Correct Answer: An instance of a subtype participates in a relationship that is unique to that subtype.
Explanation:
Introduction / Context:Supertype/subtype modeling is a tool for capturing commonalities and meaningful differences across closely related entity types. The key question is when the extra structure pays off in clarity and correctness.
Given Data / Assumptions:
Concept / Approach:Introduce subtypes when behavior, constraints, or relationships differ materially. A classic signal is a relationship or attribute that applies only to some members of the supertype. Making a subtype isolates these unique properties and improves data integrity and understanding.
Step-by-Step Solution:
Evaluate whether uniqueness exists in attributes or relationships.If a relationship occurs only for a subset, model that subset as a subtype.Select the option stating uniqueness at the subtype level.Verification / Alternative check:Compare designs with and without subtypes; without subtypes, unique relationships create nulls or inconsistent foreign keys. With subtypes, the model is clearer and constraints are enforceable.
Why Other Options Are Wrong:
Common Pitfalls:Overusing subtypes for minor differences; focus on meaningful structural or behavioral distinctions.
Final Answer:An instance of a subtype participates in a relationship that is unique to that subtype.
Discussion & Comments