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

  Рет қаралды 883,822

Gate Smashers

Gate Smashers

Күн бұрын

Пікірлер: 353
@rajeshkundu9421
@rajeshkundu9421 5 жыл бұрын
your lectures are even better than NPTEL lectures
@buddheshwarnathkeshari4363
@buddheshwarnathkeshari4363 4 жыл бұрын
Kisse compare kr diya bhai.. 🤣Gate smasher ki beizzati mt kro
@SahilKumar-rz3th
@SahilKumar-rz3th 4 жыл бұрын
@@buddheshwarnathkeshari4363 lol
@salmanbehen4384
@salmanbehen4384 4 жыл бұрын
Bhai NPTEL se achcha to geeks for geeks hai. NPTEL bilkul kachra hai.. Aur gate smashers to legendary channel hai.
@Draxper
@Draxper 3 жыл бұрын
Kya faltu cheez se compare kar diya😂😂
@ahmedbrentley1092
@ahmedbrentley1092 3 жыл бұрын
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
@AI-zw1rz 5 жыл бұрын
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
@GateSmashers 5 жыл бұрын
Thank You so much for your love and support. Thank you for your suggestion. I will try.Keep learning and sharing. Bless you
@ramneet5733
@ramneet5733 2 жыл бұрын
@@GateSmashers sir candidate key only can be super key ....e.g only roll no considered to be super key??
@unknowinglygibberish1913
@unknowinglygibberish1913 2 жыл бұрын
@@ramneet5733 Yes
@bhuppidhamii
@bhuppidhamii Жыл бұрын
​@@ramneet5733no
@itspace4741
@itspace4741 Ай бұрын
​@@GateSmashers sir notes bhi provide kijiye❤❤❤❤😢😢😢❤❤❤❤
@tanusv8363
@tanusv8363 4 жыл бұрын
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
@kanchanjadhav8055 3 жыл бұрын
"Better than a thousand days of diligent study is one day with a great teacher."
@ADITYASHARMA-dn1si
@ADITYASHARMA-dn1si 3 жыл бұрын
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
@chiragshilwant886 5 жыл бұрын
Sir, You are genius in dbms💯
@shivyogi806
@shivyogi806 5 жыл бұрын
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
@kartiksharma2037 3 жыл бұрын
Legends are still alive Hats Off to you SIR Huge Respect to your work :)
@amangaud3207
@amangaud3207 3 жыл бұрын
Sir, you are amazing. You are shaping the future of our country. Thank you very much for your lectures.
@watchandgainknowledge
@watchandgainknowledge 5 жыл бұрын
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
@kunalkumar6783 Жыл бұрын
Bahoot bahoot dhanyawad sir Aisa quality educational content Dene ke liye 👍🌻🙏
@nasu3991
@nasu3991 3 жыл бұрын
Thank you very much sir. Spent an hour finding this topic here and there and finally got it here.
@vishwabhatt20
@vishwabhatt20 4 жыл бұрын
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
@ParulBedi 3 жыл бұрын
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
@hemensanmahilange4127 Ай бұрын
Super key with super lecturer ... Thank you so much sir for wonderful collection of DBMS concepts.
@SarthakDeshmukh07
@SarthakDeshmukh07 Ай бұрын
Very Thanks Sir 🙏🏻❤
@wtfmangal7920
@wtfmangal7920 Жыл бұрын
I watched full dbms playlist it's very helpful and very best explaination.।।।।। Thank you so much sir 💕💕💕💕💕💕💕💕💕😍😍😍😍
@afrinsultanajui3972
@afrinsultanajui3972 4 жыл бұрын
Your lectures are very helpful..Respect from Bangladesh ❤
@Zeeshankhan-zy3tp
@Zeeshankhan-zy3tp 3 жыл бұрын
One of the best tuitor.....Nice explanation........Your are the best teacher. for me....May Allah gave you more success....Ameen sum ameen...
@MBfan1975
@MBfan1975 Жыл бұрын
better then unacademy
@btsarmyforever7695
@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
@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
@hallohamsa8854 2 жыл бұрын
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
@SCENRIOLIMITED 5 ай бұрын
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
@thisisaniketup 4 жыл бұрын
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
@GateSmashers 4 жыл бұрын
All the best
@itworldnote
@itworldnote 4 жыл бұрын
Very good sir. You always teach every concept very easily. Thank you so much.
@soumi6720
@soumi6720 Жыл бұрын
You are a great teacher Sir.
@yehumang8361
@yehumang8361 5 жыл бұрын
Ab concept achi trah samaj ayea. Kabhi nhi bhulega. Thnku soo much sir
@sajansekhu8785
@sajansekhu8785 3 жыл бұрын
Thnkk u so much sir..Aap itna achaa explain krke bahut se students ki hlp krr rhe ho..God bless u.🙏
@time1702
@time1702 4 ай бұрын
a person in village can study with the help of this thankful for such great content
@sohammehta8815
@sohammehta8815 4 жыл бұрын
100% crystal clear teaching SIR!!🤩🤩
@mehekalinaik3854
@mehekalinaik3854 4 жыл бұрын
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
@GateSmashers 4 жыл бұрын
Good.. Thank you
@tamannasharma3524
@tamannasharma3524 5 жыл бұрын
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
@GateSmashers 5 жыл бұрын
thank you Tamanna..bless you..refer the videos to others also in Canada..
@PratyushSahoo-fo7pu
@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
@backupsqure Жыл бұрын
i was thinking the same u are right
@shashanksharma7747
@shashanksharma7747 3 жыл бұрын
very good and simple explanation very good to watch gate smasher all playlists
@anantgosai8884
@anantgosai8884 Жыл бұрын
Simply amazing..so easy to learn from your video! Thank you!
@bhupinderkaur8426
@bhupinderkaur8426 3 жыл бұрын
Thanks sir, this is the first time that I understand super key concept...
@artitech6668
@artitech6668 2 жыл бұрын
This is true GOLD....good wishes for u sir🌟
@eshaangupta4101
@eshaangupta4101 4 жыл бұрын
The entire concept was clear in the first minute. Great content!
@targetupscias5206
@targetupscias5206 4 жыл бұрын
Sir aap ki video se padh kr maine gr pr hi dbms padh liya hai aap bahut axa padhate hai
@VivekKumar-ei9ez
@VivekKumar-ei9ez 2 жыл бұрын
Sir aap best padate
@sarikagautam2259
@sarikagautam2259 4 жыл бұрын
Awesome explanation 👌 sir it's very helpful....
@debarshidhar7866
@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
@beautyshadesofhimachal....4341 3 жыл бұрын
Best teacher in CSE.........
@samirajput70985
@samirajput70985 4 жыл бұрын
Hello sir I am fan's off ours way of teaching
@KanchanSingh-ge6ez
@KanchanSingh-ge6ez 5 жыл бұрын
Plz aap C++ pe video banaye apka lecture se mughe acche se samjh aata h isliye aap programming languages pe bhi banye video
@hiteshdangi5077
@hiteshdangi5077 5 жыл бұрын
You have good explanation skill
@ShilpikiRemedies
@ShilpikiRemedies 5 жыл бұрын
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
@GateSmashers 5 жыл бұрын
Thank you for your good wishes, appreciation and your compliment.. Lots of blessings...
@salilshukla2686
@salilshukla2686 5 жыл бұрын
Your way of teaching is very good sir.
@sumitshokeen8774
@sumitshokeen8774 5 жыл бұрын
Sir plzzz upload remaining videos As soon as possible and Numerical questions 🙏🙏🙏 Your way of explanation is awesome 👏✊👍
@shahvezkhan9098
@shahvezkhan9098 4 жыл бұрын
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
@animationcrust1993 4 жыл бұрын
You made the concepts easy sir 🙏☺️
@deveshsrivastava9121
@deveshsrivastava9121 3 жыл бұрын
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
@prashanttiwari5237 2 жыл бұрын
Sir your leactures are helping us alot for our UT exams. Thank you so much sir🙏
@kapildhanwani1219
@kapildhanwani1219 5 жыл бұрын
brilliant way to study sir thankyou
@epicboss786
@epicboss786 9 ай бұрын
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
@ZohaibRajpootFromSheikhupura 11 ай бұрын
Love from Pakistan 🇵🇰❤️ Great work sir😊
@ritu9919
@ritu9919 3 жыл бұрын
Thankyou Sir. Your lectures are helpful.
@ashmitasharma9681
@ashmitasharma9681 3 жыл бұрын
Sir u make is understannd every concept ❤️❤️
@rabindra66
@rabindra66 4 ай бұрын
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
@ayushraj-zb6sv 4 жыл бұрын
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
@allgoodcontents 3 жыл бұрын
Thankyou sir
@alifrazkhan124
@alifrazkhan124 3 жыл бұрын
beautifully precise ....great work
@VibeFreshSongs
@VibeFreshSongs Жыл бұрын
You are great sir i love u and your lecture
@nileshmare9662
@nileshmare9662 3 жыл бұрын
if A1 is candidate key then no. of super keys will be 2^(n-1) + 1, because A1 is also a superkey
@ClarkKent-kw8pl
@ClarkKent-kw8pl 20 күн бұрын
yes
@keshavagrawal3396
@keshavagrawal3396 3 жыл бұрын
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
@keertichib4987 2 жыл бұрын
sir you are amazinggggggggggggggggggg !!!!!!!!! thankyou so much for teaching us :)
@justgetit5931
@justgetit5931 4 жыл бұрын
Thank You so Much Sir for your great work fir us. God bless You
@rs-no1ju
@rs-no1ju 5 жыл бұрын
Thanks a lot sir...sir i request you to please upload discrete maths videos for gate..🙏🙏🙏🙏🙏🙏🙏
@golammuktadir4355
@golammuktadir4355 2 жыл бұрын
Excellent Sir, Thanks for your lecture
@bajrangverma
@bajrangverma 5 жыл бұрын
beautiful explanation sir
@AK-us1by
@AK-us1by 3 жыл бұрын
Thanks a lot for such informative tutorial.
@coderahul
@coderahul 5 жыл бұрын
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__
@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
@skdanishali7585 4 ай бұрын
I randomly saw your comment but want to know more about you... Can we be friends?... Waiting for reply
@shashankgali1816
@shashankgali1816 3 жыл бұрын
thanks u sir your videos helped a lot for my interviews❤❤❤
@rajpanwar11
@rajpanwar11 3 жыл бұрын
अद्भुत विश्लेषण
@priyankachatterjee5042
@priyankachatterjee5042 5 жыл бұрын
you are the Super teacher in the world. thank you ^infinity
@heyMonikaa
@heyMonikaa 4 ай бұрын
Cannot thank him enough! 🏋🏻‍♀️✨
@Shreya-ff9dx6fv1s
@Shreya-ff9dx6fv1s 2 жыл бұрын
Thank you so much very clear explanation
@zohaibhassan9622
@zohaibhassan9622 2 жыл бұрын
You teach better than my lecturer. Seriously bro
@bspandey7501
@bspandey7501 5 жыл бұрын
Really sir u r the god of DBMS🙏🙏
@gunjanarya2915
@gunjanarya2915 4 жыл бұрын
Sir please make more vedios for dssb tgt and provide more questions.
@LovepreetSingh-xu7jr
@LovepreetSingh-xu7jr 3 жыл бұрын
Thank you sir ❤️
@anjududdy9949
@anjududdy9949 Жыл бұрын
Very well explained..thanku sir g
@aniketnikam8925
@aniketnikam8925 3 жыл бұрын
Great sir
@K-bhdz
@K-bhdz 5 жыл бұрын
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
@namrataupadhyay5560 3 жыл бұрын
Best...thank you so much!!💞🤗
@nikitajaiswal9112
@nikitajaiswal9112 3 жыл бұрын
Thank you so much sir very great 👏explanation
@eshumir1902
@eshumir1902 5 жыл бұрын
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
@continnum_radhe-radhe Жыл бұрын
❤❤❤
@zubairalee6092
@zubairalee6092 4 жыл бұрын
Great teacher Love you bro One of the best teacher
@tanayasingh9987
@tanayasingh9987 5 жыл бұрын
Sir sabkuch samajh agaya😊☺😁😉. Really confusion ka saval hi ni ab.
@talhamian6465
@talhamian6465 3 жыл бұрын
Only one word "laa javaab"
@AnkitaGupta-ph6xy
@AnkitaGupta-ph6xy 4 жыл бұрын
So helpful lecture ...thanku sir
@vaishnavinain7795
@vaishnavinain7795 4 жыл бұрын
Thnks a lot sir❤you are amazing 👏
@aishwarya1895
@aishwarya1895 2 жыл бұрын
Best explanation ✌️
@nandanaggarwal7444
@nandanaggarwal7444 Жыл бұрын
Amazing sir 👏
@nehavig7584
@nehavig7584 4 жыл бұрын
Sir you have Explained so well🙂 thank you so much 🙏
@shubhamrajput9363
@shubhamrajput9363 3 жыл бұрын
धन्यवाद सर जी
@jyotibajaj5748
@jyotibajaj5748 4 жыл бұрын
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
@megavathpremkumar7456 3 жыл бұрын
Sir u r simply genius ❤️❤️
Lec-14: Introduction to ER model | ER Model क्या है
8:32
Gate Smashers
Рет қаралды 2,3 МЛН
Keys in RDBMS
22:49
Neso Academy
Рет қаралды 356 М.
CAN YOU DO THIS ?
00:23
STORROR
Рет қаралды 44 МЛН
Wait for it 😂
00:19
ILYA BORZOV
Рет қаралды 9 МЛН
小蚂蚁会选到什么呢!#火影忍者 #佐助 #家庭
00:47
火影忍者一家
Рет қаралды 127 МЛН
3.11 Super Key, Candidate Key and Primary Key
21:49
KnowledgeGATE by Sanchit Sir
Рет қаралды 411 М.
Lec 3: Super Key | Candidate Key | Primary Key | Types of keys in DBMS
35:55
Jenny's Lectures CS IT
Рет қаралды 759 М.
Lec 9: Normalization in DBMS | Need of Normalization | DBMS Tutorials
23:32
Jenny's Lectures CS IT
Рет қаралды 589 М.
super key in dbms
10:01
Education 4u
Рет қаралды 204 М.
CAN YOU DO THIS ?
00:23
STORROR
Рет қаралды 44 МЛН