The integrity constraint that specifies that the value (or existence) of an attribute in one relation depends on the value (or existence) of the same attribute in another relation is called:
A) foreign integrity.
B) attribute integrity.
C) referential integrity.
D) dependence integrity.
E) join integrity.

Question

Quizplus · Accepted Answer

This integrity constraint is called referential integrity. It ensures that any foreign key value in one relation must match a primary key value in another relation. For example, if we have a table of orders and a table of customers, the customer ID in the orders table should refer to a valid customer ID in the customers table.

The Integrity Constraint That Specifies That the Value (Or Existence)