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.