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.