I speak Spanish (I'm from Latin America). And of all the videos in my language that I saw, with none I could understand or only found complicated explanations and mostly without examples. And I find it incredible that I ended up in this video and with the subtitles I could understand much more than with any other video. Step by step and simple explanation. This is how everyone should teach. Thank you very much, greetings.
00:03 BCNF is a more restrictive form compared to 3NF 00:50 Candidate key is important in functional dependencies. 01:36 There are two candidate keys in the table. 02:21 Functional dependency and candidate keys 03:23 Voter ID is a candidate key and all functional dependencies are given in the table 04:17 The table should be in BCNF and the third normal form 05:13 The Second Normal Form 06:05 To determine if a table is in third normal form, check for transitive dependency
I'm currently in this leacture and not bored for even single second...the way he teaches is godly... Just want to write my opinions... Thank you Varun sir!!
Hats off to you, sir! I have seen Normalization questions in so many interviews which has made me nervous about this topic. This is such a difficult concept to understand, but the way you explained all the details was simply brilliant. Watching your videos has quelled my fear of Normalization.
All the lectures of this channel are superb and have appropriate and excellent content. The way of explaining things is outstanding....this is probably the best channel for students who want to learn DBMS 👍👍
I recently admissioned in bca and for first semester I have to learn DBMS thank God I got ur channel ,I hope atleast I will get help in tougher chapters from ur videos .Thank you sir for helping us...😊
Sir hats off, I am from ECE background and working professional as AEE in PSU last 3 years but still I am understanding your all vedio. Its amazing teaching style. With love 🙏🙏🙏 for delivering the best content for us.
Gajab air Kya padhate ho Sir aap isi Tarah you tube pe free classes continue rakhiye Aur sir languages ki playlist start kijiye Jaise Java, c, python ki
I am doing software engineering from Pakistan and from semester 1 i am watching your videos before one day of exam and get good marks your videos are very helpful in completing my degree you make videos on each subject of Software engineering Thank you so much
You are doing such a great job sir ! I have learnt DBMS from u.Ur explanatios are very simple nd to the point ! Keep it up ! Looking forward for your help for the next semester also .
Sir, In a table there can't be more than one candidate key. In this example, roll_no and voter_id are forming candidate by combining. At the time 2:12 In the first functional dependency roll_no->name and here roll_no is a prime attribute which is referring to partial dependency as it is determining name which is a non prime attribute. So how can first FD is a valid FD? This is not in 2NF. How can this satisfy BCNF rule? If i am wrong, then Sorry Sir in advance
sir roll number alone c.k. kaise bna h yaha pr ?...jbki c.k. { rollnoVoterid } dono h...isse phli wali video me toh aapne mna kra tha ...3nf wali video me 2nd example me jb usme{AB CD } 2 c.k thi toh c ->b f.d. me aapne mna reject kr diya tha ...
Thank you sir for great and easy explanation on Normalisation topic...keep uploading more videos I want to learn DBMS from your video lectures...beacuse they are easy to pick ...thnxx ❤️❤️
I have a doubt, this particular example does not satisfy 2NF or 3NF right ? cz PA:{Roll No., Voter Id} NPA:{Name, Age} and the very first FD is Roll no. --> Name. Here a NPA is dependent on a PA so it should be false for 2NF and hence for 3NF ???
if any question, they ask check whether this table is in BCNF 3NF 2NF 1NF or not. If not then make this table in BCNF 3NF 2NF 1NF so plz tell how to solve that particular question.
Thank you very much sir🤗🤗🤗 ..That is my final exam of dbms yesterday ... but I did not understand the topic of normalization and their forms ...🙄🙄🙄 Trust me ... After watching all your videos related to this topic 🤗🤗... I could easily understand it - thanks a lot ..😚😚😚🙏🙏🙏..
As per my knowledge to be even 2NF every non key attribute must be part of entire composite primary key. Here isnt name partially dependant on voter_id and age partially dependent on roll_no.Would love a clarification thanks
Love u brother.. hats off to ur teaching style..💜💜 it would be of much better help if u could upload the video for 4th and 5th normalization... waiting for those...😊😊
The example that you have mentioned in the beginning, doesn't satisfy the 2NF condition, right? Because in 2NF, the LHS has to have a subset and not a proper subset of candidate keys like mentioned in your previous videos. Please kindly clarify!
Sir I think last diagram mein, center me 1NF hona chahiye and last circle me BCNF. Because, inner most circle mein jo bhi hain wo definitely outer circle ke part hai but outer circle wale elements jaruri nahi inner circle ke ho.
I watched many videos on this topic but i did not got, now i am happy that i am prepared for my tomorrow's DBMS paper, thankyou soo muchh sir, you are Smart+ Intellegent+Handsome😊
Hi, I'm really happy to see these videos. Wonderful explanation. In this particular video I have a doubt. While considering the FDs you have skipped another FD ROLLNo -> Age. Is it also a FD that we can consider?
roll number is a candidate key, so if a candidate key is determining the non prime attr, it is valid and in 2nd nf. If candidate key is a composite candidate key and a part of candidate key is determining the non prime attribute then it will not be in 2nd nf.
Sir already said there are two candidate keys (not composite key) both roll no and voter id are candidate keys not a subset thus 2nd nf resolved as non prime attribute is derived from candidate key only and no partial dependency Hope it helped you Just go again through this video and 2nf video
this normal form is not is 2nf as name which is subset of non prime attributes determined by proper subset of candidate key which is Roll no ? Can you explain?
no there is no violation as Roll No and Voter id are two different candidate key and that is not proper subset of candidate key. Non-prime attribute is determined by candidate key. Hope u got your answer.
Thank u so much sir. Thanks a lot for your free lectures. Sir if possible pls upload videos on algorithm, c programming and data structures . May ur effort gets rewarded.
Transitive dependency is not only seen for transitive property observed in the FD'S but also that voterid is a candidate key,as he told,only case which forbids a relation from being in 3rd normal form is non prime attribute determining another non prime attribute ,what you told is a prime attribute(voterid) determining a non prime attribute(age) which is within the conditions to satisfy the relation for being in 3rd normal form.
I speak Spanish (I'm from Latin America). And of all the videos in my language that I saw, with none I could understand or only found complicated explanations and mostly without examples. And I find it incredible that I ended up in this video and with the subtitles I could understand much more than with any other video. Step by step and simple explanation. This is how everyone should teach. Thank you very much, greetings.
If you're able to speak or understand hindi then definitely you'll fall in love with these lectures.
Thats good to hear buddy
wow!
Which country you r from
@@Gamingpotatoxx9 spain
00:03 BCNF is a more restrictive form compared to 3NF
00:50 Candidate key is important in functional dependencies.
01:36 There are two candidate keys in the table.
02:21 Functional dependency and candidate keys
03:23 Voter ID is a candidate key and all functional dependencies are given in the table
04:17 The table should be in BCNF and the third normal form
05:13 The Second Normal Form
06:05 To determine if a table is in third normal form, check for transitive dependency
I'm currently in this leacture and not bored for even single second...the way he teaches is godly...
Just want to write my opinions... Thank you Varun sir!!
Chtya jaisa to padha tha hai ye
I watch your videos on 2x and that's just amazing as well as time saving
I prefer 1.5x👍
Me too alwayd
@@explorer2375 🙄
@@explorer2375 you are so sweet can we contact
Same
One of the best DBMS teacher one could get . Amazing sir, looking for more from you .
Hats off to you, sir! I have seen Normalization questions in so many interviews which has made me nervous about this topic. This is such a difficult concept to understand, but the way you explained all the details was simply brilliant. Watching your videos has quelled my fear of Normalization.
Sir, the two gems in your lectures are first your explanation in hindi and second is your examples relating with real world.
All the lectures of this channel are superb and have appropriate and excellent content. The way of explaining things is outstanding....this is probably the best channel for students who want to learn DBMS 👍👍
ThankYou Gourav...Your appreciation motivates me a lot..GOD bless you..Keep learning and sharing.. I have also completed operating system..
Bro it's been 5 years now could you tell me what are you doing now
I recently admissioned in bca and for first semester I have to learn DBMS thank God I got ur channel ,I hope atleast I will get help in tougher chapters from ur videos .Thank you sir for helping us...😊
Aj se pehele kisi ne itna acha nhi samjaya. Appreciated for all the efforts.
Thank You for your love and support. Bless you
Gate Smashers bless you too
nice teaching, excellent teaching. Writing and talking in English helps me to understand. I love you brother.
Sir hats off, I am from ECE background and working professional as AEE in PSU last 3 years but still I am understanding your all vedio. Its amazing teaching style. With love 🙏🙏🙏 for delivering the best content for us.
Sir YOU ARE GREAT !! Literally conquered a 5 mark question in 5 minutes! Hat’s off to you👏🏻
Can we talk?
Thanks!
Very clear tq so much sir.............very good explanation in exam point of view.............
I just want to tell you that your way of teaching is superb. God bless you Sir.
Thank you sir for giving excellent teaching on Normalization in DBMS.
From the starting to the end of the video he means alot i mean every word he utter has its precise teaching the best tutor i have ever seen
I always depend on your channel for my preparation.. thanks a lot for the most understable lectures...😊
Explanation is flawless n very clear
Your hard work and dedication reflect on your face.....nic teaching.....thank you sir....keep it up and I wish that 1M should cross as soon :)
Thank you so much.. Keep learning and sharing
Gajab air Kya padhate ho
Sir aap isi Tarah you tube pe free classes continue rakhiye
Aur sir languages ki playlist start kijiye
Jaise Java, c, python ki
I am doing software engineering from Pakistan and from semester 1 i am watching your videos before one day of exam and get good marks your videos are very helpful in completing my degree you make videos on each subject of Software engineering Thank you so much
Best educational content creator!!🙌
You are doing such a great job sir !
I have learnt DBMS from u.Ur explanatios are very simple nd to the point ! Keep it up ! Looking forward for your help for the next semester also .
Really great lectures. Super duper.
Thank you sir very nice gide & very nice best boyce codd normal form teaching information video.👍
Vaise to ladka hu pr tera dedication dekh ke kiss kr ne ko mann kiyaa
Bro tu great hai yrr 🙏🙏🙏🙏😘😘
bhaiyaaa maujjj kradiii, ty sirrr maza aagya padh ke !!
Excellent teaching sir.... Great teacher u r.. Outstanding ☺☺☺
Sir u are great 👍👍 your way of teaching is excellent.. Because of you I always perform well in the exams... Thanks a lot for your lectures 🙏🙏 🙏 🙏 🙏
Sir, In a table there can't be more than one candidate key. In this example, roll_no and voter_id are forming candidate by combining. At the time 2:12 In the first functional dependency roll_no->name and here roll_no is a prime attribute which is referring to partial dependency as it is determining name which is a non prime attribute. So how can first FD is a valid FD? This is not in 2NF. How can this satisfy BCNF rule?
If i am wrong, then Sorry Sir in advance
Excellent teaching in a very simple manner....
sir roll number alone c.k. kaise bna h yaha pr ?...jbki c.k. { rollnoVoterid } dono h...isse phli wali video me toh aapne mna kra tha ...3nf wali video me 2nd example me jb usme{AB CD } 2 c.k thi toh c ->b f.d. me aapne mna reject kr diya tha ...
Your way of teaching is superb
YOUR way of teaching is really good sir, well explanation of all concept sir
Thanku sir you are my favourite teacher
Sir you teach really well. Huge Respect
Thank you sir for great and easy explanation on Normalisation topic...keep uploading more videos I want to learn DBMS from your video lectures...beacuse they are easy to pick ...thnxx ❤️❤️
In this example, rolln0 -> name, is it in 2nd normal form ??
We are checking BCNF, but it is not even in 2nd normal form
exactly
Roll no and Voter I'd are two different candidate keys so rollNo is not a proper subset of Candidate Key and hence this is in 2NF
I have a doubt, this particular example does not satisfy 2NF or 3NF right ? cz PA:{Roll No., Voter Id} NPA:{Name, Age} and the very first FD is Roll no. --> Name. Here a NPA is dependent on a PA so it should be false for 2NF and hence for 3NF ???
Supperb bro.. Thank you.. my doubt was cleared with Ur video after lots of other videos
Thank you Sir, your lectures are literally very good Sir.
Thank you so much sir your explanation is to good for understanding purpose it's becoming very helpful in exam sir so thanks again sir
Love your teaching method sir💖
if any question, they ask check whether this table is in BCNF 3NF 2NF 1NF or not. If not then make this table in BCNF 3NF 2NF 1NF so plz tell how to solve that particular question.
Thank you very much sir🤗🤗🤗
..That is my final exam of dbms yesterday ... but I did not understand the topic of normalization and their forms ...🙄🙄🙄
Trust me ... After watching all your videos related to this topic 🤗🤗... I could easily understand it - thanks a lot ..😚😚😚🙏🙏🙏..
Bhat sahi explain krte ho aap
As per my knowledge to be even 2NF every non key attribute must be part of entire composite primary key. Here isnt name partially dependant on voter_id and age partially dependent on roll_no.Would love a clarification thanks
Waheguru Ji bless you veer ji and your family veer ji ❤️❤️🙏🏻🙏🏻
Great explaination👍
Thank you sir.
The way you teach is so good
You makes every topic as it is very simple.
DBMS playlist 2018 and in 2024after 6 years stil as best playlist on whole TH-cam ❤🔥😍🫡🫡🫡🫡🫡🫡🫡🫡🫡🫡🫡🔥🥵
sir thank you very much understood all forms in one go
Neat explanation,thank you sir!
Love u brother.. hats off to ur teaching style..💜💜
it would be of much better help if u could upload the video for 4th and 5th normalization...
waiting for those...😊😊
The example that you have mentioned in the beginning, doesn't satisfy the 2NF condition, right? Because in 2NF, the LHS has to have a subset and not a proper subset of candidate keys like mentioned in your previous videos. Please kindly clarify!
That is the condition when there is a composite key but here there are two primary keys and not a composite key
too late for the reply ik
Great explanation sir.. ⚡💫
Today is my exam and I am learning from your lecture now I am not tense about my exam
All the best
@@GateSmashers thanks sir for the great explanation my exam got superb. Thanks for the awesome teaching.
Thanks a lot Sir.Excellent teaching
Nice your lecture
Sir
Thanks for your efforts.......... commendable job sir :)
isnt voilating 2NF? rollno determining name as roll no is proper subset of CK
exactly that's what i'm thinking
At 2:58, how can only RollNo be a candidate key??
I think it's kinda wrong because of votrid->roll no as rollno is a prime attribute and bcnf says prime attribute shouldn't appear on the RHS
No on rhs anything is possible Only on lhs we must have CK
@@ragnarT3 oh
To be honest I don't remember anything it's been an year
I refer many books but the content you gave is the best thankyou so much sir
Sir I think last diagram mein, center me 1NF hona chahiye and last circle me BCNF. Because, inner most circle mein jo bhi hain wo definitely outer circle ke part hai but outer circle wale elements jaruri nahi inner circle ke ho.
Exactly
@@memorableshots2905 are you preparing for gate?
Nope.
I'm from pakistan
Sir the last diagram was reverse i guess because 1nf is followed by all... universal set will be out of all the subsets ??
You are amazing thank you
Good bless youu❤🇩🇿🇩🇿🇩🇿
thnku sir...a gya smaj
I watched many videos on this topic but i did not got, now i am happy that i am prepared for my tomorrow's DBMS paper, thankyou soo muchh sir, you are Smart+ Intellegent+Handsome😊
Thank you so much.. All the best
Thank you so much. Really helpful
Sir ..Is it in 2nf? Roll _> name violate 2nf.there is a partial dependency
no
there is no partial dependency. as the name is fully dependent on the candidate key which is roll.
I have same doubt
Yeah bro I got same doubt
@@nag0074 Can you elaborate?
Nice way of teaching 👌
Best explanation ever
Very good explanation 👍
Hi, I'm really happy to see these videos. Wonderful explanation. In this particular video I have a doubt. While considering the FDs you have skipped another FD ROLLNo -> Age. Is it also a FD that we can consider?
in 1st example don't you think there is partial dependency as voterId which is part of candidate key can determine non-key attribute
Voterid is defining age which is non prime attribute and voterid is a part of candidate key isn't that partial dependency...anyone ????
votarId also determine Rollno then VotarId+={votarId, age, Rollno,Name} so it is a Alone Ck as well , so it is valid.
Sir, The table is not in 3NF as it is not in 2NF bcz proper subset of C.K (Roll no.) is determining a non prime attribute that is name.
roll number is a candidate key, so if a candidate key is determining the non prime attr, it is valid and in 2nd nf.
If candidate key is a composite candidate key and a part of candidate key is determining the non prime attribute then it will not be in 2nd nf.
Roll no must be primary key because Roll No is unique
Great videos sir
2:16 how it can be in 2nd normal form as there is partial dependency.
i also had the same doubt. Hope anyone reading this can clear the doubt?
Sir already said there are two candidate keys (not composite key) both roll no and voter id are candidate keys not a subset thus 2nd nf resolved as non prime attribute is derived from candidate key only and no partial dependency
Hope it helped you
Just go again through this video and 2nf video
@@lshubham3692 ohh yess understood I misread the C.K. ... thanks for helping
@@shreyasgosavi9647 you are welcome
Sir please make a video on 4NF also.
good explanation
this normal form is not is 2nf as name which is subset of non prime attributes determined by proper subset of candidate key which is Roll no ? Can you explain?
no there is no violation as Roll No and Voter id are two different candidate key and that is not proper subset of candidate key. Non-prime attribute is determined by candidate key. Hope u got your answer.
Sir you are a great teacher
Thank u so much sir. Thanks a lot for your free lectures. Sir if possible pls upload videos on algorithm, c programming and data structures . May ur effort gets rewarded.
Please share the video for fourth normal form
thank you sir for last minute revisions❤️
Nicely Explained.
Nice video thank you sir
Par sir transitive dependencies bhi to hai
Rollno-- voterid-- age
*@Akshansh rightly pointed this out. It's not even in 3NF. How it can be in BCNF? Smasher explanation is wrong.*
@@vijaydalalin It is not because VoterId is a primary attribute.
Transitive dapendancy non prime attribute> non prime
Transitive dependency is not only seen for transitive property observed in the FD'S but also that voterid is a candidate key,as he told,only case which forbids a relation from being in 3rd normal form is non prime attribute determining another non prime attribute ,what you told is a prime attribute(voterid) determining a non prime attribute(age) which is within the conditions to satisfy the relation for being in 3rd normal form.
Your all video is superb nd plz upload the video of 4nf nd 5nf form of normalization
Waheguru ji bless you and your family veer ji ❤️❤️🙏🏻🙏🏻
Thanks sir 2021 worth watching it.
I always prefer in 2x ... If there would be greater than this speed I definitely prefer that😊just awesome lectures 😌😌thnk you sirji
Sir your speed is suitable for 90% of the students so maintain the same speed.
amazing keep it up
Sir it example not obey 2NF because here partial dependency present. How it is bcnf?
Sir plzz get a video on 4NF and 5NF and also on Mulitivalued dependencies..Will be waiting for your videos on these topics..
Yeap,am also
Awesome teaching 🔥