Question

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

Answer 1

A foreign key must satisfy referential integrity, ensuring consistent relationships between tables in a relational database.

Step-by-step explanation:

A foreign key must satisfy referential integrity, which specifies that the value of an attribute in one relation (table) depends on the value of the same attribute in another relation (table).

Referential integrity is a key concept in relational databases, and it ensures that relationships between tables remain consistent.

When a database is designed with referential integrity, the database management system enforces the rules necessary to ensure that references or links between data are valid and that important data cannot be deleted or changed inappropriately.