4.11 BCNF Boyce Codd Normal Form

📝 Please message us on WhatsApp: wa.me/91800012...
💻 KnowledgeGate Website: www.knowledgeg...
📲 KnowledgeGate Android App: tiny.cc/KG_Offi...
➡ Do not miss our Bestseller Courses:
🔴 GATE Guidance-2025: www.knowledgeg...
🟠 GATE Guidance-2026: www.knowledgeg...
➡ Contact Us:
🟩 Whatsapp Chat: wa.me/91859512...
📞Call on: [phone]
🟦 Telegram Updates: t.me/kg_gate
🟩 Whatsapp Updates: www.whatsapp.c...
📧 Email: [e-mail]
➡ Our One Shot Semester Exam Videos: 👇
▶ Operating System: • Complete Operating Sys...
▶ DBMS: • Complete DBMS Data Bas...
▶ Computer Network: • Complete CN Computer N...
▶ Digital Electronics: • Complete DE Digital El...
▶ Computer Architecture: • Complete COA Computer ...
▶ Data Structure: • Complete DS Data Struc...
▶ Algorithm: • Complete DAA Design an...
▶ Software Engineering: • Complete Software Engi...
▶ Theory of Computation: • Complete TOC Theory of...
▶ Compiler: • Complete CD Compiler D...
▶ Discrete Maths: • Complete DM Discrete M...
➡ Free Subject-Wise Complete PlayList: 👇
▶️ DBMS: tiny.cc/kg_yt_DBMS
▶️ Operating System: tiny.cc/kg_yt_OS
▶️ TOC|Automata: tiny.cc/kg_yt_toc
▶️ Computer Networks: tiny.cc/kg_yt_CN
▶️ Digital Electronics: tiny.cc/kg_yt_D...
▶️ Compiler Design: tiny.cc/kg_yt_C...
▶️ Computer Architecture: tiny.cc/kg_yt_COA
▶️ Data Structure: tiny.cc/kg_yt_D...
▶️ Algorithms: tiny.cc/kg_yt_A...
▶️ Set, Relation, Function: tiny.cc/kg_yt_D...
▶️ Graph Theory: tiny.cc/kg_yt_g...
▶️ Group Theory: tiny.cc/kg_yt_g...
▶️ Proposition: tiny.cc/kg_yt_p...
#knowledgegate #GATE #sanchitjain
*********************************************************

[@KNOWLEDGEGATE_kg]

For complete DBMS, check out this video: kzbin.info/www/bejne/j4PRm3qbhsemfrM

[@rahulsingh-lv5xp]

refernce hindi=white shirt english=black shirt

[@aai3795]

Sahi bola bhai

[@LowLifeGraphicsProgrammer]

Not Indian. Still enjoyed watching... Nice video!

[@nimishgupta5289]

Knowledge don't have boundaries, so the Knowledge gate.

[@Some1s_story]

Are you from China or Japan or Korea.

[@zorith]

Maybe India ?

[@SohelDarwajkar]

Because enjoyment doesn't have any boundaries Brother 😊

[@playstationgaminghub4124]

Hi Sir, I used to watch your videos in my college days. Here I am back again watching your videos for my Interview preparation. Your channel is the go to channel when it comes to DBMS.

[@KNOWLEDGEGATE_kg]

Thanks a lot Shubham.. Do visit our website www.knowledgegate.in for more courses and content. Keep learning and supporting !!

[@yashshamnani7602]

Hello actually i want to know is this lecture series complete according to interview preparation

[@akhileshjoshi8484]

dedication level : PRO ! liked the energy with which you try to teach concepts.. Way to Go ! :) Thnx for such amazing explanation :)

[@anubhavsethi3416]

1x pe dekho sari energy dikh jayegi LOL

[@itsashima]

Sir your videos are like sanjeevani for students who can't afford teachers. Thank you so much. Sir you are really doing a great work. Thanks once again sir.

[@roshanpandey5357]

01:17 if you have your exams tomorrow, thank me after your exams :)

[@shambhavi0abha]

Thanks!

[@priyagupta-xp5wz]

In 2 hours :P

[@parthpatel9602]

Thanks

[@priyagupta-xp5wz]

@@neelmehta9092 it was very easy :D

