Second Normal Form (2NF)

• A relation r(R) is in Second Normal Form (2NF) iff:

  • r(R) is already in 1NF
  • each attribute that is not part of a candidate key is fully dependent on every candidate key