A(n)________ must satisfy referential integrity,which specifies that the value of an attribute in one relation depends on the value of the same attribute in another relation.
A)Foreign key
B)Primary key
C)Unique key
D)Index

Question

Quizplus · Accepted Answer

Only a foreign key is used to establish a relationship between two tables in a relational database. It is used to ensure referential integrity, which means that the value of a foreign key in one table must match the value of a primary key in another table. Therefore, a foreign key must satisfy referential integrity. Primary key, Unique key, and Index are used to ensure data integrity and facilitate querying, but they are not directly related to referential integrity.

A(n)________ Must Satisfy Referential Integrity,which Specifies That the Value of an Attribute