[@saurabhkanswal7954]

Thanks Bhai

[@ryt2prateek]

Prime Attribute on RHS of FD is allowed in the case of 3NF 3NF allows 2 condition: 1. Either LHS should be super key OR 2. RHS should be Prime Thats why BCNF is stricter than 3NF since it does not allow condition number 2, but it is allowed in 3NF

[@silentgecko2854]

I like how sometimes he switches languages and I'm like "wut" but I still understand 500 times more than when my fluent english lecturer explains it.

[@subhamsarkar251]

Ravonne Matthews he can speak English just like your fluent English speaking teacher ,just because he mention in the name of the video "in Hindi " he is switching sometime to that language ..

[@Jeetu0301]

NO coaching institute teaches this topic better than him. Concept, lots of problems practice and what else you want. Great stuff.

[@mohdnasirjamal7539]

We start with hello friends, we're discussing about dbms and covered....... And end up with aaj k liye Itna hi.... Akhir hm apni bhasha pe aa hi jaate h. But videos are quite interesting and easy to learn the things... I love the way you teach....

[@dr.kunalmishra7816]

Sir..@ 3:08 3NF can be explained like this: A table is in 3NF if it is in 2NF and for each functional dependency X-> Y at least one of the following conditions hold: X is a super key of table (or ) Y is a prime attribute of table But according to you left hand should be prime or non prime ???? Please Clear Sir.

[@praveenugiri]

Your DBMS playlist helped me to revise quickly and now I got a new job. Thank You 🙏 😊

[@KNOWLEDGEGATE_kg]

Wonderful ! Many congratulations dear, all the best, Keep progressing ! keep learning & supporting !!

[@mariamkhan8152]

i loved your videos you have explained each and everything very clearly. your videos helped me to perpare for my exam within 2 hours

[@harshthakkar8806]

And I love you 😂

[@saitejamothe6162]

skip to 1:18

[@cartoon_hub08]

Pls skip 👉🏻 1:18 save your time 😊

[@KNOWLEDGEGATE_kg]

🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg 🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg

[@AfaqKhan]

Thanks, covered the theory well, a real-world example would have been a cherry on top !

[@snehalataprustyhowwonderfu1860]

I am getting knowledge about dbms purely from kg.very very thanks .agar dec se pehle dbms normalization ke bache hue parts ke video miljate to achha hota.

[@himalayanlife6917]

Sir your videos are super.. I love your explanation ,it clears my all doubts in very few time .. and made logically strong.... Thank u a lot sir...

[@snehalataprustyhowwonderfu1860]

exam pass aa rahenhe na isliye.ek bat kehni thi, agar ap jese professor hamare college main hote,sayad humko itni taklib na hoti.very very thanks for your mindblowing teaching method.

[@pavannayaka8106]

Skip to 01:17 if you have exam tomorrow and play the video in 1.25X speed :)

[@sitansubiswas]

This is what known as passion for teaching! which is very rare nowadays.

[@ADITYASINGH-ih2hz]

jump to 4:14 if you are in hurry

[@adityachouhan1389]

You are Great Teacher Sir!!!....so much dedication and so clear concept, thanks for such videos Sir!!

[@danishazad1]

one of Most clear concept of Normalization on youtube

[@bread_yt93]

watched full ads to help sir.

[@bread_yt93]

us moment.

[@sahilprasantachoudhury911]

Video starts from 1:19

[@aparnanaik8181]

Thank you so much for the video series!! Best professor on KZbin.

[@allmarvelcontent]

hey nothing , just wanna ask hows life going after btech?

[@aanchalgoyal5922]

Isn't it cool, the way sir said "cool"😂😂❤️....very nice video 🇮🇳🇮🇳

[@KNOWLEDGEGATE_kg]

Haha thank you! Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@rajeswariputatunda5093]

Inke vedios dekhkar koi aisa nhi hoga jisko kuch pata hi nhi hoga agr man bhi na de to tab bhi dimag mey kuch na kuch ghus hi jaega

[@KNOWLEDGEGATE_kg]

Hahaha thanks a lot dear, stay blessed 😍 keep learning & supporting 👍😊

[@vkdosaya]

skip to 1:25 if you have an exam tomorrow :)

