3.11 Super Key, Candidate Key and Primary Key

[@KNOWLEDGEGATE_kg]

For complete DBMS, check out this video: kzbin.info/www/bejne/j4PRm3qbhsemfrM

[@vijone111]

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....

[@milanjain.2564]

Right

[@pinkipatel7000]

Sir plzz upload a video series of how to convert ER diagram in to a relational model... As soon as possible

[@pritiverma845]

Yes u r right not only DBMS operating system ... Also

[@mohitsaran9193]

Sir I must say that there's no better explaination and simplification in the world than this lecture. Wish you alot of blessings sir

[@KNOWLEDGEGATE_kg]

Thank you Mohit for your valuable feedback.. Stay blessed !! Keep learning and supporting !!

[@sandeepsahu8743]

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🙏

[@najmuzzamakhan835]

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. ❤❤❤❤

[@zarifali3255]

One of the best keys explanation in youtube.

[@anuragchowdhury4101]

*The* Best

[@suryaajha5953]

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

[@ahadkhan6630]

one of the best teacher on youtube with great teaching skills

[@AmitKumar-hv6hs]

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

[@shwetamehrolia2848]

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 :)

[@jackfrost8969]

oh my god. This is beyond perfection.

[@ashwanipanchal7467]

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.

[@afzalmehndi9911]

Sir ki jitni tareef ki jaye kam hai …..bahot asani se sab samjha dia…. ✌️👍 thank you so much

[@KNOWLEDGEGATE_kg]

Most welcome dear Afzal, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@devinderkaur9811]

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!

[@aryanrathore1790]

@3:17 this is something which no one tells and that's why I love Knowledge Gate:):)

[@akankshachuchra]

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.

[@ADARSHKUMAR-bo1rj]

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 .

[@aviksarkar8997]

DBMS pr confidence apke waja se he sir, thank you sir, god bless you sir

[@Ankit-we8ym]

bilkul sir aapne vaada pura kiya h .thanks a lot

[@bhardwajsourabh4]

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!!

[@Paaaaaaaaaaal]

Wtf

[@RandomGuy-hv7tb]

@@Paaaaaaaaaaal my reaction is also same who the hell likes this theory, coding is addictive but this theory isn't.

[@Jonathan-ng4vw]

@@RandomGuy-hv7tb right bro🤣

[@sangamumbarkar9544]

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

[@aqsamumtaz462]

sir u make every piont so clear and easy .....that anyone can easily memorise lecture ...

[@akshatjain9762]

Watching this again after 2 years 🤩... Remembering those college xams and ur videos

[@thegopalsharma2389]

we are berozgar

[@kanak1448]

I wonder if anyone could teach this concept better omg he is such a great teacher ❤️

[@KNOWLEDGEGATE_kg]

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

[@narendrachoudhary6808]

Sir you are the bestest!! I wish ki hm aapka video placement k time me dekhe hote.!

[@pranavtiwari1883]

Bahot shaandar tareeke se logic clear kiya h....Jai ho sir ji ki

[@furqanhaider1154]

wah Sir ,respect form Pakistan .... kamal kar dia ... waday k pakky hain ap :-)

[@sadiq4933]

I m.speechless after seeing this lesson..Just Awesome..🌸

[@brilliantboy8147]

mai aapka sach mai fan ho gaya... kya paraha....jabardast

[@pranjalvyas6723]

Thank you so much for existing and sharing the knowledge with us. You are a true savior. 🙏🙏🙌🙌

[@sunilkumargouda6353]

Really after watching this video i felt if u could be my engineering teacher. Excellent explanation skills.

[@redrose5950]

Excellent superb explanation by Sir Sancit Jain. I salute you Sir. MAY ALLAH bless you.

[@KNOWLEDGEGATE_kg]

Thank you so much.. Keep learning and supporting !!

[@anilpariyar19]

Well defined in the easiest way and very understandable. Thank you so much, sir. Appreciated your work. Love from Nepal.

[@arafat6578]

Aacha video hai sir. Video Bahut helpful hai... Thank you so much sir...

[@doonboy1100]

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❤❤

[@sunandagaikwad2121]

One of the best...video... Teaching quality is best.... 👍👍👌👌💐💐💐

[@harpreetv761]

I ll always comment sir.. very nyce.. i understand the normalization concept for first time .. just because of you sir.. thanks sir

[@nandini-ec5xl]

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...

[@astikpatil5773]

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.

[@KNOWLEDGEGATE_kg]

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👍

[@asitkumarojha1305]

Best teacher.....sir u r Just amazing... teaching process....just wow...🙏🏻🙏🏻🙏🏻🙏🏻

[@sanchitjainfanclub3620]

Way of explaining is wow!!!

[@uvinodh90]

I am glad that I found your channel. Thanks for providing free teachings.

[@subhankardutta6054]

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..

[@AnubhavMadhav]

Bhai kya mast examples diye hain.....fan ho gaya!!

[@memonakarim6687]

bht bht acha lacture h Allah pak apko khush rkhn ameen

[@muhammadkhurram4221]

best teacher I have ever listen . Love from pakistan sir.

[@yawarahmad9899]

Primary key selection through transaction example. Shandaar sir. !

[@kartickchandramanna267]

Excellent lecture on database keys. My concept is clear now. Thank you sir 🙏❤️

[@KNOWLEDGEGATE_kg]

Most welcome dear 😍keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@nihalsingh5558]

Awesome video sir, unforgettable explanation, thank you so much.

[@bhupendrasolanki6572]

Sir please upload a videos on SQL(Structure Query Language) and thank you sir for upload videos on DBMS

[@user-df9gv4ox8k]

Sir...DBMS me pass hone ka reason sirf aapki ye videos hai...Thank you sir

[@khwahish4483]

