Try OpenEdge Now
skip to main content
Database Essentials
Database Design : Table relationships : One-to-many relationship

One-to-many relationship

A one-to-many relationship exists when each row in one table has one or many related rows in a second table. The following figure shows examples: one customer can place many orders, or a sales representative can have many customer accounts.
Figure 6. Examples of one-to-many relationships
However, the business rule might be that for one customer there can be zero-or-many orders, one student can take zero-or-many courses, and a sales representative can have zero-or-many customer accounts. This relationship is described as a zero-or-many relationship.