News
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.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results