Does the “degree” of a relationship indicate the number of participating entity types (for example, unary = 1, binary = 2, ternary = 3)?

Difficulty: Easy

Correct Answer: Correct

Explanation:

Introduction / Context: Relationship degree is a classic ER concept distinct from cardinality. Degree counts how many entity types participate. Most operational schemas are built from binary relationships, but unary (recursive) and ternary (three-way) relationships occur in practice.

Given Data / Assumptions:

  • Unary: one entity type relates to itself (e.g., Employee manages Employee).
  • Binary: two entity types (e.g., Customer places Order).
  • Ternary: three entity types (e.g., Doctor prescribes Drug to Patient).

Concept / Approach: Degree answers “how many entity types?” while cardinality answers “how many instances on each side?” and optionality answers “minimum participation required?” Keeping these distinct helps avoid modeling errors.

Step-by-Step Solution: Identify participants in a relationship. Count the distinct entity types to determine degree. Separately specify maximum and minimum cardinalities for each participating side.

Verification / Alternative check: Transform a ternary relationship into associative tables; verify that the relationship truly requires three-way dependency, not two separate binaries.

Why Other Options Are Wrong: “Incorrect” conflicts with accepted definitions. Limiting to binary or tying to optionality mixes separate properties.

Common Pitfalls: Forcing ternary relationships into binary pairs without preserving semantics; conflating degree with cardinality.

Final Answer: Correct

Discussion & Comments

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