163k views
1 vote
A(n) FOREIGN KEY constraint can only reference a column in the parent table that has been designated as the primary key for that table.

A) True
B) False

1 Answer

5 votes

Final answer:

The assertion that a FOREIGN KEY constraint can only reference a primary key in the parent table is false, as it can also reference any column with a UNIQUE constraint.

Step-by-step explanation:

The statement "A(n) FOREIGN KEY constraint can only reference a column in the parent table that has been designated as the primary key for that table." is False.

A FOREIGN KEY constraint in a database does not necessarily need to reference a primary key in the parent table; it can reference any column that has been defined as a UNIQUE key. The referenced column must be a candidate key, which means it could be a primary key or any column with a UNIQUE constraint that uniquely identifies each row in the table.

User Jigneshbrahmkhatri
by
9.1k points