____ specifies that for every attribute value in one relation that has been specified in order to allow reference to another relation, the tuple being referenced must remain intact.
A) Cardinality constraint
B) Participation constraint
C) Referential integrity
D) Economic constraint

Question

Quizplus · Accepted Answer

Referential integrity ensures that any foreign key values in a relation refer to existing tuples in another relation. It also ensures that when a tuple is deleted or updated in the referenced relation, the corresponding tuples in the referencing relation are either deleted or updated accordingly to maintain consistency in the database.

____ Specifies That for Every Attribute Value in One Relation