Foreign key

Foreign keys are used to identify data records which are stored in other database tables but are related to data records from the current table. Departments are saved in the following table.

Primary key	Department
1	Sales
2	Marketing
3	Support

The next table contains employee data.

Primary key	Department	First name	Last name
1	3	Betty	Miller
2	2	Sam	Cook
3	2	Ralf	Miller
4	1	Sam	Hampton

The primary key of the department is saved as the foreign key in the Department column. This makes it very simple to identify, for example, that Betty Miller works in the Support department.