Database Fundamentals — Question 3

While attending college, you accept an IT internship at a local charity. The charity needs to report on data that is related and exists in two tables.
You need to establish a relationship between the data that is in the two tables.
Which constraint should you define?

Answer options

• A. Foreign key
• B. Index key
• C. Link key
• D. Default key

Correct answer: A

Explanation

The correct answer is A, Foreign key, as it is specifically designed to establish a relationship between tables by linking a column in one table to the primary key of another. The other options, such as Index key, Link key, and Default key, do not serve the purpose of creating a relational link between tables.