The stock table and the manufact table are joined by the manu_code column. The same manufacturer code can appear in more than one row of the stock table if the manufacturer produces more than one piece of equipment. In the stock table, the manu_code column is a foreign key that references the manu_code column in the manufact table. Figure 11 shows this relationship.