Learn Boyce-Codd Normal Form (BCNF)

An easy-to-follow & comprehensive explanation of Boyce-Codd Normal Form (BCNF), with examples. After watching this video, you'll understand BCNF and the key concepts that enter into the BCNF definition, for example "prime attribute", "non-prime attribute", "candidate key". And you'll understand exactly how BCNF improves upon Third Normal Form (3NF).

[imafraidjumitebeeinnagang]

It's insane how much knowledge is condensed in this video. I legit sat down for 40 minutes with pen and paper and after going through the entire video, I feel so satisfied with everything.

[luuu_na]

My brain blown up when reading these definitions, like "What?".
Thanks for simplifying it in a way I can understand!

[bantaibaman]

Absolutely magnificent. SO clear, concise, with great examples, raising and answering all questions, and also very technical. Take my like, sir.

[tbxmcbs]

Thanks for putting your time and energy in putting together this amazingly effective tutorial.

[thiagomariz]

As I was struggling to understand this topic through my university lectures and book, I found this gem on YouTube and now I finally understand database normalization. Crystal clear explanation and with real examples. THANK YOU VERY MUCH! It would be nice to see an explanation on transactions!

[andrewbenyeogor]

was having problems doing an an assignment but came across your videos, and my problems was truly decomplexified... nice tutorials. Hoping you'll create more videos. Thank you.

[stanleyaloh]

The key to understanding this explanation is to understand candidate keys, prime attributes and non-prime attributes are clearly. This is wonderful job by the creator. Amazing and super clear content

[JackLeiLing]

This is the best tutorial about database normalisation I have had. You have made such a complex concept so easy to understand. Many thanks 🙏

[lukegrapentine]

I find it crazy this channel is under 1000 subs. Top-tier content that is easy to follow. Great stuff looking forward to seeing more
.

[KC-hkub]

Your vid on normal form appeared in my feed because I've been learning SQL online. Despite not having a clue what it meant, I watched and found it to be very interesting. It led to this video which I've been spending the afternoon with. I will certainly be watching all of your videos now because they seem to be very relevant, and as a self learner, I am extremely grateful to find such a high quality resource. Thank you!

[babakbehravesh]

At lease spent a few days searching different resources to know what is additional benefit BCNF has over 3rd NF. Some made me even more confused. I saw this one and should say hats off! Great explanation and was covering many of the edge cases I had in mind. Thanks a ton!

[silverjuan]

Keep this quality up and you’re going to be real popular real fast.

[rahulpanwar]

I've been searching so much the answer to the question that why would we need bcnf over 3nf. And you can try googling it, none of the website or blogs are properly answering it. But finally got it here and it is well put, so thanks.

[giovannyf]

Amazing video, I have spent over a hour reading and watching other videos and was left confused. This 10 min video did more than all others combined, Thank you!

[samhepditch]

Thank you I especially appreciate how you described why the definition of 3NF necessitates BCNF!

[vhlmqot]

Now I can return to my project feeling like I am in normal form

[rahulthaker]

Thanks for this video. I hope you can make more videos on DBMS. You can also make a playlist where you explain concepts which are majorly asked in interviews.

[wildmanofhk]

This is by far the best explanation ever!

[scarlettran-]

i was so struggling to get the idea. thank you so much sir, you ARE really better than my professor.

[takumicrary]

Great videos. The pacing and structure of all of these make it really accessible.