ER Diagrams   «Prev  Next»

One-to-one Relationships - Exercise

Objective: Identify one-to-one relationships

Exercise Scoring

This exercise is worth a total of 15 points. You will receive up to five points for each correctly composed and plausible business rule according to the instructions below.
  • Background and Overview: You learned that a one-to-one relationship is defined as a relationship that exists when zero or one instance of entity A can be associated with zero or one instance of entity B, and zero or one instance of entity B can be associated with zero or one instance of entity A. You also learned that 1:1 relationships are rare in the business world.
  • Instructions: Compose three business rules that reflect a one-to-one relationship between two entities. Try to make your rules as realistic as possible.
  • Submitting your Exercise: Type or paste your answers into the text box below, then click Submit your answer and view a results page.