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.
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....
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
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.
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.
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.
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
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 please upload lecture on dependency preserving no one can explain this concept on TH-cam accurately like you .you are great and gorgeous teacher.sir please net exam near a rha so please upload this topic
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?
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.
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.
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🙏
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 !!
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
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 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
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. :)
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. :)
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
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...
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.
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.
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!
For complete DBMS, check out this video: th-cam.com/video/YRnjGeQbsHQ/w-d-xo.html
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 😊
refernce
hindi=white shirt
english=black shirt
Sahi bola bhai
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
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
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.
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
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 !!
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
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 😂
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.
This is what known as passion for teaching!
which is very rare nowadays.
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.
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 👍😊
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.
watched full ads to help sir.
us moment.
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 !
You are Great Teacher Sir!!!....so much dedication and so clear concept, thanks for such videos Sir!!
one of Most clear concept of Normalization on youtube
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👍
🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg
🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg
Thank you so much for the video series!! Best professor on TH-cam.
hey nothing , just wanna ask hows life going after btech?
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 think no one can beet you in explaining computer science. Ur teaching is really awesome sir.thank you
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 😒
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 👍😊
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 please upload lecture on dependency preserving no one can explain this concept on TH-cam accurately like you .you are great and gorgeous teacher.sir please net exam near a rha so please upload this topic
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?
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
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..
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
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 !!
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
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❤
You're most welcome, Abdul. Glad to know that you are liking our content, stay connected for more amazing videos & content👍
Thank you sir ji ...For those who dislike this video "BETA TUMSE NA HOPAYEGA"
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 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
Skip to 01:17 if you have exam tomorrow and play the video in 1.25X speed :)
Thank you sir very nice gide & very nice best explain boyce codd normal form teaching information video.👍
Glad you liked it, Ashish, thanks for following our content. Stay connected for more amazing videos & content👍
2:05 cool ................... the way of your teaching
Perfect explanation. Sir, please upload video for 4NF and 5NF also.
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 👍😊
Great Lecture Sir!!!!
Thank you so much dear Vinayak :) keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
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. :)
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. :)
thank you for the clear explanation. It would be helpful if you cover 4th normal form
hi sir..U r teaching is really awesome..u understood the concept very well...
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
Well done sir...I love the way you delivered you're lectures...
Great explaination on all topics of DBMS
skip to 1:18
Superb, brief ,succint and worthwhile!!!
jump to 4:14 if you are in hurry
Thanks a lot sir.. Normalization seems to be the easiest topic now
Sir , your videos are a great contribution to the benifits of online teaching . Great work ! Keep going :-)
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...
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.??
nice sir,but i cannot find your video on 4NF ,5NF and relation algebra,relational calculas.
My college student wait for this.
tq sir ❤
You're welcome dear @Raju❤ Keep learning & supporting! Stay connected for more amazing contents & videos 👍
This video is not actually about the performing BCNF but when you need to perform BCNF.
Thanks for uploading helpful tutorials.
Pls upload 4nf and 5nf lectures as soon as possible.
Pls skip 👉🏻 1:18 save your time 😊
Best tutorials i've ever come across..wowww..Please do videos on practical parts(SQL).plzzzz.Big thanks..
thanx sir. nice lecture. plzz upload more videos. waiting eagerly
thank u sir....its very useful to me in understanding concepts...plzz upload more videos
Nice video clear explanation
04:15 if u have exam tomorrow
Thanks sir for all the videos good and easy explanation
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.
It would make things so much more easier if you can explain it using an employee table or student table
Amazing explanation!
Sir,Thanks a lot for wonderful interesting lecture,please clarify How convert this table into BCNF.
Video starts from 1:19
I just wish u how lucky I would be if uh were my cs teacher.
skip to 1:25 if you have an exam tomorrow :)
Sir thanks a lot.. The videos are just awesome :) 12 on 10
super explanation...
Thanku sir pls also make videos on 4nf, 5nf and relational algebra
Sir, please can you make some vedio on query optimization? That will be very helpful.
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, 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.
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.:)
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
Hey thanks a bunch for your wonderful videos. You are amazing and funny. I really enjoy your videos.Thank you so much :)
Amazing explaining..But Sir, I think you should go through 2 or 3 examples instead of only one..
please upload 4NF and 5NF also with all cases!!!!
this is 4NF
@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 ??
From AB we can find C and from C we can find B. I laughed so hard on this!
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
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 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?
Sir, when you upload video on multivalued dependence and 4NF. We are egarly waiting for that.
There is a mistake at 5:17. We can find C using A and B using C. So A is prime attribute
sir, please upload videos of Multivalued Dependencies(MVD). Your videos are just awesome and it helped me alot. Thank you!!!
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!