Many to Many

The Many to Many (M:N) always results in a new entity called a composite entity. Consider the constraints that are applied to the composite entity foreign constraints under the following scenarios:

Both Mandatory

Both Optional

Optional and Mandatory

Mandatory and Optional

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