21:28 Hairs and Beard is medium 21:33 Short Hairs and Beard. Wow Sir you are also a magician now I find out how you explain every topic in the best and easiest way. Thanks sir you are awesome.
You and Sanchit jain sir from Knowledge gate are making life easy for we students who are learning DBMS , thank you so much sir . We are very fortunate that you guys teach us so well that to on a platform like youtube …… thank you so much!!!!
I'm really great full to your videos....it makes my learning more easy and understanble which really feels great...thank you so much for your teaching 😊
please do correction for 2:31 because AB is a proper subset of candidate key.... and in previous videos you accepted such case like AB-->C where AB is a candidate key and C is not prime.... and you told if only A came in L.h.s instead of AB then it becomes prime attribute and can't be accepted .... there is no consistency in your teaching in the normalization rule .... please correct where necessary
Brother AB is just a subset. It is not a proper subset. Check the initial CANDIDATE KEY. In that AB is mentioned. Therefore AB can only be a subset of AB. ONLY A OR B can be a proper subset of AB.
Sir 1 doubt when the table was first splitted you took the same set of cks for the r1 table which were given in the question. Since c->d is removed from the table the ck set will also get modified right?
Sir,There exist Two tranisitive property b/w R1( ABCEF) AB-C and C-E & C-E and E-F.thats why I guess there will be 5 separate relation For 3NF R1(ABC) R2(CE) R3(EF) R4(FA) and R5(CD)... same as BCNF...
r1 ko BCNF k liye decompose krne ke baad joh 4 table aa rhen h unki funtional dependency toh origianl table se bilkul same h , koi change hi nhi h toh yahan BCNF functionallity preserving kr raha h ?
Sir one question is there...... Suppose there is one functional dependency which is not validating the property of PARTIAL DEPENDENCY but it is not also validating this property ->>> (Non Prime Attribute must be fully dependent on Candidate Key) then this functional dependency will be a valid for SECOND NORMAL FORM or not??? Sir please solve my doubt...I'll be very grateful
I must say, we are fortunate we got an opportunity to learn from you.Your free lectures are boon to us . Thank you so much sir.
21:28 Hairs and Beard is medium 21:33 Short Hairs and Beard. Wow Sir you are also a magician now I find out how you explain every topic in the best and easiest way. Thanks sir you are awesome.
You and Sanchit jain sir from Knowledge gate are making life easy for we students who are learning DBMS , thank you so much sir .
We are very fortunate that you guys teach us so well that to on a platform like youtube ……
thank you so much!!!!
Do not compare Sanchit sir and Varun sir bro, Gate smashers is way more better than THAT GUY
@@psych76 ha bhai 4 saal purane comment se ladai krle
@@YashMezzala stating a point, instagram nahi hai ye lmao
@@YashMezzala 😂
Sir,i am getting very much interest in DBMS because of your awesome teaching style......Thankyou very much Sir...
Amazing Sir, no one can teach normal form concepts THIS clearly except you!! I’m forever thankful to you for these lectures! 👏🏼
Its incredible how easy you make all these topics... DBMS, DAA, CN, OS... seen all playlists
I have watched all your videos so far in dbms. Hats off to your teaching skills.
Sir u clear my doubt by this lecture. According to my opinion u r best teacher
The way of teaching is literally Amazing .
Haircut @21:32
THE LECTURES
SHOULD BE PAID....thank you so much dear...sir, love and respect from PAKISTAN
You teach clearly... And you are best teacher in my opinion . Love you sir....
Thank you pooja
one of the best dbms playlist
What a teacher u r sir.❣️✨🔥
Ur way of teaching and explaining is just mind-blowing.Thankyou for all videos sir. God keeps u Happy Always.🙂🔥🙏✨
I don't have word to thank u sir u are a blessing for us 🙏
I'm really great full to your videos....it makes my learning more easy and understanble which really feels great...thank you so much for your teaching 😊
after a long time I got a good video. thanks bro
gr8 sir, keep making such good videos.
Really appreciate for Varun sir and gate smesher , thanks a lot sir towards all students
Wow Sir itne mushkil concept ko aapne kitne ache se samajhaya hai.😌😌
You are best teacher ❤ you cleared My all doubts 😊
Thank you sir, very well explained
please do correction for 2:31 because AB is a proper subset of candidate key.... and in previous videos you accepted such case like AB-->C where AB is a candidate key and C is not prime.... and you told if only A came in L.h.s instead of AB then it becomes prime attribute and can't be accepted .... there is no consistency in your teaching in the normalization rule .... please correct where necessary
Brother AB is just a subset. It is not a proper subset. Check the initial CANDIDATE KEY. In that AB is mentioned. Therefore AB can only be a subset of AB. ONLY A OR B can be a proper subset of AB.
Love your content! You have a great way of explaining things and making them easy to understand. Keep up the good work.❤❤❤❤
Mind blowing sir May god give u reward of it
Awesome! No words to say you thank you Sir! God Bless you..
Really amazing well explained concept.
Really very helpful video cleared all my doubts a great teacher i hope universities should have teachers like uh
Thnkew so much Sir . You teaching style are incredible. 👌👌
Thank you, Sir! for this wonderful lecture.
Thank you so much for this video. It was much needed
Best Normal Form explanation...💯💯💯
You are just amazing Sir!!........it's a blessing for me in this Lockdown!!!
Kya baat hai kya baat hai. Far better than my online classes.
But nothing is better than Online classes😥😥
Awesome, man.. The UGC syllabus is so fuckin' incomplete. I didn't understand their half of the syllabus due to incompletence. Great videos.
🧡
Well done.. Thanks sir... U have cleared my doubts
Awesome lecture sir
Sir.. Excellent class. No words to appreciate ur effort 👏👏👏👏
Awesome explanations sir...hats off
U hav excellently explained .
Thanku sir
ohhh yeahh.. great lecture sir
the quality of the lecture is far ahead of nptel lectures and many more youtube lectures keep it up sir😍
What a explanation sir😍😍😍😍😍😍😍😍😍😍😍😍thank you sir ..thank you so much....itni sundor se explain karne ke liye
What a great explanation :) Thank you.
@21:33 turant me enhone jajbat badal diya, duniya badal de......😳
thank you so much Boss.. hats off
Sir ur method is very fine and clear
May God give u all the happiness you wish
L.H.S must be Proper Set of any (C.K)
AND 11:37 11:37 11:37 11:37 11:37 11:37 11:37 11:37 11:37 11:37 11:37 11:37 11:37 11:37
R.H.S must be a Non Prime Attributes
Incredible teaching style 😊😊♥️
Superb Sir..... Thank you so much 🙏
sir ji lecture ke beech me Haircut karake aa gaye .. Legend :)
Best teaching method... Make vedios for dssb tgt also
best
teacher
ever
Superb. Thanks.
Thanks sir...you r great...
Just awesome!
Thankyou sir❤️. You are great...
THANKS A LOT SIR JI😊
there videos are true gem!
outstanding teaching .....
Thank you so much sir...
good explanation sir thank you.
Really great teaching!!!
Thank you sir 🙏🙏🇮🇳🇮🇳
Very nice..thank u😊
Your lectures are priceless
Thanks and welcome
thanks for all these efforts!
Padhta padhate Apna kam bhi karna zaroori hai.
Kisi ko kya hi pata chalega 😂
21:28
superb sir... thank u so much
11:14 sir apne 3nf me bcnf ka condition laga diya. 3nf me L.H.S should be prime attribute or R.H.S should be a prime attribute. Can anyone confirm?
Awesome lecture it was🖤
Sir 1 doubt when the table was first splitted you took the same set of cks for the r1 table which were given in the question. Since c->d is removed from the table the ck set will also get modified right?
crystal clear explanation
for R1 table
AB-->C,C--->E,E--->F,F--->A
then how CB is Candidate Key??
if we take CB+ ={ABCEF}
D is not present in this.
please correct it. 11:05
Really amazing you are.
Thank you so much sir
just two words : no words ❤
shaandar
Thank you Sir for this concept. Also I have one doubt do we have to reduce the given FD in minimal cover form then optimize to highest normal form???
You are great sir
Sir,There exist Two tranisitive property b/w R1( ABCEF) AB-C and C-E & C-E and E-F.thats why I guess there will be 5 separate relation For 3NF R1(ABC) R2(CE) R3(EF) R4(FA) and R5(CD)... same as BCNF...
is your doubt solved?
Thanks Sir
Jb ye table 2NF me h hi ni to 3NF me kaise ho gya?
thank you very much!
Useful to me 👍
thanks😇😇
Thank you so much sir
Clear understanding
life saving
r1 ko BCNF k liye decompose krne ke baad joh 4 table aa rhen h unki funtional dependency toh origianl table se bilkul same h , koi change hi nhi h toh yahan BCNF functionallity preserving kr raha h ?
God level🙏🙏
Sir aap ka Playlist dekhne par SQL, PLSQL ke saare concepts software side jaane ke liye clear hojayenge kya?? Please reply me sir.........
Content is very good sir. But there are a lot of adds. Please reduce them🙏
19:53 Liked it :)
Sir you said BCNP may or may not ensure lossless but 3NF always ensure correct from past video I remember this ?
21:35 sir padhate padhate baal bhi kata liye :-)
Last ka 3 min me to sir aap new haircut ke saath aaye hain..... Wo bhi r1,r3,and r4 ko join karane🙏👍😎🤘
Thanku sir ji
Sir one question is there......
Suppose there is one functional dependency which is not validating the property of PARTIAL DEPENDENCY but it is not also validating this property ->>> (Non Prime Attribute must be fully dependent on Candidate Key) then this functional dependency will be a valid for SECOND NORMAL FORM or not???
Sir please solve my doubt...I'll be very grateful