Normalisierung (EN)

Concept

Organization of data to reduce redundancies

Architecture

flowchart TD   A[Unnormalisierte Tabelle] --> B[1. Normalform]   B --> C[2. Normalform]   C --> D[3. Normalform]   D --> E[Boyce-Codd Normalform]   E --> F[4. Normalform]   F --> G[5. Normalform]      subgraph Star Schema     H[Faktentabelle] --> I[Dimensionstabelle 1]     H --> J[Dimensionstabelle 2]     H --> K[Dimensionstabelle 3]   end      subgraph Snowflake Schema     L[Faktentabelle] --> M[Dimensionstabelle 1]     M --> N[Unterdimension 1]     M --> O[Unterdimension 2]     L --> P[Dimensionstabelle 2]     P --> Q[Unterdimension 3]   end 
Quelle: AI Generated