[@harpreetsandhu7697]

Sir please upload lecture on dependency preserving no one can explain this concept on KZbin accurately like you .you are great and gorgeous teacher.sir please net exam near a rha so please upload this topic

[@hannanahmed1587]

Your explaining is good and your examples are good. One question that I would raise is that where are the tables ? where are real time examples using tables ? Making A B C D E F and joining arrows that is a good work to teach basics, but this is a thing that I can do now in front of a class after listening your brilliant basic tutorials of 1 2 3 NF, Disappointing thing is that when we deal with real example in case of tables, that is where actual problem arises. That is completely missing.

[@adityasood11]

Sir ,The video ends abruptly. How will the relations divide for BCNF or will we simply remove the f.d C->B because C is not a super key?

[@gshrey17]

04:15 if u have exam tomorrow

[@mayankyadav-zs6rs]

Perfect explanation. Sir, please upload video for 4NF and 5NF also.

[@sravanimudhiraj1150]

I think no one can beet you in explaining computer science. Ur teaching is really awesome sir.thank you

[@shuklaization]

Sir You have not discussed the properties of 4-NF and 5-NF though you had promised to explain them.Please explain them too. I have watched all your videos. They are awesome.Thankyou

[@lordrageop7]

4NF and 5NF is not important.

[@ameyamahadevgonal8130]

@@lordrageop7 but it is in our syllabus 😒

[@merocastle]

thank you for the clear explanation. It would be helpful if you cover 4th normal form

[@Comedy_Short_Scene]

i am a big fan of you sir......thanku so mush sir .....you do the great expansion..all our queries are cleared after watching your vedio again a big thankuuuuu sir

[@himanshugupta5812]

Sir nice to see that whenever you teach you previously revise the concepts which is very good and thank you so much sir Pls reply sir I can't find your 3nf video

[@aditibose3486]

Sir,in his video explanation for BCNF you didn't explain till end how are we going to eliminate C->B ?? Do we have to remove this and make a separate relation consisting of B and C attributes?

[@tanyaplovesmusic]

yes, please. the video ended abruptly!

[@debankur2987]

will it be AC->B since ac is a superkey?

[@rounak6971]

actually u hv to fragment the original relation into R1(c->b) n R2(ab->c)...ans

[@rohitkumar-lj2ru]

I think the final answer will be R1 (A,B, C) and R2 (B,C)

[@AlesaGillespie]

what that fuck u asking

[@rishavanandshorts]

2:05 cool ................... the way of your teaching

[@vilasini1131]

Please teach in english fully so that ppl who dnt know hindi understands better. Anyways great job loving your teaching. Simple and neat. Able to understand better. Thankyou!🤗

[@cyber_gaming5422]

Sir you are boom , I saw your viedo at 2x speed but still I get the things at once only , thankyou sir for making normalisation easy.👍🙏🏻

[@KNOWLEDGEGATE_kg]

Keep it up, Visit tiny.cc/yt_kgwebsite for more helpful content and courses👍

[@royvj4055]

Great work..very well understood the concepts. Thanks.

[@KNOWLEDGEGATE_kg]

Hi Roy, we truly appreciate your kind words for our efforts.We upload more topics every week, Please subscribe this channel for best GATE tutorials. :)

[@supriyavshahapur8246]

hi sir..U r teaching is really awesome..u understood the concept very well...

[@ravipratp76]

Thank you sir ji ...For those who dislike this video "BETA TUMSE NA HOPAYEGA"

[@ajaylatwal5157]

Superb Lecture Sir..Please make a lecture on file organization and indexing as well

[@KNOWLEDGEGATE_kg]

Hi Ajay, Thank you so much for showing your interest, We are working on "File Organization and indexing". Please subscribe our channel to follow all updates. :)

[@ash_engineering]

please upload MVD , 4NF and 5NF videos also .. your explanation are really very easy to comprehend, and I really dont understand these topics at all. I am preparing for GATE 2017

[@ashishtayade047]

Thank you sir very nice gide & very nice best explain boyce codd normal form teaching information video.👍

[@KNOWLEDGEGATE_kg]

Glad you liked it, Ashish, thanks for following our content. Stay connected for more amazing videos & content👍

[@meme_engineering4521]

