Actualités

It's best practice to declare the foreign keys according to functional dependencies. E.g. if your other table is about salespeople, then its foreign key should refer to Salespeople.
A primary key is a guaranteed way of uniquely identifying each record. In the school example, the primary key used to identify each member of staff in the teacher table is Staff ID.