Sir really appreciated.. too good sir.. thanks alot

[@wakeelahmad7747]

excelent method to understand this concept thanks for this sir

[@khwaishbatish5355]

Thanku sir Kisi teacher ne aise nahi samjhaya ye concept.

[@abhishekaggarwal3831]

sir aajtak yeh samaj nahi aata tha .. aab aa gaya .. thanks sir

[@vaibhav9727]

Thank you very much ...Really extraordinary ...Very Greatfull to you sir.

[@KNOWLEDGEGATE_kg]

You are most welcome dear Vaibhav, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@chitrasingh8724]

Mind blowing lecture

[@KDTechverse]

Someone said.. Legends are not born they're made. And Sanchit sir is a proof of that.

[@missmentor1662]

Eg 3 expalnation @ 14:10- proper subset of ACD will not contain B...

[@keshavshinde8886]

Sir Really after watching this video i felt if u could be my engineering teacher. Excellent explanation skills.

[@gokarnabhatt7377]

Your teaching skill is great sir g❤️love from Nepal.

[@KNOWLEDGEGATE_kg]

Thanks a lot dear, Stay blessed ❤️❤️ Keep learning & supporting !!

[@animeshkumar1641]

Thank u for the important concept sir

[@Pankajkumar-dy9ef]

God spotted

[@tahirmehmood8837]

Thank u very much sir your method is so effective ..

[@shashankbhosagi]

🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥 Bahut acchese samaja aya sir Thank you sir !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@KNOWLEDGEGATE_kg]

Most welcome dear.. keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing contents & courses !

[@parasmehta7793]

Extra ordinary Example...🔥🔥

[@ShoaibKhan0701]

Nice Sir thanks for making videos on this topic

[@gordxrohit]

Thanks sanchit sir 🙏🙏 For ur Nice and Easy way of explaination I'm literally finding this in KZbin and finally get it ur best playlist of dbms 🙏🙏

[@KNOWLEDGEGATE_kg]

You're most welcome dear.. Stay tuned !! Do visit our website www.knowledgegate.in for more courses and contents. Keep learning !!

[@PushpendraSingh-qv8ew]

Aapka technique bahut behtar h

[@shubhammehra1512]

Damnnnn...Sir Thanks for clearing our doubts..❤️❤️

[@KNOWLEDGEGATE_kg]

You are welcome dear Shubham, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@sauravkashyap7734]

sir aap best ho :)

[@NIKHIL-nv8wu]

Thank you sir ek dam sari keys ka confusion dur ho gya. Keep it up sir

[@SameerKumar-rm3by]

Sir you have got amazing teaching skills..keep supporting us.

[@allwell8570]

Sir, your explanation skills are excellent

[@KNOWLEDGEGATE_kg]

Thanks a lot dear Ramesh, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@chetanraj1950]

Thanku so much sir...You are really a great tecaher.

[@adityabaroliya8378]

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

[@_Pearl-vy7qn]

Great explaination......welll knowledgable sir

[@ananyabhatt2715]

Awesome sir..U really make concepts easier and interesting.

[@mohsin7343]

I feel relaxed when i see my favorite teachers video on the topic I'm searching for😌😌

[@KNOWLEDGEGATE_kg]

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

[@souravroy909]

14:21 proper subset of ACD is not B it should be D. a small mistake

[@PankajKumarShweta]

Very good sir aap logically Bahut achchha samjhate hai

[@DeepakMauryaLucknow]

Bhai log channel subscribe krr lo...kitna acha padhaate sir

[@abhishekjain1438]

what an explanation SIR , GREAT

[@KNOWLEDGEGATE_kg]

Thanks Abhishek.. Keep learning !!

[@ocean_eyes]

You're the best sir ji! 🙌

[@KNOWLEDGEGATE_kg]

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

[@adityahirwani1672]

Amazing explanation , sir, you are clearing our concepts not just exams.

[@PiyushKumar-bd7uc]

sir words are not enough to describe your excellency.

[@KNOWLEDGEGATE_kg]

Thanks a lot dear Piyush, Keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@jyotiruhela9877]

Amazing teaching skill...keep the gud work on nd keep uploading new contents...Thnx alot sir

[@amey1125]

I gotta tell you it is perfect. Everything. Down to the last, minute details

[@KNOWLEDGEGATE_kg]

Thank you so much dear❤ Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing contents & complete courses 👍😊

[@jiveshshrivastav9722]

Beautifully Explained...............

[@rajatkapoor7087]

Best video I have found on Keys 🔥🔥

[@KNOWLEDGEGATE_kg]

Thank you dear 😍Keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@rimpisarma7430]

Sir you explain it soo simple way. Thank you sooo much sir

[@soniasmelodiousland]

Yes sir bore nai hota with ur lessons. enjoy studying best teacher

[@monikasharma1184]

god bless you sir..may you get everything in your life, whatever you want..

[@-AnkitBsccomputerapplication]

best way to understand keys........ thanks sir

[@KNOWLEDGEGATE_kg]

Most welcome dear 😍 Keep learning & supporting ! Do visit our website www.knowlegdegate.in for more amazing courses & contents 👍😊

[@siddharths067]

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.

[@RahulTiwari-oe1ww]

Awesome content must watch if u want to understand this topic ❤️

[@koustavdas6585]

You are the teacher of the teachers. Love you sir. ❤❤

[@sadiaafrin7143]

God bless you sir

[@mubinladhani8467]

Thank you so much sir for the best explanation of Keys

[@KNOWLEDGEGATE_kg]

You're most welcome dear❤ Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@mubinladhani8467]

@@KNOWLEDGEGATE_kg Yes sure sir👍

[@arunimakarmakar1037]

Best explanation ever❤️❤️

[@KNOWLEDGEGATE_kg]

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