The database requirement that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the
A)entity integrity rule.
B)referential integrity rule.
C)unique primary key rule.
D)foreign key rule.

Question

Quizplus · Accepted Answer

The requirement mentioned in the question statement is known as the referential integrity rule. This rule ensures the consistency and accuracy of data by enforcing the relationship between tables through foreign keys. The entity integrity rule enforces the uniqueness of primary keys in a table, while the unique primary key rule specifies that each table must have a primary key that is unique and not null. The foreign key rule deals with the relationship between tables through foreign keys.

The Database Requirement That Foreign Keys Must Be Null or Have