Question

Why foreign keys are allowed to have NULL values? Explain
with an example.​

Answer 1

Answer:

A foreign key makes its table dependent on another table called a parent table. ... A foreign key containing null values cannot match the values of a parent key, since a parent key by definition can have no null values. However, a null foreign key value is always valid, regardless of the value of any of its non-null parts.