Asked by Gurpreet Verka on Jun 11, 2024

verifed

Verified

________ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table.

A) Referential integrity
B) Normalization
C) Database consistency
D) Record integrity

Referential Integrity

In a relational database, a condition where, for each value in the foreign key table, there’s a corresponding value in the primary key table.

Foreign Key

In a relational database, the common field between tables that’s not the primary key.

Primary Key

A unique identifier for each record in a database table, used to ensure data integrity.

  • Comprehend the concept of referential integrity and its importance in database relationships.
verifed

Verified Answer

LV
Lovelight VillanuevaJun 14, 2024
Final Answer :
A
Explanation :
Referential integrity is a database concept that ensures relationships between tables remain consistent. It means that if a table has a foreign key, each value of that foreign key must exist as a value in the primary key of the referenced table.