Rules for Normalization

• First Normal Form (1NF)
  • A table cannot have repeating fields or groups (i.e., must remove redundant data)
  • Repeating groups are removed by creating another table which holds those attributes that repeat. This second table is then linked to the original table with an identifier (i.e., foreign key)

Previous slide

Next slide

Back to first slide

View graphic version