Rules for Normalization

• Second Normal Form (2NF)
  • Table is in 1NF
  • All nonkey fields in a table must be functionally dependent on all of the key (i.e., remove all partial dependencies)
  • 2NF is primarily concerned with dependencies involving a concatenated primary key (nonkey fields must be functionally dependent on the entire concatenated key not just one attribute of the composite key)

Previous slide

Next slide

Back to first slide

View graphic version