4.1 Database Decomposition Example: Step by step decomposing relations into BCNF

Now that we know formally what Boyce-Codd Normal Form represents for decomposed relations, we can expand on the basic example in the previous video with this more in-depth walk through. This video shows the step by step process of decomposing relations into BCNF. This video is part of a series on database normalization, and a larger course on Databases.

If you have not already seen our video on database anomalies decomposition and Boyce-Codd Normal Form please find it here:    • 4.0 Database Normalization: anomalies...  

We see how to use decomposition to break apart relations into ones that are free of these anomalies. This video ends by explaining what Boyce-Codd Normal Form (BCNF) is and shows a basic example of how to decompose relations to it.

Please like this video and subscribe and would like to see more like it!    / @codingcoach  

This video is part of a full semester course given on databases and application integration:    • {DBMS - Database Management Systems -...  

If you learning computer science, you might also find this playlist interesting where we explore exactly how your programs run on a real computer:    • Little Man Computer - Understanding M...  

Here is a link to slides used in this presentation: https://drive.google.com/file/d/1ew1S...

Book used in this course: Garcia-Molina, Hector. Database systems: the complete book. Pearson Education India, 2008.
https://www.amazon.com/Database-Syste...