ER Diagrams   «Prev  Next»

Compose One-to-One Business Rules - Exercise

Objective: Write three plausible one-to-one business rules in both directions.

A one-to-one relationship allows at most one related instance in each direction. Either side may be optional (0..1) or mandatory (1..1). A statement about only one direction cannot establish a 1:1 relationship.

Task

Compose three different plausible business rules. For each, name both entities, state the minimum and maximum related instances in both directions, and identify the policy and time scope. If assignments can change, say that the model describes current assignments rather than their history.

Giving every employee a workstation does not establish 1:1 unless the rule also prevents workstation sharing. Make exclusivity an explicit policy.

Self-assessment: 15 points

For each of three examples, award 1 point for suitable entities, 2 for a maximum of one in both directions, 1 for minimum participation in both directions, and 1 for plausible policy and time scope. Total: 15 points. The page displays a model answer; it does not automatically grade free text.

Submit your response


Enter your answers, then select Submit to compare them with the model answer.


Blue Host 300by250Blue Host 300by250