you see, these videos are very helpful, you understand this logic

[@KNOWLEDGEGATE_kg]

Thank you dear ❤️Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@PrateekGupta26]

Thanks a lot sir.. Normalization seems to be the easiest topic now

[@abdulghaffarshah2722]

I am following your playlist.of dbms sir your way of teaching is amazing and it is very helpful for students thanks for your kindness❤

[@KNOWLEDGEGATE_kg]

You're most welcome, Abdul. Glad to know that you are liking our content, stay connected for more amazing videos & content👍

[@vivekmodi3165]

Thanks for uploading helpful tutorials. Pls upload 4nf and 5nf lectures as soon as possible.

[@talentedbanda9919]

Great explaination on all topics of DBMS

[@sushilmaurya6260]

nice sir,but i cannot find your video on 4NF ,5NF and relation algebra,relational calculas. My college student wait for this.

[@vinayaksharma-ys3ip]

Great Lecture Sir!!!!

[@KNOWLEDGEGATE_kg]

Thank you so much dear Vinayak :) keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@ilyaskhan1084]

Well done sir...I love the way you delivered you're lectures...

[@nitishkumarsharma6326]

You have amazing explanatory skills. :) I am in Master's in Canada and just wanted to refresh my concepts of normalization and your series served the purpose completely in less than 2 hours for me. (even my prof here sucked at explaining this) :) Perfect. And the blend of Hindi/English is music to ears :) One thing though, your erred usage of "do/does/is" in English bug me a lot ;) although its a very small thing but it really hits me every time. If possible, please try to correct it. Anyways, awesome series.

[@raunakmaheshwari2034]

"Anyways" itself is wrong usage of English language and is mentioned in your comment. If possible, please try to correct it.

[@heeralkadam2388]

Really omg I doubt if you're really working in Canada omg always finding mistakes in others teaching is a psychic act and atleast he is trying to help others free of cost not showing off like you by commenting here merely . So go and show your fake skills somewhere else and try to appreciate others efforts .

[@MinhazMurks]

The funny thing is you are trying to correct his grammar but your grammar is awful: "erred usage of "do/does/is" in English bug me a lot" should be bugs* "...although its a very small thing but it really hits me every time." no need for but and you randomly capitalize words here and there, so please try to correct it.

[@harpreetsandhu7697]

Nitish Kumar Sharma first' correct your English okay.aaya bada master in canada.aata kuch hai nhi

[@athulkrishna2524]

wht a showoff..

[@vishalisrani772]

Sir , your videos are a great contribution to the benifits of online teaching . Great work ! Keep going :-)

[@crazeeealgorithms3236]

Superb, brief ,succint and worthwhile!!!

[@datchoob1978]

As a Hindi-speaking student in the states. I had a great laugh when you switched languages when I watched this in front of non-indian people.

[@SiddharthGargYT]

Where do you study?

[@mayankmalviya1095]

he said States means USA

[@chhatrapalnayak3946]

I had a great laugh when you tried here to show off

[@fadedthanahoee]

Sharing your learning experience isn't showing off and he is implying that he is viewing the videos in States so even non-Indian people enjoy Sir's video. This is a learning platform, stop with your nonsense here and move along if you don't like the comment instead of criticizing another student. Just Saying.

[@MeetYourArchitect]

show off ? really? come on...that's so gay.

[@STTPwithRajani]

Thanks a lot sir🙏 i can't express my feelings in words to appricate you, i am preparing for ugc NET if i will clear this exam than all credit to u sir... U r simply 'best' sir🙏

[@allmarvelcontent]

hi , hows life going after colllege

[@medhananjay9099]

sir left side always be a super key i.e. if lhs is prime attribute so there is no problem but the lhs should not be non-prime attribute but your telling that lhs can be prime or non prime which is wrong i think !!

[@sushmitanigam4979]

thanx sir. nice lecture. plzz upload more videos. waiting eagerly

[@devendragaud831]

This video is not actually about the performing BCNF but when you need to perform BCNF.

[@twinklethosar4861]

thank u sir....its very useful to me in understanding concepts...plzz upload more videos

[@DanielAngali]

Sir,Thanks a lot for wonderful interesting lecture,please clarify How convert this table into BCNF.

