Difficulty: Easy
Correct Answer: ID-dependent entity
Explanation:
Introduction / Context:An essential idea in logical data modeling is how one entity's identity can depend on another. When the child's key literally embeds the parent's key, we call that an ID-dependent pattern. This question asks you to name that concept.
Given Data / Assumptions:
Concept / Approach:An ID-dependent entity is one whose primary key contains the primary (or candidate) key of its parent entity. This is stronger than merely having a foreign key; here, the foreign key is part of the child's primary key, binding the child's identity to the parent.
Step-by-Step Solution:
Identify the key phrase: “identifier of one entity includes the identifier of another.”Match this to the formal term: ID-dependent entity.Confirm with a classic example: Order (OrderID) and OrderLine (OrderID, LineNo).Verification / Alternative check:Try removing the parent's key from the child's key. If the child would no longer be unique, the entity is ID-dependent.
Why Other Options Are Wrong:
Common Pitfalls:Confusing “has a foreign key” with “is ID-dependent.” Many children have foreign keys; ID-dependence requires the parent's key to be part of the child's primary key.
Final Answer:ID-dependent entity
Discussion & Comments