Which statement is correct?

A foreign key is a field in one table that refers to the primary key of another table, linking records between the tables. It does not uniquely identify a record in its own table—that is the role of a primary key. Therefore, the correct statement is “A foreign key is a primary key in another table.”

AI-written and checked against the verified answer.