Referential Integrity Constraint

Statement of the constraint
The value in the foreign key column (or columns) FK of the the referencing relation R1 can be either:
(1) a value of an existing primary key value of the corresponding primary key PK in the referenced relation R2,, or..
(2) a null.

In case (2), the FK in R1 should not be a part of its own primary key.

0 comments