In a supertype–subtype hierarchy, which type of entity has its association to the supertype governed by a discriminator attribute defined on the supertype?

Difficulty: Easy

Correct Answer: Subtype entity

Explanation:


Introduction / Context:
Generalization/specialization modeling uses a discriminator on the supertype to decide which specialized path an instance follows. This is a cornerstone of clean modeling for heterogeneous categories.



Given Data / Assumptions:

  • A discriminator attribute exists on the supertype (e.g., CustomerType = 'Retail'/'Wholesale').
  • Instances are routed to the correct specialized entity based on the discriminator value.
  • We seek the name of the specialized entity affected by the discriminator.


Concept / Approach:
The subtype is the specialized entity that inherits common attributes from the supertype and adds subtype-specific attributes. The discriminator value determines which subtype applies for a given supertype instance.



Step-by-Step Solution:

Identify the discriminator's role → select a specialized path.Specialized entities in such a hierarchy → subtypes.Therefore, the affected entity type is the subtype entity.


Verification / Alternative check:
ERD notations often annotate the supertype with a discriminator attribute and connect to subtypes via exclusive or overlapping constraints.



Why Other Options Are Wrong:
Supertype entity: Hosts the discriminator, not governed by it.
Archetype / Instance / Associative entity: Not the standard terms for specialization levels in ER modeling.



Common Pitfalls:
Putting the discriminator on each subtype—by definition it belongs on the supertype to choose among subtypes.



Final Answer:
Subtype entity

More Questions from Data Modeling with ER Model

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion