The tables are linked because the primary key (Department ID) in the Department table is also needed in the Teacher table – so that you know which department each member of staff is part of.