4.11 BCNF Boyce Codd Normal Form

[@KNOWLEDGEGATE_kg]

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

[@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 😊

[@rahulsingh-lv5xp]

refernce hindi=white shirt english=black shirt

[@aai3795]

Sahi bola bhai

[@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

[@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

[@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.

[@KNOWLEDGEGATE_kg]

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

[@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....

[@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 ..

[@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 !!

[@MishraSumit08]

Pls skip 👉🏻 1:18 save your time 😊

[@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 😂

[@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.

[@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.

[@adityachouhan1389]

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

[@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.

[@AfaqKhan]

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

[@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 👍😊

[@danishazad1]

one of Most clear concept of Normalization on youtube

[@aparnanaik8181]

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

[@allmarvelcontent]

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

[@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👍

[@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

[@sitansubiswas]

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

[@sravanimudhiraj1150]

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

[@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 👍😊

[@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 👍😊

[@ravipratp76]

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

[@rishavanandshorts]

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

[@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.

[@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

[@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!🤗

[@supriyavshahapur8246]

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

[@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👍

[@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👍

[@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

[@talentedbanda9919]

Great explaination on all topics of DBMS

[@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. :)

[@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 !!

[@pavannayaka8106]

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

[@ilyaskhan1084]

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

[@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?

[@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 😒

[@crazeeealgorithms3236]

Superb, brief ,succint and worthwhile!!!

[@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. :)

[@mayankyadav-zs6rs]

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

[@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 !!

[@sushmitanigam4979]

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

[@merocastle]

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

[@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

[@vishalisrani772]

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

[@PrateekGupta26]

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

[@bread_yt93]

watched full ads to help sir.

[@bread_yt93]

us moment.

[@vivekmodi3165]

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

[@twinklethosar4861]

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

[@jameeltayeb967]

Thanks sir for all the videos good and easy explanation

[@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

[@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.

[@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..

[@shuvadipghosh1479]

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

[@devendragaud831]

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

[@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...

[@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.??

[@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

[@sahilprasantachoudhury911]

Video starts from 1:19

[@sushilmaurya6260]

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

[@anuarora630]

Nice video clear explanation

[@vkdosaya]

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

[@kummarguda]

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

[@smritapokharel5983]

Hey thanks a bunch for your wonderful videos. You are amazing and funny. I really enjoy your videos.Thank you so much :)

[@gshrey17]

04:15 if u have exam tomorrow

[@saitejamothe6162]

skip to 1:18

[@simrangupta6193]

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

[@ADITYASINGH-ih2hz]

jump to 4:14 if you are in hurry

[@syamantakdutta596]

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

[@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.

[@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.:)

[@DanielAngali]

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

[@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?

[@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?

[@reenathomas7936]

super explanation...

[@prabh557]

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

[@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.

[@adrijabandyopadhyay505]

happy teacher's day, sir :) your videos are fantastic and all the concepts are explained so simply that it's really helped me a lot. thank you so much

[@VibeLenss]

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

[@madnicse]

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

[@computeredutech7437]

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

[@username-zg8og]

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

[@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

[@jaypaldhawale1003]

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

[@cameronelwood8874]

Hey thanks so much for these videos they help alot. Id suggest maybe adding a little editing when you switch languages, just for clarity sake. Keep up the good work my dude!

[@tejasworld8297]

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

[@ayatullahbajkani4832]

6:55 how the c becomes a prime attribute???

[@anshgyl]

"C" becomes prime attribute as it is part of the candidate key "AC"

[@waseemullah5230]

@@anshgyl how it can be a part of candidate key if it is already a non prime???

[@theworld4595]

bada vla thankuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu so much

[@KNOWLEDGEGATE_kg]

You're most welcome dear student, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@drbhupeshgour5801]

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

[@FaizanKhan-un9bx]

Sir plzzz upload the video of triggers and cursors also............