Multiple choice technology databases

What can a mandatory one to one relationship indicate?

  1. More entities are needed

  2. The model should be denormolized

  3. The tables are not properly indexed

  4. The model cannot be implemented physically

  5. More attributes are needed
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

A mandatory one-to-one relationship where every instance of Entity A must relate to exactly one instance of Entity B (and vice versa) often suggests insufficient attributes to justify separate entities. Such tight coupling indicates they should either be merged into a single entity or one should be modeled as an attribute of the other. The question tests recognizing when 1:1 relationships signal design issues.

Keep practicing — related questions