Rules for Normalization

• Bottom-up design approach or used as a method to check E-R model

• 1NF - remove repeating values
  
  2NF - remove partial dependencies
  3NF - remove transitive dependencies

• For most database designs 3NF is sufficient

Previous slide

Next slide

Back to first slide

View graphic version