3NF (EN)

3NF Normalization Steps

flowchart TD     A[Original Table] --> B{Check 1NF}     B -->|Fulfilled| C{Check 2NF}     B -->|Not fulfilled| D[Eliminated partial dependencies]     C -->|Fulfilled| E{Check 3NF}     C -->|Not fulfilled| F[Eliminated transitive dependencies]     E -->|Fulfilled| G[3NF achieved]     E -->|Not fulfilled| H[Eliminated transitive dependencies]     D --> G     F --> G     H --> G     G --> I[Final 3NF tables] 

In Context

• Typically used together with 1NF and 2NF
• Related to: Normalization, BCNF, Database design
• Example use: Reduction example of customer data with address attributes