This illustration shows the
orders master table and the
customers 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 many to one relationship between the
customers tables because one customer can have many orders but an order can have only one customer.