Question

why is foreign key allowed to have null values?

Answer 1

Answer:

You define a foreign key with the FOREIGN KEY clause in the CREATE TABLE or ALTER TABLE statement. 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