Boyce-Codd Normal Form (BCNF) | Database Normalization | DBMS

In this video, you will learn about the Boyce-Codd Normal Form, which is popularly known as BCNF, with help of the simplest database example ever.

You will also learn how to design a table which follows the Boyce-Codd normal form? What are the rules and requirements for a table to be in the BCNF?

If you LIKE this video, give it a thumbs up and do SUBSCRIBE to our channel.

[paulluke]

3 videos of less than 15 minutes explained my 1-hour lecture of 45 slides. Your work is amazing AND I LOVE IT!

[andrewschatz]

I spent 2 hours watching my professor's lectures, 1 hour reading the textbook, and 15 minutes watching your videos. Guess which one of those 3 was the most beneficial?
I cannot believe how easily you explained it. You are truly a master of the world of databases.

[JerseySlayer]

Everything you learn about databases is common sense. Then, they use 500 key terms and nomenclature and you forget what the hell they were ever talking about. Boiled down explanations like this are all you need. A 4 minute video that educates in a way I can't forget. Appreciate the video, a whole lot!

[dushananuradha]

I recommend this playlist for those who seek concise explanations on normalization relations. This lecturer has perfectly explained all the normalization relations around 5-6 minutes, whereas a typical SE lecturer would take hours creating a huge confusion.

[devpiush]

6 years later its still helpful to me for my college, thanks a lot !!

[socratears]

When the video ended, I did not expect it to be *4 MINUTES SHORT*. You have me gaGGING at how incredibly simple and educational your videos are.

[nanananaejm]

I tried to understand this with myself for weeks.... but you made me fully understood in 5 minutes. WOW

[muhammedaizazhaider]

Simply O MY GOD! spent 2 days understanding BCNF and this explained it in less than 5 minutes!!! can't believe. After all those non-sense bullshit with drowning into never-ending thousand's of key terms, composite, prime, super, candidate, alternate, foreign and loads of trivial non trivial dependencies, attribute closures etc. This lecturer is a GEM! U deserve at least a million SUBS!

[lenubis]

Thank you for this, my professors keep using functional dependencies in (A -> B) form only to explain 2NF, 3NF, BCNF, and it gets so confusing, these vids were really helpful :)

[dam]

Almost four years later and this is still great! Thank you so much, this set of videos certainly helped me understand this somewhat dense material.

[priyanshudebnath]

Best video till now to explain normalization in the whole YouTube.

[ash]

thank you very much 2 lectures 3 days study trying to understand but only ur 3 small videos works with me thanks a lot

[avishekgazmere]

These videos are so simple to understand. Thank you very much for putting this into the universe!

[bhavyar]

All my 4 years of engineering, I have followed studytonight. I just love it. Thank you sir for this. You are amazing. YOu are awesome! Its amazing how we can learn so much from a free resource. Thank you A big thanks!!.. thank you * 100!

[fjm]

The way you explained it, my professors never could! Brilliant work, Sir! Thanks a ton. :)

[PegassiLampadati]

These videos saved me 2 hours of lecture time and 81 slides of powerpoint!

[sumansarkar]

Thankyou!! Watching this video almost after 6 years of its posting date. Incredible explanation, is what I can say being a seasoned database implementationist. Good job!! 👍🏻👍🏻❤️

[shravanideshpande]

Amazing nf series, I had surfed entire yt but no other video could beat this.
Here explanation is the fabulous

[masonscott]

You, my man, are a certified legend. You got the gift bro. Thanks for the great videos!

[MrRavibains]

You explained these concepts better than anyone else out there