4.2 Database Decomposition Example: By hand 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 and perform database decomposition by example. This video shows the step by step process of decomposing relations into BCNF.

The last video in this series did an example following the slides and can be seen here:    • 4.1 Database Decomposition Example: S...  

This example is a hand written one.

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.

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...