1.1 Summary: 1NF

• A relation is in 1NF if it contains no repeating groups.
• To convert an unnormalised relation to 1NF either:
  • Flatten the table and change the primary key, or
  • Decompose the relation into smaller relations, one for the repeating groups and one for the non-repeating groups.
• Remember to put the primary key from the original relation into both new relations.

  Next

Index