Database design made easy, part 5: Boyce-Codd Normal Form

Boyce-Codd Normal Form (BCNF) is the logical step after Third Normal Form: not just all non-key columns, but ALL columns, must depend on the key, the whole key, and nothing but the key. Why is this important and how can you achieve it? And what about the rare cases where BCNF is impossible to achieve? For more in-depth database design training, check out my seven and a half hour course on relational database design on Pluralsight: https://www.pluralsight.com/courses/relational-database-design