Foreign Key

It represents the primary key[1] from one table that is stored as an attribute in another table. It is used as a common key in both tables to form relationships for the data[2] in the two tables.

Defined Terms
1. primary key.

An attribute that has a unique value for each record in a table and is used to identify that record. An example of a primary key is an employee ID.

2. data.

Numbers, characters, or images in a form which can be assessed by a human or (especially) input into a computer, stored and processed.

Scroll to Top
Verified by MonsterInsights