Difficulty: Easy
Correct Answer: Incorrect
Explanation:
Introduction / Context:
Understanding which side is “parent” in a 1:N relationship is foundational to data modeling and foreign key placement. The parent/child direction determines how keys and constraints are implemented and how data is inserted and deleted safely.
Given Data / Assumptions:
Concept / Approach:
Parent designation is not arbitrary: it is the “one” side—the entity that owns the key and whose primary key is referenced. The child is the “many” side, holding the foreign key. This direction flows from the business semantics: for example, one Customer has many Orders, therefore Customer is parent and Order is child. Choosing the child to be parent would invert foreign key placement and contradict the “one-to-many” semantics. Performance and indexing are design considerations but do not redefine parenthood.
Step-by-Step Solution:
Verification / Alternative check:
Inspect sample schemas (Customer–Order, Department–Employee). In each, the foreign key sits on the “many” side, confirming non-arbitrary direction.
Why Other Options Are Wrong:
Common Pitfalls:
Designing with bidirectional dependencies; duplicating keys on both sides; misplacing the foreign key on the “one” side.
Final Answer:
Incorrect
Discussion & Comments