In a one-to-many (1:N) relationship, what do we call the entity on the many side?

Difficulty: Easy

Correct Answer: child

Explanation:


Introduction / Context:
One-to-many relationships are ubiquitous: one customer has many orders, one department has many employees. Understanding the parent–child terminology clarifies referential integrity and foreign key placement.



Given Data / Assumptions:

  • The relationship is 1:N (one parent to many children).
  • We need the role name for the N-side entity.
  • Conventional ER terminology is assumed.


Concept / Approach:
In 1:N, the single-instance side is the parent, and the multiple-instances side is the child. In the relational schema, the child table typically contains the foreign key referencing the parent's primary key.



Step-by-Step Solution:

Identify the one side → parent.Identify the many side → child.Place foreign key on child referencing parent's key to enforce the relationship.


Verification / Alternative check:
Most modeling notations and RDBMS textbooks use this nomenclature for clarity when mapping relationships to tables.



Why Other Options Are Wrong:
Parent: Refers to the one side.
Instance: A specific occurrence, not a role.
Subtype: Part of supertype–subtype, unrelated to 1:N roles.
Associative: Typically resolves M:N relationships.



Common Pitfalls:
Putting the foreign key on the parent instead of the child leads to incorrect optionality and duplication issues.



Final Answer:
child

More Questions from Data Modeling with ER Model

Discussion & Comments

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