A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called ________.
A) normalization
B) a referential integrity constraint
C) a key matching constraint
D) a functional dependency
E) synchronization

Question

Quizplus · Accepted Answer

A referential integrity constraint ensures that the values in a foreign key correspond to those in the primary key to maintain data consistency and accuracy. Normalization is a process of organizing data into tables to minimize redundancy and dependency. A key matching constraint and functional dependency are not standard terms used in relational databases. Synchronization refers to the process of ensuring that two or more copies of data are the same.

A Rule That Requires That the Values in a Foreign