Multiple choice

In the context of relational databases, which of the following is used to establish and enforce a link between the data in two tables?

  1. Compound key

  2. Primary key

  3. Foreign key

  4. Alternate key

  5. Natural key

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table. In other words, a foreign key is a column or a combination of columns that is used to establish and enforce a link between the data in two tables.