A well-structured or "normalized" database imposes several requirements on the structure of tables.The constraint that ensures the consistency of the database is known as
A)the entity integrity rule.
B)the referential integrity rule.
C)the logical view.
D)the physical view.

Question

Quizplus · Accepted Answer

The referential integrity rule ensures that relationships between tables are enforced correctly, such as enforcing foreign key constraints. The entity integrity rule ensures that each row in a table is uniquely identified by a primary key. The logical and physical views refer to how the database is viewed or implemented, but are not constraints themselves.

A Well-Structured or "Normalized" Database Imposes Several Requirements on the Structure