Database Systems with SQL - Full Course - Database Systems - Boyce-Codd Normal Form - BCNF Normalization and Table Denormalization

Normalization gets rid of redundancy in your table by decomposing a table into two or more tables in higher normal form. When a value in a column is related to at most one other value in another column, then those two columns depend on each other. If you have a table that does lots of updates, inserts or deletes, then the Boyce-Codd normal form is right for you. BCNF is an extension of the third normal form. For a table to be in Boyce-Codd normal form (BCNF), then if column A depends on column B, then B must be unique. To normalizing a table to Boyce-Codd normal form, first list the unique columns (simple or composite), and then identify and remove the dependencies on non-unique columns. There are sometimes when you actually want redundancy in your database, so that you can query reports much faster. This is called denormalization. You can denormalize the table by having redundancy on purpose by merging tables together, and putting the tables back to first or second normal form. Subscribe to Appficial for more programming videos coming soon. Also, don't forget to click LIKE and comment on the video if it helped you out!