Normalformen (EN)

Concept

Levels of database normalization that systematically improve table structure

Normal Forms Hierarchy

flowchart TD     A[Database Normalization] --> B[1NF First Normal Form]     A --> C[2NF Second Normal Form]     A --> D[3NF Third Normal Form]     A --> E[BCNF Boyce-Codd Normal Form]     A --> F[4NF Fourth Normal Form]     A --> G[5NF Fifth Normal Form]          B --> B1[Atomic Values]     B --> B2[Each entry unique]          C --> C1[Dependency on entire primary key]     C --> C2[Partial key dependencies removed]          D --> D1[No transitive dependencies]     D --> D2[Only key attributes determine other attributes]          E --> E1[Every determinant is a key candidate]          F --> F1[Multi-valued dependencies removed]          G --> G1[Join dependencies resolved]

In Context

  • Typically used together with data modeling and database design
  • Related to: Data integrity, Redundancies, Dependencies, Relational model
  • Example use: Designing efficient database structures for e-commerce systems

In diesen Lernmodulen erwähnt

Quelle: AI Generated