The integrity constraint that ensures that every many record in a one-to-many relationship has a matching record in the one file is called:
A) entity integrity.
B) referential integrity.
C) domain integrity.
D) ordinal integrity.
E) cardinal integrity.

Question

Quizplus · Accepted Answer

Referential integrity ensures that every record in a many file has a matching record in the one file. Entity integrity ensures that every record in a file has a unique identifier, domain integrity ensures that values in a field meet certain restrictions or requirements, ordinal integrity ensures that records are stored in a specific order, and cardinal integrity refers to the maximum number of related records in a relationship.

The Integrity Constraint That Ensures That Every Many Record in a One-To-Many