A ________ key establishes a relationship between tables by referencing the primary key of another tablea.Noneb.Foreign Keyc.Composite Keyd.Primary Key

The correct answer to the question is b. Foreign Key.

Explanation

In relational database management systems (RDBMS), keys play a crucial role in establishing and maintaining relationships between tables. A Foreign Key is a column (or a set of columns) in one table that refers to the Primary Key in another table. This relationship creates a link between the two tables, ensuring data integrity and enabling efficient data retrieval based on these relationships.

1. Primary Key: A column or a set of columns that uniquely identifies each row in a table.
2. Foreign Key: A field (or collection of fields) in one table, that refers to the Primary Key in another table, establishing the relationship between the two.

For example, if you have a "Customers" table with a primary key called "CustomerID," you could have an "Orders" table that has a foreign key field also named "CustomerID." This foreign key in the "Orders" table allows you to associate each order with the specific customer who made it, thereby linking the two tables together. Thus, option b best fits the definition given in the question.