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

Options

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

Correct Answer (Detailed Explanation is Below)

B. Foreign key

Detailed Explanation

  • Foreign key: An attribute or set of attributes in one table that references a candidate key, commonly the primary key, of another or the same table.
  • It establishes relationships between tables.
  • It helps maintain referential integrity.