Which key is used to establish a relationship between two relational database tables?

Options

  • A. Candidate Key
  • B. Foreign Key
  • C. Super Key
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. Foreign Key

Detailed Explanation

Explanation: A Foreign Key is an attribute or set of attributes in one table that references a candidate key, usually the primary key, of another table.