Put in order · SQL and MySQL course · Module 9: Indexes and normalization

The successive normal forms

Arrange the normalization levels in the order we apply them - from the basic to the highest:

Items to put in order

  • 2NF - 1NF + no dependency on part of a composite key
  • 1NF - atomic values (one value in one cell)
  • 3NF - 2NF + no transitive dependencies

You can check the correct answer by solving this task in the CodeWorlds game.