Relational Data

• Different tables are related to one another with primary and foreign key matches.

  • Ex. Sales order table holds customer FK

• Relationships may be:

  • (Zero or) One-to-one
  • (Zero or) One-to-Many
  • Self-join

• Relational Integrity (RI) can be enforced with triggers, RI Builder, or code

  • Ex. Cannot delete invoice with detail items