Talk Is Cheap, Show Me The Code
Codekilla
CODEKILLA
back to course
Lesson 217 / 29873%
SQL Normalization8/8

Functional Dependencies

X → Y — given X, Y is determined.

// normalization · clean a messy table step by stepRaw tablecomma-separated values · transitive deps1NFatomic cells · one value per row × column2NFevery non-key column depends on the FULL PK3NFno transitive deps · split out address → zip tableid | name | courses | zip → city1 | Asha | "math,phy,chem" | 110001 → "New Delhi"2 | Ravi | "math,bio" | 110001 → "New Delhi"
Visual explanation diagram · click steps to walk through it

This lesson is Pro only.

Unlock every premium lesson and module — Pro from ₹299 / month (or ₹999 / year, saves ~₹2,589).

Sign in to unlock
// feedback.matters()
Did this lesson help you?