Third Normal Form 3NF Explained With a Real Example

Third normal form (3NF) is the database normalization rule that stops the same data being stored in more places than it needs to be. This video walks through it with a real example you can follow table by table. You'll spot a transitive dependency, watch a table split into 3NF, see how 1NF, 2NF and 3NF compare, and learn the one case 3NF lets through that Boyce-Codd normal form (BCNF) catches. CHAPTERS 00:00 Intro 00:17 Why normalize a database? 00:49 What is third normal form (3NF)? 01:22 3NF requirements 01:54 Transitive dependency example 02:26 How to normalize a table to 3NF 03:02 Benefits and drawbacks of 3NF 03:37 1NF vs. 2NF vs. 3NF 04:07 3NF vs. BCNF 04:50 BCNF example 05:22 Recap RESOURCES The full 3NF guide, with every table and an FAQ on candidate keys, NoSQL and normalization tools: https://www.datacamp.com/tutorial/third-normal-form?utm_medium=organic_social&utm_source=youtube&utm_campaign=000000_1-third-normal-form_2-b2c_3-all_5-bl_8-ogsl-yt_10-bau Prove your SQL and database skills with the SQL Associate Certification: https://www.datacamp.com/certification/sql-associate?utm_medium=organic_social&utm_source=youtube&utm_campaign=000000_1-third-normal-form_2-b2c_3-all_7-ct_8-ogsl-yt_10-bau Design databases from scratch in the Database Design course: https://www.datacamp.com/courses/database-design?utm_medium=organic_social&utm_source=youtube&utm_campaign=000000_1-third-normal-form_2-b2c_3-all_7-le_8-ogsl-yt_10-bau Subscribe for more database and SQL explainers. #SQL #DatabaseDesign #DataCamp