One to Many

The One to Many (1:M) relationship is the basic building block for relational modeling. Consider the constraints that are applied to the foreign constraints of the entity on the Many side under the following scenarios:

Both Mandatory

Both Optional

Optional and Mandatory

Mandatory and Optional

See also: Many to Many, One to One, Weak, Specialization and Foreign Key Rules