3.11 Super Key, Candidate Key and Primary Key
Вставка
- Опубліковано 3 тра 2018
- 📝 Talk to Sanchit Sir: forms.gle/WCAFSzjWHsfH7nrh9
💻 KnowledgeGate Website: www.knowledgegate.in/gate
📲 KnowledgeGate Android App: tiny.cc/KG_Official_App
➡ Do not miss our Bestseller Courses:
🔴 GATE Guidance-2025: www.knowledgegate.in/learn/GA...
🟠 GATE Guidance Plus-2025: www.knowledgegate.in/learn/GA...
➡ Contact Us:
🟩 Whatsapp Chat: wa.me/918595120657
📞Call on: +91-8000121313
🟦 Telegram Updates: t.me/kg_gate
🟩 Whatsapp Updates: www.whatsapp.com/channel/0029...
📧 Email: contact@knowledgegate.in
➡ Our One Shot Semester Exam Videos: 👇
▶ Operating System: • Complete Operating Sys...
▶ DBMS: • Complete DBMS Data Bas...
▶ Computer Network: • Complete CN Computer N...
▶ Digital Electronics: • Complete DE Digital El...
▶ Computer Architecture: • Complete COA Computer ...
▶ Data Structure: • Complete DS Data Struc...
▶ Algorithm: • Complete DAA Design an...
▶ Software Engineering: • Complete Software Engi...
▶ Theory of Computation: • Complete TOC Theory of...
▶ Compiler: • Complete CD Compiler D...
▶ Discrete Maths: • Complete DM Discrete M...
➡ Free Subject-Wise Complete PlayList: 👇
▶️ DBMS: tiny.cc/kg_yt_DBMS
▶️ Operating System: tiny.cc/kg_yt_OS
▶️ TOC|Automata: tiny.cc/kg_yt_toc
▶️ Computer Networks: tiny.cc/kg_yt_CN
▶️ Digital Electronics: tiny.cc/kg_yt_Digital
▶️ Compiler Design: tiny.cc/kg_yt_Compiler
▶️ Computer Architecture: tiny.cc/kg_yt_COA
▶️ Data Structure: tiny.cc/kg_yt_DataStructures
▶️ Algorithms: tiny.cc/kg_yt_Algorithm
▶️ Set, Relation, Function: tiny.cc/kg_yt_Discrete_Relations
▶️ Graph Theory: tiny.cc/kg_yt_graphtheory
▶️ Group Theory: tiny.cc/kg_yt_grouptheory
▶️ Proposition: tiny.cc/kg_yt_prepositions
#knowledgegate #GATE #sanchitjain
*********************************************************
For complete DBMS, check out this video: ua-cam.com/video/YRnjGeQbsHQ/v-deo.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 !!
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 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!
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.
bilkul sir aapne vaada pura kiya h .thanks a lot
one of the best teacher on youtube with great teaching skills
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 :)
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 .
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
oh my god. This is beyond perfection.
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.
One of the best keys explanation in youtube.
*The* Best
@@anuragchowdhury4101 i was going to write the same😂 you wrote it 9months back
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...
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
Thank you so much for existing and sharing the knowledge with us. You are a true savior. 🙏🙏🙌🙌
Well defined in the easiest way and very understandable. Thank you so much, sir. Appreciated your work. Love from Nepal.
Really after watching this video i felt if u could be my engineering teacher. Excellent explanation skills.
@3:17 this is something which no one tells and that's why I love Knowledge Gate:):)
God spotted
DBMS pr confidence apke waja se he sir, thank you sir, god bless you sir
I ll always comment sir.. very nyce.. i understand the normalization concept for first time .. just because of you sir.. thanks sir
Way of explaining is wow!!!
sir u make every piont so clear and easy .....that anyone can easily memorise lecture ...
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🤣
Awesome video sir, unforgettable explanation, thank you so much.
Watching this again after 2 years 🤩... Remembering those college xams and ur videos
we are berozgar
mai aapka sach mai fan ho gaya...
kya paraha....jabardast
Sir 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..
Bhai kya mast examples diye hain.....fan ho gaya!!
Sir really appreciated.. too good sir.. thanks alot
Sir please upload a videos on SQL(Structure Query Language) and thank you sir for upload videos on DBMS
Bahot shaandar tareeke se logic clear kiya h....Jai ho sir ji ki
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 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 !!
Aacha video hai sir.
Video Bahut helpful hai...
Thank you so much 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
I m.speechless after seeing this lesson..Just Awesome..🌸
god bless you sir..may you get everything in your life, whatever you want..
Awesome sir..U really make concepts easier and interesting.
Amazing teaching skill...keep the gud work on nd keep uploading new contents...Thnx alot sir
Really Great Explanation. Thank You So Much Sir.
Thanks man! your teaching style is too good ! keep it up.
Amazing explanation , sir, you are clearing our concepts not just exams.
One of the best...video... Teaching quality is best.... 👍👍👌👌💐💐💐
Sir you explain it soo simple way. Thank you sooo much sir
Just awesome sir,☺️
Thank you sir,,now I completely understood ..
Thanku so much sir...You are really a great tecaher.
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 sir ek dam sari keys ka confusion dur ho gya.
Keep it up sir
excelent method to understand this concept thanks for this sir
Best teacher.....sir u r Just amazing... teaching process....just wow...🙏🏻🙏🏻🙏🏻🙏🏻
Thank you sir..you made very clear about key concept
best teacher I have ever listen .
Love from pakistan sir.
sir aajtak yeh samaj nahi aata tha .. aab aa gaya .. thanks sir
bht bht acha lacture h Allah pak apko khush rkhn ameen
Awsm sir ji... Aap great hai
Thank u very much sir your method is so effective ..
Great explaination......welll knowledgable sir
Thanku sir
Kisi teacher ne aise nahi samjhaya ye concept.
Thank you sir. . Understood it very clearly
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👍
God bless you sir
Nice Sir thanks for making videos on this topic
I really admire the way he teaches..every topic🔥👍.
The best explanations I have ever heard which gave ✨crystal clear knowledge.
Thanks sanchit sir 🙏🙏
For ur Nice and Easy way of explaination
I'm literally finding this in UA-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 !!
Awesome content must watch if u want to understand this topic ❤️
Primary key selection through transaction example. Shandaar sir. !
Very good sir aap logically Bahut achchha samjhate hai
thank to give knowledge guru ji
may God bless you for all the good work you are doing
Excellent superb explanation by Sir Sancit Jain. I salute you Sir. MAY ALLAH bless you.
Thank you so much.. Keep learning and supporting !!
Thank u for the important concept 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 !!
Thanku sir your videos help me a lot..plz make video on SQL and data manipulation and control
Mind blowing lecture
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 you have got amazing teaching skills..keep supporting us.
Once again... Thank you so much sir👍🙏
Best explanation on this topic!🙌🙏
amazing....thank u so much sir
Very well explained.... thank you sir
thank you so much sir... its really nice
sir aap best ho :)
Sir,
Please make video on topic "Generation of permutations and combination ".
brilliant explains sir I will understand easily
Extra ordinary Example...🔥🔥
Amazing..sir..ur teaching is jst fab..thnku soo much.
Beautifully Explained...............
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.
Someone said..
Legends are not born they're made.
And Sanchit sir is a proof of that.
Kya sahi me itna easy tha
Thank you sir and love you sir
Thanks man Thank you soo much ...:)
Aapka technique bahut behtar h