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

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

[@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🙏

[@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

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

[@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

[@jackfrost8969]

oh my god. This is beyond perfection.

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

[@zarifali3255]

One of the best keys explanation in youtube.

[@anuragchowdhury4101]

*The* Best

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

[@aryanrathore1790]

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

[@aviksarkar8997]

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

[@ahadkhan6630]

one of the best teacher on youtube with great teaching skills

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

[@akshatjain9762]

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

[@thegopalsharma2389]

we are berozgar

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

[@Ankit-we8ym]

bilkul sir aapne vaada pura kiya h .thanks a lot

[@KNOWLEDGEGATE_kg]

🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg 🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg

[@harpreetv761]

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

[@narendrachoudhary6808]

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

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

[@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

[@pranjalvyas6723]

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

[@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

[@pranavtiwari1883]

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

[@bhupendrasolanki6572]

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

[@aqsamumtaz462]

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

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

[@sadiq4933]

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

[@brilliantboy8147]

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

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

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

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

[@arafat6578]

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

[@sunilkumargouda6353]

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

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

[@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...🙏🏻🙏🏻🙏🏻🙏🏻

[@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 👍😊

[@sunandagaikwad2121]

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

[@Pankajkumar-dy9ef]

God spotted

[@anilpariyar19]

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

[@uvinodh90]

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

[@memonakarim6687]

bht bht acha lacture h Allah pak apko khush rkhn ameen

[@AnubhavMadhav]

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

[@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🤣

[@yawarahmad9899]

Primary key selection through transaction example. Shandaar sir. !

[@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

[@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

[@khwaishbatish5355]

Thanku sir Kisi teacher ne aise nahi samjhaya ye concept.

[@monikasharma1184]

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

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

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

[@chitrasingh8724]

Mind blowing lecture

[@nihalsingh5558]

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

[@NIKHIL-nv8wu]

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

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

[@DeepakMauryaLucknow]

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

[@parasmehta7793]

Extra ordinary Example...🔥🔥

[@sanchitjainfanclub3620]

Way of explaining is wow!!!

[@keshavshinde8886]

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

[@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 👍😊

[@muhammadkhurram4221]

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

[@animeshkumar1641]

Thank u for the important concept sir

[@abhishekaggarwal3831]

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

[@PushpendraSingh-qv8ew]

Aapka technique bahut behtar h

[@gokarnabhatt7377]

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

[@KNOWLEDGEGATE_kg]

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

[@wakeelahmad7747]

excelent method to understand this concept thanks for this sir

[@tahirmehmood8837]

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

[@sadiaafrin7143]

God bless you sir

[@aditikumari3358]

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😭

[@abhishekjain1438]

what an explanation SIR , GREAT

[@KNOWLEDGEGATE_kg]

Thanks Abhishek.. Keep learning !!

[@PankajKumarShweta]

Very good sir aap logically Bahut achchha samjhate hai

[@ShoaibKhan0701]

Nice Sir thanks for making videos on this topic

[@furqanhaider1154]

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

[@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

[@_Pearl-vy7qn]

Great explaination......welll knowledgable sir

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

[@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

[@yashsonwane4218]

Sir, Please make video on topic "Generation of permutations and combination ".

[@chetanraj1950]

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

[@KDTechverse]

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

[@adityahirwani1672]

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

[@SameerKumar-rm3by]

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

[@sauravkashyap7734]

sir aap best ho :)

[@koustavdas6585]

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

[@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 👍😊

[@jiveshshrivastav9722]

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

[@soniasmelodiousland]

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

[@jyotiruhela9877]

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

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

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

[@-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 👍😊

[@rocktrekker3810]

Awsm sir ji... Aap great hai

[@infinitebeauties7253]

aapne apna wada pura kia hai video ke end tak.....:)

[@KNOWLEDGEGATE_kg]

Thanks dear 😍 Keep supporting & stay connected 👍😊

[@tusharsinghnegi1291]

this topic is difficult to explain but you explained very well thank you sir ❤️

[@KNOWLEDGEGATE_kg]

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

[@ananyabhatt2715]

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