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 ...

Across physical tables, shared columns are the evidence of a foreign key relationship. The columns comprising the primary key of the table on the one-side of the relationship are repeated on the table ...