Day 2: Normalization | Data Modeling in 5 Days

What You'll Cover Today

Day 2 of Data Modeling in 5 Days builds directly on Day 1. You're moving from theory into applied practice. The concepts today require the foundation from yesterday, so if anything felt unclear, review it now.

ℹ️

Topics today: 1NF-3NF, BCNF, denormalization. Each section has code you can copy and run immediately.

1NF-3NF

Understanding 1NF-3NF is the core goal of Day 2. The concept is straightforward once you see it in practice — most confusion comes from skipping the mental model and jumping straight to implementation. Start with the model, then write the code.

1NF-3NF

# 1NF-3NF — Working Example
# Study this pattern carefully before writing your own version

class 1NF3NFExample:
    """
    Demonstrates core 1NF-3NF concepts.
    Replace placeholder values with your real implementation.
    """
    
    def __init__(self, config: dict):
        self.config = config
        self._validate()
    
    def _validate(self):
        required = ['name', 'type']
        for field in required:
            if field not in self.config:
                raise ValueError(f"Missing required field: {field}")
    
    def process(self) -> dict:
        # Core logic goes here
        result = {
            'status': 'success',
            'topic': '1NF-3NF',
            'data': self.config
        }
        return result


# Usage
example = 1NF3NFExample({
    'name': 'my-implementation',
    'type': '1nf-3nf'
})
output = example.process()
print(output)

💡

Key insight: When working with 1NF-3NF, always start with the simplest possible case that works end-to-end. Complexity is easier to add than simplicity is to recover.

BCNF

BCNF is the practical application of 1NF-3NF in real projects. Once you understand the underlying model, BCNF becomes the natural next step.

💡

Pro tip: When working with BCNF, always read the official documentation for the exact version you're using. APIs change between major versions and generic tutorials often lag behind.

denormalization

denormalization rounds out today's lesson. It connects 1NF-3NF and BCNF into a complete picture. You'll use all three concepts together in the exercise below.

Common Mistakes on Day 2

Skipping the fundamentals — 1NF-3NF requires understanding the underlying model before you can apply it correctly. Read the section twice if needed.
Ignoring error messages — error messages for BCNF are usually precise. Read them carefully before searching online.
Hard-coding values — anything that might change between environments belongs in configuration, not in your source code.
Not testing edge cases — the happy path is not enough. What happens with empty input? With unexpected types? With network failures?

📝 Day 2 Exercise

Normalization — Hands-On

Set up your environment for today's topic: install required tools and verify the basics work before writing any logic.
Implement a minimal working version of 1NF-3NF using the code example in this lesson as your starting point.
Extend your implementation to incorporate BCNF — this is where the two concepts connect.
Test your implementation with both valid and invalid inputs. What happens at the boundaries?
Review your code: is there anything you'd name differently? Any function doing more than one thing? Refactor one thing.

Day 2 Summary

1NF-3NF is the foundation of today's lesson — understand it before moving on.
BCNF is how you apply it in real projects.
denormalization ties the day's concepts together into a complete pattern.
Error handling and input validation belong in the first version, not as an afterthought.
Read error messages carefully — they usually tell you exactly what's wrong.

Challenge

Extend today's exercise by adding one feature that wasn't in the instructions. Document what you built in a comment at the top of the file. This habit of going one step further is what separates engineers who grow fast from those who stay stuck.

←

← Previous

Day 1: ER Diagrams

Day 3: Dimensional Modeling

→