What is the role of a foreign key?
A) It is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
B) It is a unique way to identify each record.
C) It is a field that uniquely identifies a given record in a table.
D) All of these.

Question

Quizplus · Accepted Answer

A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table. In essence, it is a primary key from one table that is used in another table to establish a relationship between the two tables, ensuring referential integrity. Choices B and C describe a primary key, not a foreign key.

What Is the Role of a Foreign Key