That field would be a foreign key in the table, because the employee table would be indexed on employee number. See entity relationship model. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other ...

In the school example, the primary key used to identify each member of staff in the teacher table is Staff ID. A foreign key is a primary key from one table that appears in another table to link ...