This was the most correct video logically as the explanation of all these keys. I was always with these keys and thought these concepts are just to confuse readers. Thanks Sanchit Sir. As a short note Super key us the set of attributes from which you can uniquely identify a row or a tuple in the table. Key = Super Key Candidate key is the super key whose proper subset itself is not a super key. A Primary key is candidate key selected by DBA as a primary key to identify a row or a tuple in the DB
The one and only candidate key by which we can understand all the concepts easily is SANCHIT JAIN SIR.....Thnxx a lot sir for providing such great videos🙏
sir your whole playlist is amazing... its really help me out with all DBMS related doubts. keep uploading new content sir.. and at the end thanks a lot sir.
Actually Sir, you are a primary key(unique & best) from a lot of entity(Teachers) in entity set(Teaching Field). God selected you as a primary key. ❤❤❤❤
sir please make videos on other subjects of cse too because you are fabulous no one can teach like you , aapse padhne ke saath saath hi yaad ho jaata dimag me baith jaata hai cheeje
You are one of the best teacher. Your capacity of repeating one thing in each video again n again do not let us to forget anything n helps in better understanding. Thank you!
You awesome sir jii .. the way of explaining every point is marvaoulus .. you r too good .. Maine kv DBMS and OS itne asaani s nhi samjha tha jitna Aapne smjhaya ... Thanks a lot and God bless you .
I came to your channel for just one video related to OS but i'm here, watching all videos now. Kudos! Such easy and effective explanations. One of the best on youtube.
Thank you so much for your valuable feedback ❤ Keep learning & supporting! You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
thank u sir ,its only now I understand the difference between super key and candidate key... aap subject ko bahoothi asaani thareeki se samjaraahi ho...
Our education system needs more people like you...♥️♥️the way u give the examples is just awsm 🖤..nd one of the most important thing is that u taught us free of cost 🤙🤙🤙#Thanks a lot sir
You're most welcome dear @Astik😍keep learning! Do like, subscribe & share our videos, you can also visit our website www.knowledgegate.in for more amazing videos & contents👍
Sir u r awesome bahuton ko bolte suna h ki me wada krta hu last tk tmhe sb smg aa jaaega pr koi smga ni ska pr apne in 21 minute me hi pura concept hi clear krwa dia thanku sir❤❤
very nyc sir kabhi socha nahi tha yeah topic bhi seekh pauga but u made it possible if someone wants to learn normalization watch knowledge gate from 3.1 to 4.12 must watch
Thank you for the kind words dear❤ Keep supporting & stay connected for more amazing contents👍😊 You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
Thank you so much dear for your valuable feedback, stay blessed❤ keep supporting & stay connected for more amazing contents👍😊 You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
You can use augmentation in D -> A and transform it into DB -> AB. Then transitivity can be used with AB -> C to give DB -> C which can then be unioned with DB -> ABC to give DB -> ABCD which is a super key.
Thank you so much❤ keep supporting & stay connected for more amazing contents👍😊 You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
For complete DBMS, check out this video: th-cam.com/video/YRnjGeQbsHQ/w-d-xo.html
Sir really GOD n aap ko but expressive skill Di h....aap ka video dek k lgta h ki DBMS bhi bhut aasaan h jab aap jse SIR ho...GOD bless u SIR....
Right
Sir plzz upload a video series of how to convert ER diagram in to a relational model... As soon as possible
Yes u r right not only DBMS operating system ... Also
Sir I must say that there's no better explaination and simplification in the world than this lecture. Wish you alot of blessings sir
Thank you Mohit for your valuable feedback.. Stay blessed !! Keep learning and supporting !!
This was the most correct video logically as the explanation of all these keys. I was always with these keys and thought these concepts are just to confuse readers. Thanks Sanchit Sir.
As a short note
Super key us the set of attributes from which you can uniquely identify a row or a tuple in the table.
Key = Super Key
Candidate key is the super key whose proper subset itself is not a super key.
A Primary key is candidate key selected by DBA as a primary key to identify a row or a tuple in the DB
The one and only candidate key by which we can understand all the concepts easily is SANCHIT JAIN SIR.....Thnxx a lot sir for providing such great videos🙏
sir your whole playlist is amazing... its really help me out with all DBMS related doubts. keep uploading new content sir.. and at the end thanks a lot sir.
@3:17 this is something which no one tells and that's why I love Knowledge Gate:):)
the perfect teacher, as soon as i gather a doubt when u complete a sentence , in the next sentence only u clear that doubt. :) brilliant sir :)
Actually Sir, you are a primary key(unique & best) from a lot of entity(Teachers) in entity set(Teaching Field). God selected you as a primary key. ❤❤❤❤
sir please make videos on other subjects of cse too because you are fabulous no one can teach like you , aapse padhne ke saath saath hi yaad ho jaata dimag me baith jaata hai cheeje
one of the best teacher on youtube with great teaching skills
One of the best keys explanation in youtube.
*The* Best
extra ordinary for student like us.. you are making dbms,os interesting to the student like me.. at 13:56 "B" won't be there..
oh my god. This is beyond perfection.
You are one of the best teacher. Your capacity of repeating one thing in each video again n again do not let us to forget anything n helps in better understanding. Thank you!
🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg
🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg
Sir ki jitni tareef ki jaye kam hai …..bahot asani se sab samjha dia…. ✌️👍 thank you so much
Most welcome dear Afzal, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
You awesome sir jii .. the way of explaining every point is marvaoulus .. you r too good .. Maine kv DBMS and OS itne asaani s nhi samjha tha jitna Aapne smjhaya ... Thanks a lot and God bless you .
I came to your channel for just one video related to OS but i'm here, watching all videos now. Kudos! Such easy and effective explanations. One of the best on youtube.
Bahot shaandar tareeke se logic clear kiya h....Jai ho sir ji ki
Eg 3 expalnation @ 14:10- proper subset of ACD will not contain B...
bilkul sir aapne vaada pura kiya h .thanks a lot
DBMS pr confidence apke waja se he sir, thank you sir, god bless you sir
sir u make every piont so clear and easy .....that anyone can easily memorise lecture ...
Sir you are the bestest!! I wish ki hm aapka video placement k time me dekhe hote.!
mai aapka sach mai fan ho gaya...
kya paraha....jabardast
I m.speechless after seeing this lesson..Just Awesome..🌸
Well defined in the easiest way and very understandable. Thank you so much, sir. Appreciated your work. Love from Nepal.
Bhai kya mast examples diye hain.....fan ho gaya!!
Aacha video hai sir.
Video Bahut helpful hai...
Thank you so much sir...
Really after watching this video i felt if u could be my engineering teacher. Excellent explanation skills.
Excellent superb explanation by Sir Sancit Jain. I salute you Sir. MAY ALLAH bless you.
Thank you so much.. Keep learning and supporting !!
I ll always comment sir.. very nyce.. i understand the normalization concept for first time .. just because of you sir.. thanks sir
Watching this again after 2 years 🤩... Remembering those college xams and ur videos
we are berozgar
I wonder if anyone could teach this concept better omg he is such a great teacher ❤️
Thank you so much for your valuable feedback ❤ Keep learning & supporting! You can also check out our course for all Computer Science subjects, sharing the link below:
www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
thank u sir ,its only now I understand the difference between super key and candidate key...
aap subject ko bahoothi asaani thareeki se samjaraahi ho...
best teacher I have ever listen .
Love from pakistan sir.
I don't have an exam neither am I a CSE student. But because of your teaching style, I am having an attraction towards DBMS. Thank You!!
Wtf
@@Paaaaaaaaaaal my reaction is also same who the hell likes this theory, coding is addictive but this theory isn't.
@@RandomGuy-hv7tb right bro🤣
Our education system needs more people like you...♥️♥️the way u give the examples is just awsm 🖤..nd one of the most important thing is that u taught us free of cost 🤙🤙🤙#Thanks a lot sir
I am glad that I found your channel. Thanks for providing free teachings.
One of the best...video... Teaching quality is best.... 👍👍👌👌💐💐💐
Primary key selection through transaction example. Shandaar sir. !
14:21 proper subset of ACD is not B it should be D. a small mistake
Thanku sir
Kisi teacher ne aise nahi samjhaya ye concept.
bht bht acha lacture h Allah pak apko khush rkhn ameen
Best teacher.....sir u r Just amazing... teaching process....just wow...🙏🏻🙏🏻🙏🏻🙏🏻
Thank you so much for existing and sharing the knowledge with us. You are a true savior. 🙏🙏🙌🙌
wah Sir ,respect form Pakistan .... kamal kar dia ... waday k pakky hain ap :-)
Your teaching is great sir. You go to the root of the concept 😇. thank you so much for making this video. It help me a lot.
You're most welcome dear @Astik😍keep learning! Do like, subscribe & share our videos, you can also visit our website www.knowledgegate.in for more amazing videos & contents👍
Mind blowing lecture
Thank you very much ...Really extraordinary ...Very Greatfull to you sir.
You are most welcome dear Vaibhav, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
Awesome video sir, unforgettable explanation, thank you so much.
excelent method to understand this concept thanks for this sir
Excellent lecture on database keys.
My concept is clear now.
Thank you sir 🙏❤️
Most welcome dear 😍keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
Your teaching skill is great sir g❤️love from Nepal.
Thanks a lot dear, Stay blessed ❤️❤️ Keep learning & supporting !!
Sir...DBMS me pass hone ka reason sirf aapki ye videos hai...Thank you sir
Sir really appreciated.. too good sir.. thanks alot
Sir u r awesome bahuton ko bolte suna h ki me wada krta hu last tk tmhe sb smg aa jaaega pr koi smga ni ska pr apne in 21 minute me hi pura concept hi clear krwa dia thanku sir❤❤
Sir Really after watching this video i felt if u could be my engineering teacher. Excellent explanation skills.
Extra ordinary Example...🔥🔥
Way of explaining is wow!!!
Aapka technique bahut behtar h
Great explaination......welll knowledgable sir
Thank u very much sir your method is so effective ..
Thank you sir ek dam sari keys ka confusion dur ho gya.
Keep it up sir
sir aajtak yeh samaj nahi aata tha .. aab aa gaya .. thanks sir
very nyc sir kabhi socha nahi tha yeah topic bhi seekh pauga but u made it possible if someone wants to learn normalization
watch knowledge gate from 3.1 to 4.12 must watch
🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥 Bahut acchese samaja aya sir
Thank you sir !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Most welcome dear.. keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing contents & courses !
Thank u for the important concept sir
what an explanation SIR , GREAT
Thanks Abhishek.. Keep learning !!
Sir please upload a videos on SQL(Structure Query Language) and thank you sir for upload videos on DBMS
best way to understand keys........
thanks sir
Most welcome dear 😍 Keep learning & supporting ! Do visit our website www.knowlegdegate.in for more amazing courses & contents 👍😊
Bhai log channel subscribe krr lo...kitna acha padhaate sir
Very good sir aap logically Bahut achchha samjhate hai
Nice Sir thanks for making videos on this topic
Thanku so much sir...You are really a great tecaher.
Amazing teaching skill...keep the gud work on nd keep uploading new contents...Thnx alot sir
Sir, your explanation skills are excellent
Thanks a lot dear Ramesh, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
Sir you have got amazing teaching skills..keep supporting us.
Beautifully Explained...............
I gotta tell you it is perfect. Everything. Down to the last, minute details
Thank you so much dear❤ Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing contents & complete courses 👍😊
Damnnnn...Sir Thanks for clearing our doubts..❤️❤️
You are welcome dear Shubham, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
You're the best sir ji! 🙌
Thank you for the kind words dear❤ Keep supporting & stay connected for more amazing contents👍😊
You can also check out our course for all Computer Science subjects, sharing the link below:
www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
Sir you explain it soo simple way. Thank you sooo much sir
Best video I have found on Keys 🔥🔥
Thank you dear 😍Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
I feel relaxed when i see my favorite teachers video on the topic I'm searching for😌😌
Thank you so much dear for your valuable feedback, stay blessed❤ keep supporting & stay connected for more amazing contents👍😊
You can also check out our course for all Computer Science subjects, sharing the link below:
www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
Awesome sir..U really make concepts easier and interesting.
Yes sir bore nai hota with ur lessons. enjoy studying best teacher
sir aap best ho :)
Amazing explanation , sir, you are clearing our concepts not just exams.
god bless you sir..may you get everything in your life, whatever you want..
You are a brilliant teacher sir
Someone said..
Legends are not born they're made.
And Sanchit sir is a proof of that.
You can use augmentation in D -> A and transform it into DB -> AB. Then transitivity can be used with AB -> C to give DB -> C which can then be unioned with DB -> ABC to give DB -> ABCD which is a super key.
Best explanation ever❤️❤️
Thank you so much❤ keep supporting & stay connected for more amazing contents👍😊
You can also check out our course for all Computer Science subjects, sharing the link below:
www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science
awesome way teaching sir
Amazing..sir..ur teaching is jst fab..thnku soo much.
Really Great Explanation. Thank You So Much Sir.
best teaching sir
Thanks a lot dear Harsh, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!
sir words are not enough to describe your excellency.
Thanks a lot dear Piyush, Keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!