In a one-to-many relationship between
records in two linked tables, for every record in the primary table, there may
be more than one matching record in the lookup table, based on the linked
fields. In the Xtreme database, the Customer table can be linked to the Orders
table based on the Customer ID field in each table. The Customer table contains
information about each customer that has placed an order with the company. The
Orders table contains information about orders that customers have placed.
Since customers can place more than one order, there may be more than one
record in the Orders table for each customer record in the Customers table.
This is a one-to-many relationship.