In a well-structured database,the constraint that ensures the consistency of the data is known as the
A)entity integrity rule.
B)referential integrity rule.
C)unique primary key rule.
D)foreign key rule.

Question

Quizplus · Accepted Answer

The referential integrity rule ensures that foreign key values in one table match the primary key values in another table. This ensures consistency and accuracy of data between related tables in a database. Entity integrity rule and unique primary key rule ensure uniqueness of data in a single table, while foreign key rule defines the relationship between tables.

In a Well-Structured Database,the Constraint That Ensures the Consistency of the Data