Why shouldn't they have
null
values? Primary keys can't because
null
is not a unique value - which is a requirement of a
Primary key[
^]. A
Foreign key[
^] just relates a row in one table to a unique row in another table, and so can be
null
when no such row exists.