Difficulty: Easy
Correct Answer: Mandatory one
Explanation:
Introduction / Context:
ER models frequently annotate relationships with minimum and maximum participation. Minimum indicates whether an instance is required to participate (0 = optional, 1 = mandatory). Maximum indicates whether at most one or many related instances are allowed.
Given Data / Assumptions:
Concept / Approach:
Minimum 1 and maximum 1 together imply that each instance must participate exactly once in the relationship. This is called “mandatory one” participation. It is distinct from “optional one” (min 0, max 1) and “mandatory many” (min 1, max many).
Step-by-Step Solution:
Verification / Alternative check:
Cross-check with ER notations (crow's foot or min–max notation): (1,1) denotes mandatory one.
Why Other Options Are Wrong:
Common Pitfalls:
Confusing “one-to-one relationship type” with participation on a single side; min/max are per role and must be read carefully.
Final Answer:
Mandatory one
Discussion & Comments