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
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. ❤❤❤❤
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.
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.
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
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
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❤❤
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👍
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...
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.
One person can have many human friends (many to many) - Shoaib has three friends (ydk,nabeel, adnan) - Adnan has four friends ( ydk,shoaib, shahbaz,Imran) - Shahbaz has three friends (adnan, qaisar, Imran) Possible Queries: 1- Display friends of shoaib 2- Display name of person who have not friendship with shoaib 3- Display frinds of adnan who are not friends of shoaib 4- Display person name with their friend name
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
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
Thanku sir...aapki video dekh ke lg rha b.tech time me kyu nhi dekhi us time to sb upar se jata tha etne achhe teacher nhi the humare pass warna aaj gate ke kisi psu me Hoti😭
For complete DBMS, check out this video: th-cam.com/video/YRnjGeQbsHQ/w-d-xo.html
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 !!
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
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
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. ❤❤❤❤
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.
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 :)
oh my god. This is beyond perfection.
One of the best keys explanation in youtube.
*The* Best
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
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!
@3:17 this is something which no one tells and that's why I love Knowledge Gate:):)
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 !!
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
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 m.speechless after seeing this lesson..Just Awesome..🌸
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.
Sir you are the bestest!! I wish ki hm aapka video placement k time me dekhe hote.!
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
Watching this again after 2 years 🤩... Remembering those college xams and ur videos
we are berozgar
sir u make every piont so clear and easy .....that anyone can easily memorise lecture ...
I ll always comment sir.. very nyce.. i understand the normalization concept for first time .. just because of you sir.. thanks sir
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 you so much for existing and sharing the knowledge with us. You are a true savior. 🙏🙏🙌🙌
mai aapka sach mai fan ho gaya...
kya paraha....jabardast
Thanks sanchit sir 🙏🙏
For ur Nice and Easy way of explaination
I'm literally finding this in TH-cam and finally get it ur best playlist of dbms 🙏🙏
You're most welcome dear.. Stay tuned !! Do visit our website www.knowledgegate.in for more courses and contents. Keep learning !!
Bahot shaandar tareeke se logic clear kiya h....Jai ho sir ji ki
One of the best...video... Teaching quality is best.... 👍👍👌👌💐💐💐
Best teacher.....sir u r Just amazing... teaching process....just wow...🙏🏻🙏🏻🙏🏻🙏🏻
Excellent superb explanation by Sir Sancit Jain. I salute you Sir. MAY ALLAH bless you.
Thank you so much.. Keep learning and supporting !!
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🤣
Sir please upload a videos on SQL(Structure Query Language) and thank you sir for upload videos on DBMS
God spotted
Really after watching this video i felt if u could be my engineering teacher. Excellent explanation skills.
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..
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 appreciated.. too good sir.. thanks alot
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👍
Well defined in the easiest way and very understandable. Thank you so much, sir. Appreciated your work. Love from Nepal.
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...
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 👍😊
Sir...DBMS me pass hone ka reason sirf aapki ye videos hai...Thank you sir
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 !!
Someone said..
Legends are not born they're made.
And Sanchit sir is a proof of that.
bht bht acha lacture h Allah pak apko khush rkhn ameen
Bhai kya mast examples diye hain.....fan ho gaya!!
best teacher I have ever listen .
Love from pakistan sir.
Primary key selection through transaction example. Shandaar sir. !
Aacha video hai sir.
Video Bahut helpful hai...
Thank you so much sir...
excelent method to understand this concept thanks for this sir
Mind blowing lecture
Thank u very much sir your method is so effective ..
Way of explaining is wow!!!
Extra ordinary Example...🔥🔥
Awesome video sir, unforgettable explanation, thank you so much.
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 u for the important concept sir
Nice Sir thanks for making videos on this topic
Eg 3 expalnation @ 14:10- proper subset of ACD will not contain B...
Your teaching skill is great sir g❤️love from Nepal.
Thanks a lot dear, Stay blessed ❤️❤️ Keep learning & supporting !!
Thanku sir
Kisi teacher ne aise nahi samjhaya ye concept.
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 !!
Great explaination......welll knowledgable sir
Thanku so much sir...You are really a great tecaher.
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 !!
One person can have many human friends
(many to many)
- Shoaib has three friends (ydk,nabeel, adnan)
- Adnan has four friends ( ydk,shoaib, shahbaz,Imran)
- Shahbaz has three friends (adnan, qaisar, Imran)
Possible Queries:
1- Display friends of shoaib
2- Display name of person who have not friendship with shoaib
3- Display frinds of adnan who are not friends of shoaib
4- Display person name with their friend name
please help me to do this query using a single table
what an explanation SIR , GREAT
Thanks Abhishek.. Keep learning !!
🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥 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 !
14:21 proper subset of ACD is not B it should be D. a small mistake
sir aap best ho :)
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 👍😊
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
Awesome content must watch if u want to understand this topic ❤️
Bhai log channel subscribe krr lo...kitna acha padhaate sir
Thank you sir ek dam sari keys ka confusion dur ho gya.
Keep it up sir
Sir,
Please make video on topic "Generation of permutations and combination ".
Very good sir aap logically Bahut achchha samjhate hai
Sir Really after watching this video i felt if u could be my engineering teacher. Excellent explanation skills.
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 👍😊
Amazing teaching skill...keep the gud work on nd keep uploading new contents...Thnx alot sir
Amazing..sir..ur teaching is jst fab..thnku soo much.
Awesome sir..U really make concepts easier and interesting.
Thank you so much sir for the best explanation of Keys
You're most welcome dear❤ Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊
@@KNOWLEDGEGATE_kg Yes sure sir👍
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 👍😊
Beautifully Explained...............
Sir you have got amazing teaching skills..keep supporting us.
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
god bless you sir..may you get everything in your life, whatever you want..
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
sir aajtak yeh samaj nahi aata tha .. aab aa gaya .. thanks sir
You are the teacher of the teachers.
Love you sir. ❤❤
God bless you sir
Thanku sir...aapki video dekh ke lg rha b.tech time me kyu nhi dekhi us time to sb upar se jata tha etne achhe teacher nhi the humare pass warna aaj gate ke kisi psu me Hoti😭
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 !!
Sir you explain it soo simple way. Thank you sooo much sir
wah Sir ,respect form Pakistan .... kamal kar dia ... waday k pakky hain ap :-)
this topic is difficult to explain but you explained very well
thank you sir ❤️
Most welcome dear Tushar, keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents !