A foreign key ____.
A) must have the same column name(s) as the primary key from which it is derived
B) must not have the same column name(s) as the primary key from which it is derived
C) must have the same domain of values as the primary key from which it is derived
D) must not have the same domain of values as the primary key from which it is derived
E) must have a domain of values that is different from any other in the database

Question

Quizplus · Accepted Answer

A foreign key must have the same domain of values as the primary key from which it is derived to ensure referential integrity between the two keys. This means the data type and constraints (like character length) should match, allowing the foreign key to correctly reference the primary key.

A Foreign Key ____