If you think you understand the normal forms of database normalization (1NF, 2NF, 3NF / BCNF, etc.), the simple table that's the subject of this video may cause you to think again.
??Get the guidebook: https://decomplexify.org/t-dbnorm - this is my simple, step-by-step guide for mastering normalization and the normal forms.
0:00 Setting the trap
1:10 Primary key confusion
2:52 Oh, Atomic... Oh, Atomic
5:17 Redundancy - or is it?
7:10 Redundancy Part 2
7:44 No normal form violation - or is there?
8:00 A part-key dependency
8:58 Now your failure is complete
9:18 The aftermath
11:29 Analysis
13:41 An education problem
14:22 Starting over
14:58 Resources
15:28 A Decomplexify Normal Forms guidebook
16:48 An AI chatbot meltdown
17:46 Closing words