2NF (EN)

Concept

Second normal form that eliminates partial dependencies

Definition

The second normal form (2NF) requires that all non-key attributes depend on the entire primary key, not just parts of it. It eliminates partial dependencies by moving these attributes to separate tables with foreign keys. The 2NF is only applied to tables that have composite primary keys.

Example

  • Typically used together with 1NF and 3NF
  • Related to: 1NF, 3NF, BCNF, Normalization
  • Example use case: Transformation of a table with a composite key and partial dependencies
Quelle: AI Generated