3.2.09. Normal forms (2NF)

  • In context
    • Not 2NF: AB → C, A → C
      • AB → C is not in 2NF, because B can be removed
    • Not 2NF: AB → CDE, B → DE
      • because attributes D&E are dependent on part of the composite key (B of AB), not all of it