Lec-13: Super key in DBMS in HINDI | ये Question Competition Exams में अक्सर पूछा गया है

[@rajeshkundu9421]

your lectures are even better than NPTEL lectures

[@buddheshwarnathkeshari4363]

Kisse compare kr diya bhai.. 🤣Gate smasher ki beizzati mt kro

[@SahilKumar-rz3th]

@@buddheshwarnathkeshari4363 lol

[@salmanbehen4384]

Bhai NPTEL se achcha to geeks for geeks hai. NPTEL bilkul kachra hai.. Aur gate smashers to legendary channel hai.

[@Draxper]

Kya faltu cheez se compare kar diya😂😂

[@ahmedbrentley1092]

you probably dont give a shit but if you're bored like me atm you can watch pretty much all the new series on instaflixxer. I've been watching with my girlfriend during the lockdown :)

[@AI-zw1rz]

brother you are like god of DBMS and believe me i have seen no negative comments so far and literally there are many stories in comment section which inspired me i am student but if i will become teacher i want to be like you have a great future and please earn some money by uploading ur lectures on udemy atleast people who have money can contribute to you i dont even skip ads on your channel ur channel and neso academy are best channel on youtube

[@GateSmashers]

Thank You so much for your love and support. Thank you for your suggestion. I will try.Keep learning and sharing. Bless you

[@ramneet5733]

@@GateSmashers sir candidate key only can be super key ....e.g only roll no considered to be super key??

[@unknowinglygibberish1913]

@@ramneet5733 Yes

[@bhuppidhamii]

​@@ramneet5733no

[@itspace4741]

​@@GateSmashers sir notes bhi provide kijiye❤❤❤❤😢😢😢❤❤❤❤

[@tanusv8363]

I don't feel like I am listening to DBMS ,it feels like I am hearing a story 😀. You explain everything very simply story teller

[@kanchanjadhav8055]

"Better than a thousand days of diligent study is one day with a great teacher."

[@ADITYASHARMA-dn1si]

I lost my pace in dbms in starting of this sem and had lost all my hopes but after watching your videos I am starting to restore my confidence that I can complete it, your teaching makes this subject look like a piece of cake. Thank you sir

[@chiragshilwant886]

Sir, You are genius in dbms💯

[@shivyogi806]

Bro, WHY I didn't find your videos 10 years back. Super Duper Way of teaching. Bless you and keep helping people with your unique style of teaching. Not everyone has courage and patience to teach, like you do. God Bless you. -deepam patel

[@kartiksharma2037]

Legends are still alive Hats Off to you SIR Huge Respect to your work :)

[@amangaud3207]

Sir, you are amazing. You are shaping the future of our country. Thank you very much for your lectures.

[@watchandgainknowledge]

sir you are so Cool with knowledge and personality. Now I can bet that, your little bit favourite subject also *Permutation and Combination* superb sir superb

[@kunalkumar6783]

Bahoot bahoot dhanyawad sir Aisa quality educational content Dene ke liye 👍🌻🙏

[@nasu3991]

Thank you very much sir. Spent an hour finding this topic here and there and finally got it here.

[@vishwabhatt20]

your lectures are very easy to understand. And even my friends of the group love to watch your videos and learn from it. thank you so much

[@ParulBedi]

Concept of super key was very well explained in first 2:30 minutes and I will remember it for lifetime now , but he really explained the mathematical approach of it so well that I cant skip that and watch till end. This series is helping me to learn SQL part for my data analytics, Kudos to you and your hard work !!!

[@hemensanmahilange4127]

Super key with super lecturer ... Thank you so much sir for wonderful collection of DBMS concepts.

[@SarthakDeshmukh07]

Very Thanks Sir 🙏🏻❤

[@wtfmangal7920]

I watched full dbms playlist it's very helpful and very best explaination.।।।।। Thank you so much sir 💕💕💕💕💕💕💕💕💕😍😍😍😍

[@afrinsultanajui3972]

Your lectures are very helpful..Respect from Bangladesh ❤

[@Zeeshankhan-zy3tp]

One of the best tuitor.....Nice explanation........Your are the best teacher. for me....May Allah gave you more success....Ameen sum ameen...

[@MBfan1975]

better then unacademy

[@btsarmyforever7695]

Thanks sir i wasted my time searching dbms videos but when i see your videos it explains very simply and a short videos thank sir😊

[@adeshhazra1758]

carry on brother huge respect for you many who cant afford teachers and less interest in reading books they can learn easily any topics from your videos ......

[@hallohamsa8854]

Really u r lecture was straight forward, which can give clear picture. I listen soo many DBMS, but they was soo lengthy like jilebi.... No direct defination with example..... I really thankful to u r lecture......

[@SCENRIOLIMITED]

Appreciation from #Pakistan.... a lot of respect for you Sir, Not only DB, But in my Advance Operating System subject of M.Phil. Your videos helped me greatly and enabled me to get a 4 GPA ALHAMDULILLAH. May ALLAH SWT bless you.

