RelationalDBDesign RelationalDBDesign



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/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.