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:
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