Why we need bcnf

Before you continue with Boyce-Codd Normal Form, check these topics for better understanding of database normalization concept:. Follow the video above for complete explanation of BCNF. Or, if you want, you can even skip the video and jump to the section below for the complete tutorial.

In our last tutorial, we learned about the third normal form and we also learned how to remove transitive dependency from a table, we suggest you to follow the last tutorial before this one.

For a table to satisfy the Boyce-Codd Normal Form, it should satisfy the following two conditions:. The second point sounds a bit tricky, right? One more important point to note here is, one professor teaches only one subject, but one subject may have two different professors. Hence, there is a dependency between subject and professor here, where subject depends on the professor name. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy. Popular Course in this category. Course Price View Course. Tweet Share Email. What are the requirements for Boyce-Codd Normal Form?

Was this page helpful? Thanks for letting us know! Email Address Sign up There was an error. Please try again. You're in! Thanks for signing up. There was an error. Tell us why! More from Lifewire. Full Functional Dependency in Database Normalization. Putting a Database in First Normal Form. For this reason it is frequently termed 3. This may happen in tables with two or more overlapping composite candidate keys.

By: Justin Stoltzfus Contributor, Reviewer. By: Satish Balakrishnan. Dictionary Dictionary Term of the Day. Natural Language Processing.