Which database model uses primary keys and foreign keys to establish relationships between tables?

Options

  • A. Hierarchical model
  • B. Relational model
  • C. Network model
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. Relational model

Detailed Explanation

  • Relational model: Uses keys to establish relationships between tables.
  • Primary key: Uniquely identifies a record in a table.
  • Foreign key: References a candidate key, commonly a primary key, in another or the same table.