您在這裡

2nd Normal Form

20 十月, 2015 - 09:35
  • The relation must first be in 1stNF.
  • The relation is automatically in 2ndNF, if and only if the primary key comprises a single attribute.
  • If the relation has a composite primary key, then each non-key attribute must be fully dependent on the entire primary key and not on a subset of the primary key (i.e. there must be no partial dependency – augmentation).