4.11 BCNF Boyce Codd Normal Form
HTML-код
- Опубликовано: 6 сен 2024
- 📝 Talk to Sanchit Sir: forms.gle/WCAF...
💻 KnowledgeGate Website: www.knowledgeg...
📲 KnowledgeGate Android App: tiny.cc/KG_Offi...
➡ Do not miss our Bestseller Courses:
🔴 GATE Guidance-2025: www.knowledgeg...
🟠 GATE Guidance Plus-2025: www.knowledgeg...
➡ Contact Us:
🟩 Whatsapp Chat: wa.me/91859512...
📞Call on: +91-8000121313
🟦 Telegram Updates: t.me/kg_gate
🟩 Whatsapp Updates: www.whatsapp.c...
📧 Email: contact@knowledgegate.in
➡ 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
*********************************************************
For complete DBMS, check out this video: ruclips.net/video/YRnjGeQbsHQ/видео.html
refernce
hindi=white shirt
english=black shirt
Sahi bola bhai
Not Indian. Still enjoyed watching... Nice video!
Knowledge don't have boundaries, so the Knowledge gate.
Are you from China or Japan or Korea.
Maybe India ?
Because enjoyment doesn't have any boundaries Brother 😊
dedication level : PRO ! liked the energy with which you try to teach concepts.. Way to Go ! :) Thnx for such amazing explanation :)
1x pe dekho sari energy dikh jayegi LOL
🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg
🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg
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.
Thanks a lot Shubham.. Do visit our website www.knowledgegate.in for more courses and content. Keep learning and supporting !!
Hello actually i want to know is this lecture series complete according to interview preparation
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.
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 ..
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
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.
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....
NO coaching institute teaches this topic better than him.
Concept, lots of problems practice and what else you want.
Great stuff.
Your DBMS playlist helped me to revise quickly and now I got a new job. Thank You 🙏 😊
Wonderful ! Many congratulations dear, all the best, Keep progressing ! keep learning & supporting !!
01:17 if you have your exams tomorrow, thank me after your exams :)
Thanks!
In 2 hours :P
Thanks
@@neelmehta9092 it was very easy :D
Thanks Bhai
i loved your videos you have explained each and everything very clearly. your videos helped me to perpare for my exam within 2 hours
And I love you 😂
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.
Where do you study?
he said States means USA
I had a great laugh when you tried here to show off
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.
show off ? really? come on...that's so gay.
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.
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.
This is what known as passion for teaching!
which is very rare nowadays.
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.
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...
Thanks, covered the theory well, a real-world example would have been a cherry on top !
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
Hahaha thanks a lot dear, stay blessed 😍 keep learning & supporting 👍😊
Thank you so much for the video series!! Best professor on RUclips.
hey nothing , just wanna ask hows life going after btech?
You are Great Teacher Sir!!!....so much dedication and so clear concept, thanks for such videos Sir!!
Isn't it cool, the way sir said "cool"😂😂❤️....very nice video 🇮🇳🇮🇳
Haha thank you! Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
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.
"Anyways" itself is wrong usage of English language and is mentioned in your comment. If possible, please try to correct it.
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 .
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.
Nitish Kumar Sharma first' correct your English okay.aaya bada master in canada.aata kuch hai nhi
wht a showoff..
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?
one of Most clear concept of Normalization on youtube
Thank you sir ji ...For those who dislike this video "BETA TUMSE NA HOPAYEGA"
Sir please upload lecture on dependency preserving no one can explain this concept on RUclips accurately like you .you are great and gorgeous teacher.sir please net exam near a rha so please upload this topic
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
4NF and 5NF is not important.
@@lordrageop7 but it is in our syllabus 😒
I think no one can beet you in explaining computer science. Ur teaching is really awesome sir.thank you
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.
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.👍🙏🏻
Keep it up, Visit tiny.cc/yt_kgwebsite for more helpful content and courses👍
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
you see, these videos are very helpful, you understand this logic
Thank you dear ❤️Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
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!🤗
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?
yes, please. the video ended abruptly!
will it be AC->B since ac is a superkey?
actually u hv to fragment the original relation into R1(c->b) n R2(ab->c)...ans
I think the final answer will be R1 (A,B, C) and R2 (B,C)
what that fuck u asking
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 !!
nice sir,but i cannot find your video on 4NF ,5NF and relation algebra,relational calculas.
My college student wait for this.
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
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...
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🙏
hi , hows life going after colllege
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
Perfect explanation. Sir, please upload video for 4NF and 5NF also.
This video is not actually about the performing BCNF but when you need to perform BCNF.
thank you for the clear explanation. It would be helpful if you cover 4th normal form
2:05 cool ................... the way of your teaching
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.
Superb Lecture Sir..Please make a lecture on file organization and indexing as well
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. :)
watched full ads to help sir.
us moment.
Thanks a lot sir.. Normalization seems to be the easiest topic now
Great work..very well understood the concepts.
Thanks.
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. :)
Great explaination on all topics of DBMS
hi sir..U r teaching is really awesome..u understood the concept very well...
Sir , your videos are a great contribution to the benifits of online teaching . Great work ! Keep going :-)
Thanks for uploading helpful tutorials.
Pls upload 4nf and 5nf lectures as soon as possible.
Well done sir...I love the way you delivered you're lectures...
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.??
Great Lecture Sir!!!!
Thank you so much dear Vinayak :) keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
Superb, brief ,succint and worthwhile!!!
jump to 4:14 if you are in hurry
It would make things so much more easier if you can explain it using an employee table or student table
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.
The concept is explained very nicely but stop using Hindi language. If your focus is totally in India , then there is no problem but people like me from other countries can also watch if your medium of teaching is completely english. Good job.
skip to 1:18
Thanks sir for all the videos good and easy explanation
thank u sir....its very useful to me in understanding concepts...plzz upload more videos
thanx sir. nice lecture. plzz upload more videos. waiting eagerly
@Sanchit Sir I am confused about this video. Why you choose AC as CK because C has an incoming edge. I think only AB should be a candidate key ??
04:15 if u have exam tomorrow
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?
Sir, please can you make some vedio on query optimization? That will be very helpful.
Best tutorials i've ever come across..wowww..Please do videos on practical parts(SQL).plzzzz.Big thanks..
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?
A, B and E are the candidate keys !
Dipanker Singh I guess even D is also a part of the candidate key
If I'm not wrong...
@@sowmyaarvapalli9097 no d alone can't find any attribute
Nice video clear explanation
Thanku sir pls also make videos on 4nf, 5nf and relational algebra
Sir,Thanks a lot for wonderful interesting lecture,please clarify How convert this table into BCNF.
Hello, please someone help me;
If ı have a table JKL and ı have the functional dependencies JK->L and L->K ; JK and JL as keys. How can ı decompose this table into BCNF. If I decompose it as LK and JK tables than ı loosed the dependecy JK->L so how can I decide and move on after that?
I just wish u how lucky I would be if uh were my cs teacher.
Sir.. if you are tech or explain in hindi.. that are very helpful.. compared to English.. to plz make video in hindi..
Amazing explaining..But Sir, I think you should go through 2 or 3 examples instead of only one..
sir take a full example(from 1nf to bcnf) of normalization and show how write properly in exam .
Sir, please upload a video for 4NF and 5NF.. I have an exam on february. Please sir
2 years and the videos are still not up. hmm I have an exam tomorrow.
@@keysangyonthan :D
Thank you sir for great video
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.:)
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.
Thanks for ur reply sir. Miku Telugu vacha sir?
I have a doubt i hope you would see this message and reply me. before designing relational model we design the er model but when we come to relational model we decompose some tables and then no no of tables will imcrese then in that case the number of entities in er model will be different from the number of relation in relation model since the entities of er diagram is converted to a table in relation model then how can we say that this er model logically reprents the final database?? I hope you will reply me soon sir.
sir, how to check this relation for 2NF ?
R(A, B, C, D)
A -> B
B -> C
C -> {B, D}
Yes, it is in 2 NF, Basically we need to check whether there is a partial dependencies or not?
Definition for partial Dependency is Non-prime attribute depending on part of a candidate key or prime attribute.
In the above question, candidate key is A(single). So, no above relation depending on the prime atrributes. Hence it is in 2 NF.
Sir, when you upload video on multivalued dependence and 4NF. We are egarly waiting for that.
sir, please upload videos of Multivalued Dependencies(MVD). Your videos are just awesome and it helped me alot. Thank you!!!
Video starts from 1:19
super explanation...
sir, I have a question how can AC be a candidate key as c has one incoming edge from AB??
Yes sir please tell
I think only A is candidate key
Because AC closure gives R
Sir in dis video u r saying dat c is deriving B But in d first video of FD u explained it as you can find the value of c wid d help of B. Plzzz make it clear
I have lot of questions regarding ER diagrams can you place make classes and brief description on ER diagrams
Sir thanks a lot.. The videos are just awesome :) 12 on 10
From AB we can find C and from C we can find B. I laughed so hard on this!
please upload 4NF and 5NF also with all cases!!!!
this is 4NF
Skip to 01:17 if you have exam tomorrow and play the video in 1.25X speed :)
sir A is also a candidate key
a ->c and c->b so a->acb ,hence it is also a candidate key
Yes
AB together determine C and not A alone. Please see that