Why foreign key are allowed to have NULL values? Explain with an example.
Answers
Answered by
5
Explanation:
When a UNIQUE constraint is defined on the foreign key, only one row in the child table can reference a given parent key value. This model allows nulls in the foreign key. This model establishes a one-to-one relationship between the parent and foreign keys that allows undetermined values (nulls) in the foreign key.
Similar questions
Computer Science,
5 months ago
English,
5 months ago
English,
5 months ago
Math,
10 months ago
English,
10 months ago
Computer Science,
1 year ago
Psychology,
1 year ago