This illustration shows the
customers master table and the
orders master table. The
customers table has a
customer_id primary key column and the
orders table has a
customer_id foreign key column. There is a one to many relationship between the
orders tables because one customer can have many orders but an order can have only one customer.