Asked by Gurpreet Verka on Jun 11, 2024
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.
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.
Learning Objectives
- Comprehend the concept of referential integrity and its importance in database relationships.
Related questions
_____ Is a Set of Access Rules That Governs Data ...
When Specifying Referential Integrity,one Way to Handle the Update of ...
When Specifying Referential Integrity,one Way to Handle Deletions Is to ...
_____ Is a Set of Access Rules That Governs Data ...
A ________ Check Compares the Values of Data in Two ...