[@thisisaniketup]

Here I am 2 days before my exam knowing nothing about dbms and now I'm totally confident to score in the subject just because of you sir😇

[@GateSmashers]

All the best

[@itworldnote]

Very good sir. You always teach every concept very easily. Thank you so much.

[@soumi6720]

You are a great teacher Sir.

[@yehumang8361]

Ab concept achi trah samaj ayea. Kabhi nhi bhulega. Thnku soo much sir

[@sajansekhu8785]

Thnkk u so much sir..Aap itna achaa explain krke bahut se students ki hlp krr rhe ho..God bless u.🙏

[@time1702]

a person in village can study with the help of this thankful for such great content

[@sohammehta8815]

100% crystal clear teaching SIR!!🤩🤩

[@mehekalinaik3854]

Sir aapke operating systems aur computer networks ke lecture videos se my Mera sem ache marks se clear krgayi..hope this will make me to prepare for my placements 😊..thank you sir😊

[@GateSmashers]

Good.. Thank you

[@tamannasharma3524]

Literally you are such a great teacher. I am from LPU as well and wish to get you as my faculty next semester. I missed this subject in uni because of my exchange in Canada and I was worried about how will I cover the whole syllabus but now I feel I can score good marks just because of this series of lectures.. Thankyou so much ... Wish you success in your life.

[@GateSmashers]

thank you Tamanna..bless you..refer the videos to others also in Canada..

[@PratyushSahoo-fo7pu]

Considering (a1a2), (a3a4) as the composite keys in the last example... shouldn't the answer be 2^(n-2) - 2^(n-4) ?? Like if we take a1a2 -> x and a3a4 -> y, then we are left with only n-2 elements; now the question is similar to the first one with n-2 keys only... Correct me if I am wrong.

[@backupsqure]

i was thinking the same u are right

[@shashanksharma7747]

very good and simple explanation very good to watch gate smasher all playlists

[@anantgosai8884]

Simply amazing..so easy to learn from your video! Thank you!

[@bhupinderkaur8426]

Thanks sir, this is the first time that I understand super key concept...

[@artitech6668]

This is true GOLD....good wishes for u sir🌟

[@eshaangupta4101]

The entire concept was clear in the first minute. Great content!

[@targetupscias5206]

Sir aap ki video se padh kr maine gr pr hi dbms padh liya hai aap bahut axa padhate hai

[@VivekKumar-ei9ez]

Sir aap best padate

[@sarikagautam2259]

Awesome explanation 👌 sir it's very helpful....

[@debarshidhar7866]

Considering a relation R(A,B,C,D,E) with functional dependencies ABC->DE and D-> AB , what is the number of superkeys of R? Please solve this problem.

[@beautyshadesofhimachal....4341]

Best teacher in CSE.........

[@samirajput70985]

Hello sir I am fan's off ours way of teaching

[@KanchanSingh-ge6ez]

Plz aap C++ pe video banaye apka lecture se mughe acche se samjh aata h isliye aap programming languages pe bhi banye video

[@hiteshdangi5077]

You have good explanation skill

[@ShilpikiRemedies]

Sir u are genius in all subject... I watch ur all videos no one skip....Thanku Thanku so much sir for ur guidence..... One word to say u sir....in Black T-shirt u look so smart not be a wrong purpose.... Respected sir thanku so much😊

[@GateSmashers]

Thank you for your good wishes, appreciation and your compliment.. Lots of blessings...

[@salilshukla2686]

Your way of teaching is very good sir.

[@sumitshokeen8774]

Sir plzzz upload remaining videos As soon as possible and Numerical questions 🙏🙏🙏 Your way of explanation is awesome 👏✊👍

[@shahvezkhan9098]

Sir ek topic pr video Banao k ap simple man hi h , ap itan achha parate h that is very helpfull to us , sir please never stop your lecture thank u sir

[@animationcrust1993]

You made the concepts easy sir 🙏☺️

[@deveshsrivastava9121]

Thank you sir. Your teaching technique is awesome. Keep up the good work. You are helping a lot of students, and making a big change among the youth. Salute to you and your skills.

[@prashanttiwari5237]

Sir your leactures are helping us alot for our UT exams. Thank you so much sir🙏

[@kapildhanwani1219]

brilliant way to study sir thankyou

[@epicboss786]

00:00 Super keys are combinations of attributes that can uniquely identify two tuples in a table. 01:20 Roll number is a candidate key. 02:32 Super keys are a superset of candidate keys. 03:45 A1 is a compulsory element in every subset of the given table. 04:59 Number of super keys possible for given candidate keys. 06:17 Identifying common sets with A1 and A2. 07:27 Understanding candidate keys and super keys in database management. 08:36 Understanding the concept of super keys.

[@ZohaibRajpootFromSheikhupura]

