Question

A field that is defined in a table, and that is also defined as a primary key in a different table, is a(n) ___________.

1) Foreign Key
2) Primary Key
3) Secondary Key
4) Composite Key

Answer 1

A field that serves as a primary key in one table and is also defined in another table is known as a Foreign Key. It establishes a relationship between the two tables and maintains the referential integrity of the data.

Step-by-step explanation:

A field that is defined in a table, and that is also defined as a primary key in a different table, is a Foreign Key. A Foreign Key is a column or a set of columns in a relational database table that provides a link between data in two tables. It references the primary key of another table, thus establishing a relationship between the two tables. The primary purpose of a foreign key is to ensure the referential integrity of the data. In other words, it is used to ensure that the value of the foreign key column is matching the value of a primary key in the dataset it references.