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 Normaliza...
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 Manag...
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 - ...
Here is a link to slides used in this presentation: drive.google.com/file/d/1ew1S...
Book used in this course: Garcia-Molina, Hector. Database systems: the complete book. Pearson Education India, 2008.
www.amazon.com/Database-Syste...
9 сен 2020