Love from Pakistan 🇵🇰❤️ Great work sir😊

[@ritu9919]

Thankyou Sir. Your lectures are helpful.

[@ashmitasharma9681]

Sir u make is understannd every concept ❤️❤️

[@rabindra66]

00:02 Super key is a combination of all possible attributes that can uniquely identify tuples 01:20 Super key is a combination of candidate key and additional attributes. 02:32 Super key is a super set of any candidate key 03:45 A1 is a candidate key 04:58 Super keys in DBMS can have 2^n - 1 possibilities 06:15 Commutative property in candidate keys 07:27 Super key concept and calculations explained 08:36 Super keys in DBMS

[@ayushraj-zb6sv]

mere professors bhi aap ka video dekh ke parate hai..online lectures me..since wo bhi same apka hi diya hua example se explain karte hai concepts..

[@allgoodcontents]

Thankyou sir

[@alifrazkhan124]

beautifully precise ....great work

[@VibeFreshSongs]

You are great sir i love u and your lecture

[@nileshmare9662]

if A1 is candidate key then no. of super keys will be 2^(n-1) + 1, because A1 is also a superkey

[@ClarkKent-kw8pl]

yes

[@keshavagrawal3396]

Sir in last example if a1a2,a3a4 are working as as a composite then there will be n/2 element na. So i think there should be pow(2,n/2-2)+pow(2,n/2-2)-pow(2,n/2-4) Am in right?

[@keertichib4987]

sir you are amazinggggggggggggggggggg !!!!!!!!! thankyou so much for teaching us :)

[@justgetit5931]

Thank You so Much Sir for your great work fir us. God bless You

[@rs-no1ju]

Thanks a lot sir...sir i request you to please upload discrete maths videos for gate..🙏🙏🙏🙏🙏🙏🙏

[@golammuktadir4355]

Excellent Sir, Thanks for your lecture

[@bajrangverma]

beautiful explanation sir

[@AK-us1by]

Thanks a lot for such informative tutorial.

[@coderahul]

Your way of teaching is really very good...It would be great if you can cover as many as subjects you can...after that no student will need to pay for any couching.

[@JyotiDhiman__]

your way of teaching is just amazing , my all concepts are clear now after watching your videos even though i hadn't learned or read anything about the same from anywhere except my college lectures that are just formality and wastage of time, thanks for being such a nice teacher.

[@skdanishali7585]

I randomly saw your comment but want to know more about you... Can we be friends?... Waiting for reply

[@shashankgali1816]

thanks u sir your videos helped a lot for my interviews❤❤❤

[@rajpanwar11]

अद्भुत विश्लेषण

[@priyankachatterjee5042]

you are the Super teacher in the world. thank you ^infinity

[@heyMonikaa]

Cannot thank him enough! 🏋🏻‍♀️✨

[@Shreya-ff9dx6fv1s]

Thank you so much very clear explanation

[@zohaibhassan9622]

You teach better than my lecturer. Seriously bro

[@bspandey7501]

Really sir u r the god of DBMS🙏🙏

[@gunjanarya2915]

Sir please make more vedios for dssb tgt and provide more questions.

[@LovepreetSingh-xu7jr]

Thank you sir ❤️

[@anjududdy9949]

Very well explained..thanku sir g

[@aniketnikam8925]

Great sir

[@K-bhdz]

Bhaiya aap rest of topic bhi before june complt kar dejiye jo aapne DEC. N JULY2018 ke CS ka NET ka syllabus discuss apne vedio mei recently kiya h ... M NET QUALIFIED WITH 58% BUT MISSED JRF .SO PLZ......PLZ...🙏

[@namrataupadhyay5560]

Best...thank you so much!!💞🤗

[@nikitajaiswal9112]

Thank you so much sir very great 👏explanation

[@eshumir1902]

Thanks a lot sir ......u saved me .......thanking uhh vd core of my heart sir .....Really u r amazing .....u r really technically sound....

[@continnum_radhe-radhe]

❤❤❤

[@zubairalee6092]

Great teacher Love you bro One of the best teacher

[@tanayasingh9987]

Sir sabkuch samajh agaya😊☺😁😉. Really confusion ka saval hi ni ab.

[@talhamian6465]

Only one word "laa javaab"

[@AnkitaGupta-ph6xy]

So helpful lecture ...thanku sir

[@vaishnavinain7795]

Thnks a lot sir❤you are amazing 👏

[@aishwarya1895]

Best explanation ✌️

[@nandanaggarwal7444]

Amazing sir 👏

[@nehavig7584]

Sir you have Explained so well🙂 thank you so much 🙏

[@shubhamrajput9363]

धन्यवाद सर जी

[@jyotibajaj5748]

Not a person who comment on any you tube video But this is really appreciable... Just let you know you are doing great job🤟keep it up

[@megavathpremkumar7456]

Sir u r simply genius ❤️❤️