3.2.07. Normal forms (2NF)

  • A relation Ri is in 2NF if:
    • Every nonprime attribute A in Ri is
    • fully functionally dependent on 1y key of R
  • If all keys are singletons, guaranteed
  • If Ri has composite key are
    • all non-key attributes fully functionally dependent
    • on all attributes of composite key?