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 customers
and orders
tables
because one customer can
have many orders but an order can have only one customer.