Foreign key

Primary keyDepartment
1Sales
2Marketing
3Support

The next table contains employee data.

Primary keyDepartmentFirst nameLast name
13BettyMiller
22SamCook
32RalfMiller
41SamHampton