Available under Creative Commons-ShareAlike 4.0 International License.
- 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).
- 1649 reads