Referential integrity should be enforced in a database with related tables because it:
A) creates a primary key in every table of a database.
B) helps ensure invalid data is not entered into a table.
C) makes the database easier to repair.
D) helps ensure data is automatically updated.

Question

Quizplus · Accepted Answer

Referential integrity helps ensure that the data entered into a table is valid and consistent with the data in related tables. It ensures that the relationships between tables are maintained and that there are no orphaned records. This makes it easier to maintain the data and prevent errors, making B the best choice. The other options are not accurate descriptions of referential integrity.

Referential Integrity Should Be Enforced in a Database with Related