Implementing One-to-Many Relationships

• Each invoice may have many items
• Do not replicate columns, one for each item
• Do distribute the information in two tables, invoice and item
• Link each item to its invoice with an Invoice_Number foreign key in the item table