Material Detail

5 Rules of Data Normalization

5 Rules of Data Normalization

This colorful poster boils down the basics of data normalization into five simple rules, perfect for the wall of a database programming or design class. This pdf document, created by Marc Rettig, details the five rules as: Eliminate Repeating Groups, Eliminate Redundant Data, Eliminate Columns Not Dependent on Key, Isolate Independent Multiple Relationships, and Isolate Semantically Related Multiple Relationships. Each rule also has an example to illustrate the principle.


  • User Rating
  • Comments
  • Learning Exercises
  • Bookmark Collections
  • Course ePortfolios
  • Accessibility Info

More about this material


Log in to participate in the discussions or sign up if you are not already a MERLOT member.