[@jameeltayeb967]

Thanks sir for all the videos good and easy explanation

[@kartikchauhan5498]

Sir, u should add annotations for skipping the part where you tell about ur last video...It would help the users to directly move to the part or content which belongs to the current video. But ur videos r way too awesome n ur teaching style is phenomenal...

[@anuarora630]

Nice video clear explanation

[@username-zg8og]

There is a mistake at 5:17. We can find C using A and B using C. So A is prime attribute

[@myitraju7996]

tq sir ❤

[@KNOWLEDGEGATE_kg]

You're welcome dear @Raju❤ Keep learning & supporting! Stay connected for more amazing contents & videos 👍

[@akashjain4184]

To sum up: 3nf: X->Y either X should be a S.K or Y is a Prime atrr. bcnf:X->Y X should be a S.K.

[@computeredutech7437]

Sir, please can you make some vedio on query optimization? That will be very helpful.

[@kummarguda]

It would make things so much more easier if you can explain it using an employee table or student table

[@nishu921]

Thank u very much for the videos...its helped me a lot....sir is it possible to get boyce codd, sql, and entity relationship tutorial?

[@shuvadipghosh1479]

Best tutorials i've ever come across..wowww..Please do videos on practical parts(SQL).plzzzz.Big thanks..

[@madnicse]

Amazing explaining..But Sir, I think you should go through 2 or 3 examples instead of only one..

[@prabh557]

Thanku sir pls also make videos on 4nf, 5nf and relational algebra

[@reenathomas7936]

super explanation...

[@dineshsisodiya9768]

sir, you have explained well all NF but you did not say anything about Dependancy preservation and lossless decomposition, Because these rules must be satisfied if the decomposition is correct.

[@avinashv1438]

Amazing explanation!

[@ApexSpeedster]

Thank you sir for great video

[@KNOWLEDGEGATE_kg]

Hi Vineet, Thank you so much, would like to hear more from you. We upload more topics every week, Please subscribe this channel for best GATE tutorials.:)

[@drbhupeshgour5801]

Sir, when you upload video on multivalued dependence and 4NF. We are egarly waiting for that.

[@manojchetry2961]

How can (AB) and (AC) be candidate key when a subset of it A is itself a superkey. Then A must be a candidate key.??

[@tejasworld8297]

I have lot of questions regarding ER diagrams can you place make classes and brief description on ER diagrams

[@vidyush96]

thnx sir fr the video...

[@VibeLenss]

Sir.. if you are tech or explain in hindi.. that are very helpful.. compared to English.. to plz make video in hindi..

[@purushotham.m]

Nice explanation. But sir sometimes u r using Hindi language but some students don't know hindi( who came from south rural like me). So plz add subtites sir. Thank you so much sir.

[@purushotham.m]

Thanks for ur reply sir. Miku Telugu vacha sir?

[@Trout_Nemesis]

How do you find a candidate key if the functional dependencies loop all the way around like A --> B, B --> CD, BD --> E, E --> A?

[@dipankersingh7186]

A, B and E are the candidate keys !

[@sowmyaarvapalli9097]

Dipanker Singh I guess even D is also a part of the candidate key If I'm not wrong...

[@airwing2899]

@@sowmyaarvapalli9097 no d alone can't find any attribute

[@sachinsingh9165]

sir A is also a candidate key a ->c and c->b so a->acb ,hence it is also a candidate key

[@poojachauhan2709]

Yes

[@zubairjeelani4380]

AB together determine C and not A alone. Please see that

[@sohomadhikary4105]

Sir, please upload a video for 4NF and 5NF.. I have an exam on february. Please sir

[@keysangyonthan]

2 years and the videos are still not up. hmm I have an exam tomorrow.

[@Di1eepNagendra]

@@keysangyonthan :D

[@saikumar-lc4gg]

U r very great sir

[@jaypaldhawale1003]

sir take a full example(from 1nf to bcnf) of normalization and show how write properly in exam .

[@syamantakdutta596]

Sir thanks a lot.. The videos are just awesome :) 12 on 10

[@simrangupta6193]

I just wish u how lucky I would be if uh were my cs teacher.

[@SafarPeChalen]

Try adding Examples , That'll make it more Efficient in learning .