3.2.02. Normalization

  • Reduced redundancy
  • Organised data efficiently
  • Improves data consistency
    • Reduces chance of update anomalies
    • Data duplicated, then updated in only one location
  • Only duplicate primary key
    • All non-key data stored only once
  • Data spread across multiple tables, instead of one Universal relation R