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