Diagram of a relationship between three tables. The primary key and foreign key fields have been highlighted.