Referential integrity constraints should disallow adding a new row to a child table when the foreign key does not match a primary key value in the parent table.

Question

Quizplus · Accepted Answer

Referential integrity constraints ensure that the values in a foreign key column correspond to the values in the corresponding primary key column of the parent table. Therefore, if a new row is added to the child table and the foreign key value does not match a primary key value in the parent table, it violates the referential integrity constraint and should not be allowed.

Referential Integrity Constraints Should Disallow Adding a New Row to a Child