Lec 3: Super Key | Candidate Key | Primary Key | Types of keys in DBMS

[@haswanthsk7428]

Seriously I have never seen anyone teach so wonderfully, keep rocking and continue this thing and really you deserve a lot more. Love from Chennai.

[@shahjugalr.5504]

sachme padhne ke liye dekha thana video LOL

[@shahjugalr.5504]

@Noe Bishop took like 2 secs and Detected this scam

[@watchlistsclips3196]

@Erick Cohen For every youtube channel i am seeing scammers using the same concept of in less than 15 minutes hacked girl friend instagram password google. Like stop scamming people.Every please be careful of these guys you will see lot of these people in most of the related channels.

[@watchlistsclips3196]

@@shahjugalr.5504 Thanks for pointing this out.

[@watchlistsclips3196]

@Noe Bishop Scammer company.Good business dude.

[@dr.sheetalsingh3379]

I am professor in Galgotias University , in greater Noida. So many teachers available on you tube to teach DBMS. But your way too calm and peaceful. You have teachings skill by birth. Because I know the power of explanation in teaching. Thank you.

[@navdeeptyagiziro]

@@priyanshurai3501 Apne Mammi Papa ko Director office behjo 🤣🤣🤣... Fir wo ghar jaake tips forward karenge 😭😭🤣🤣🤣...

[@amanprajapati3417]

Even my college professor use to see Mam's video before taking lecture of DS🥲

[@prasadkirapatla3539]

Hi mamate u from java t point noida

[@chiranjeevisagarkommula6823]

Oooo maaa guuuuuuu!!!!!!!!! turu lobbbb!!!!!!!!!!!

[@sarangdwivedi8245]

@@amanprajapati3417 km se km apke professor ne apko smjhane k liye koi kdm to uthaya hmare yha book se pdhte the bs 😊

[@basudhasakshyarika1592]

Mam, just want to say - Thank you. I have no better words to describe how thankful I am to you.

[@raunvk]

@@tejasrinivas_ wtf

[@chakrisneelam1393]

@@raunvk really

[@mylesmcleod5938]

Greetings from Atlanta, Georgia. Your videos are superb. I watched 21 of these DBMS videos in the days leading up to my exam last Saturday. This particular video on keys is a classic.

[@yashupadhyay8993]

Can you understand Hindi?

[@roronoa_zoro]

@@yashupadhyay8993 why you asking that (˘･_･˘)

[@yashupadhyay8993]

@@roronoa_zoro coz' she is from usa

[@phenomx358]

​​@@yashupadhyay8993 the videos are in english

[@hayatahmad6443]

You're much better even 100x than mine university teachers. Thanks Ma'am

[@diahmartina1445]

next week is my first midterm exam in college, and I was so grateful to find this channel, especially this playlist to help me study about DBMS. thank you so much and keep going

[@krupa1963]

12:12 No, Yes 35:40 Super keys: A, D, AB, AC, AD, BD, CD, ABC, ACD, ABD, BCD, ABCD

[@mehrdadghassabi2504]

in 12:12 neither the first one nor the second one are not super key... you cant identify a class by {marks,course,department}

[@jamesbaysah7630]

why?, how? why not 13 BC

[@ideator5453]

Cause, the given information is that only {A} and {D} are C.K(candidate key). All the candidate keys are superkeys, and other attributes considered to be alternate or secondary keys. So, BC does not have neither of the C.Keys so it is not a superkey.

[@priyanshuganatra]

@@mehrdadghassabi2504 with the given data you can

[@chemistrywithmeghana8223]

​@@jamesbaysah7630 because neither of b or c is a candidate key

[@srinivaschinta3061]

wow... I learnt DBMS about 4 years ago while preparing for GATE.. Now while attempting RRB PO exam I happened to search for DBMS and found you.... Wonderful class.. Will watch your videos post my exam too ... Fun to learn over here and efficient too...

[@anuthomas183]

I am so happy that finally I thoroughly understand the concept of keys...I subscribed this channel she is really a good teacher..the way of her teaching is simple and understandable thank you so much mam...thank you for the efforts

[@dmangee2]

Thank you from the United States! You are an amazing professor. Very grateful for your Python, database, and data structures content.

[@kapilpalanivel2309]

0:34 dd

[@User-meme1232]

Hi Jayanthi, I really liked the way of your teaching. It’s so amazing. I feel so fortunate to find your KZbin channel. I wish I were younger than you to convey my gratitude this 🙏🏻way. The concept of keys deeply stuck in my mind. Here is my answer for the question at the end of this video. A, AB, AC, AD, ABC, ABD, ACD, ABCD, D, DB, DC, DBC total 12 Super Keys in the relation R(A,B,C,D) given A & D are the Candidate Keys. Hope my answer is correct and thank you once again.

[@JyotiSharma-wb1vy]

I have not seen this kind of explanation of keys in DBMS anywhere. You explain everything in a very simple way!

[@user-gq1ij]

From my college teachers to KZbin and then Nptel, no one could explain it You really are best teacher

[@madihaiman0817]

A, D, AB, AC, AD, DB, DC, ABC, ACD, ABD, BCD, ABCD= 12 SUPER KEYS

[@63_tanishkgupta55]

yes I also got that but is it correct ?

[@onepunman2253]

well done

[@onepunman2253]

yess it is correct@@63_tanishkgupta55

[@GloriaGordon-Mensah-to1bg]

i had 8 super keys, since A and D are already CKs they both cant be put in one relation hence the 8

[@unknownperson7265]

@@GloriaGordon-Mensah-to1bg there are no rules like that. You can clear your doubt by considering the fact that AD being together can still uniquely identify a tuple so AD is, by definition, a super key. The correct answer is still 12.

[@cybergeek1218]

Excellent job Jenny. You're a very good teacher. Using your videos for a college database class. Thank you.

[@inventanything2423]

tu h to muje phie or kya chiye........

[@RRR-le1dr]

Explanation is so good that I can easily understand at 1.25x too

[@developeraman7190]

2x here

[@polashpaul9182]

i have watched many videos on youtube about that topic. But you provide something unique than others. i am grateful to you.

[@animeshtripathi693]

04:30 Keys in DBMS are vital for uniquely identifying records. 09:00 Keys in DBMS are essential for uniquely identifying records in a database. 13:30 Super key is an attribute or set of attributes that uniquely identify each record in the table. 18:00 The formula to calculate the number of super keys in a relation is n factorial upon r factorial n minus r factorial 22:30 Super key is a theoretical concept and not used in databases. 27:00 Understanding proper subsets and super keys in DBMS 31:30 Candidate Key and Minimal Super Key 35:55 Candidate keys can be selected as alternate keys or secondary keys, primary key has no null value constraint

[@vishwabhatt20]

our entire group watches your video lecture and learn from it...thank you so much for such a beautiful explantion💗💖

[@shivalikagupta3433]

Your work is truly good, you explain all the parts a certain topic can have to understand. The way of explaining, you pace is also great. The way you explain using different examples. You even took examples to explain proper subset and subset.You dont need to replay any part to understand, neither do you need to search anything. Its truly hardwork. Its visible . Kudos. Thanks you !!!

[@muhammadfajrulr.4761]

Very much enlightening! I did understand DBMS keys practically but still confuse in the theory. A thousand thanks to you from Indonesia! :)

[@ankittripathi420]

Hey mam you just pulled me to study and now I am very curious to know that what's the next after this thank you so much ma'am ❣️❣️❣️

[@muraribohra925]

You make my life... Till now I always got confused in KEYS... now all clear in mind... Great explanation...👏👏👌👌

[@anbuthaaru6498]

Mam super .two year I don't know this concept.now I have. Very clear.

[@ferzanasajim3107]

I like ur teaching style more attractive..thanks alot

[@sciencetechforyou1998]

These are the only decent lectures available on DBMS.

[@amitkumargupta6722]

There will be total 12 superkeys which are given below.. A,AB,AC,AD,ABC,ABD,ACD,ABCD,D,DB,DC,DCB

[@Theraiseofnewempire]

no there will be 9SK because d is the last attribute

[@prachiihiremath6713]

Can you please answer how can write "5C1", because if we consider individually ,marks are same and even the names....how can those be superkeys

[@naveenarya5233]

@@prachiihiremath6713 When marks and names are same , in that case go with Sid man bcz, it's different or unique in each row .(5c1 = Sid)

[@brightys258]

can you elaborate it sir

[@jirehag5140]

You are absolutely correct.

[@neelasatyasai6852]

I just casually searching for DBMS video to prepare for day after tommaro's EXAM to just pass.Literally i was wondered how I got interest to study further DBMS videos. Thankfully I have time to watch all videos. I really thankful to you mam.❤️

[@skibbidy-boo-bippity-bop]

Your videos are very well put together and a tremendous time saver. I am building a knowledge management system for a scientific company and simply do not have the time to learn relational algebra. Thank you for building the bridge between practice and the highly abstract!

[@cmmsilva]

What a productive Saturday. Thank you, hugs from Brazil

[@marianette1772]

Your videos saved my life this semester! Thank you Jenny!

[@gopavaramsaimadhuree520]

your videos are amazing. It is crystal clear.I was able to do my Data structures model practicals perfectly after watching your videos.Concepts were so clear that I got the output in less time when compared to others.Thank you so much

[@DQuranJar]

35:40 SK = A, D, AB, AC, AD, BD, CD, ABC, ABD, ACD, BCD, ABCD Correct me if i am wrong :)

[@ritikashishodia675]

12 yes it's correct same 🙋meri bhi 12 sk aa rahi h

[@afsanakhan589]

its correct i got the same

[@rajeshmoharana9366]

@@afsanakhan589 yeah yaar I got the same

[@mohdfaiyaz414]

Correct 👍

[@KABITAKOTHARI]

yes 12 is correct

[@virginiasera]

Thank you so much Jenny you are the reason why I started to love programming, your explanations are so easy to grasp may God bless you.

[@adinathkolhapure6697]

12:00 (name,marks,dept) can not be a super key, (marks,dept,course) is a super key.

[@poojapatidar8045]

But in ( marks,dept,course) Marks of two students can be same and dept and course also can be same, so it think it should not be a super key.

[@adityajoshi15]

@@poojapatidar8045 Yes it can be same but the question is only for the given 5 lines !

[@mohsinimam2048]

@@adityajoshi15 So do we have to answer on the basis of given table only ?

[@sciencetechforyou1998]

@@poojapatidar8045 Adinath's answer is correct. We dont have to apply our common sense. Answer will be according to the data given in the table.

[@MeejinBL-Univers]

Great lecture Never see this level of content anywhere. We need teacher like you

[@omarashraf1341]

It's not just a key; it's a super explanation.

[@pujasinha1361]

you are an amazing teacher... love from Hazaribag (Jharkhand)

[@_RamyaSriChowdary]

Super explanation..I think trainers like u are raree♥️

[@edunewstn]

I have never seen this much of clarity in teaching in anyone other than u Mam👌 Fantastic Job... Keep Going Mam 👍 Ans:- A,AB,AC,AD,ABCD,ABC,ABD,ACD,D,DC,DB,DBC

[@stackritesh]

i also got 12 super keys

[@kalyanamephraim4393]

Why don't u write DA as a super key

[@JungFilms]

@@kalyanamephraim4393 it's same as AD

[@akhilreddy3434]

@@JungFilms nope its different

[@swiftpeace]

@@akhilreddy3434 no it is same ....order doesnt matter

[@farzanabatool2728]

best explanation 👍👍 thank you madam... {Name,marks,dept}not super key {marks,course, deppt} is super key 3)👉13 numbers of super key than you madam lots of best wishes from ladakh

[@mrankushtechnical]

14:21 short trick , calculate the number of subsets. 2^n-(1)here n is number of attributes.

[@th4mmu683]

Thats wht she said....

[@sushantkumar4917]

2^n - 2 we are not considering phi

[@gganeshkumar639]

If u are my teacher my attendance will be 100% and I learn full subject from u

[@sajeedsyed710]

After watching a lots of videos,I visited one the best video.

[@rajprajapati7697]

Really excited to learn such new concepts from you.. Mam....

[@champladharavath341]

Your explanation is simply superb ma'am not only DBMS Im following your OS videos also

[@indrapatel7988]

Ma'am your making complex concepts into simple concepts really helpful and thank you so much ma'am.

[@ankitsajwan4239]

Thanx alot, got DBMS exam on 16th Dec, hope the topics will be covered till then.... u'r the best

[@PROTECHRAHUL]

Alot of thanks to you mam. Even hindi videos are much difficult to understand but I found yours video very helpful only.

[@MayankYADAV-qs1ql]

Total 8 super key are ab ac abc db dc bcd and obviously a & d. Mam u r so sweet that I am unable to fully concentrate & thanks for sharing ur knowledge in such simple way all Student like me are thankful to u and teachers like u are real teachers.

[@fireking5515]

ad and abcd?

[@abhishekkhatana5654]

Yes mam , We Need more Lectures on DBMS .You are Doing Fabulous Work Mam.

[@BahawalTV]

I have fast paced ones.

[@AbdulHafeez-ov4fw]

Mam your way of teaching is so awesome. 10M deserves ♥️♥️♥️ Love from Pakistan

[@advaitchitnis5314]

Your videos are really helping dull students, Much love and support from mumbai ❤💯

[@mdomarfaruq3160]

I am from Bangladesh, I really enjoy your lecture. I understand your lecture easily. You are the best teacher. I also see your other lecture like DataStructure, C programming.

[@roqayamuhammad7867]

awesome explanation! and for the last question here is my answer: A,AB,AC,AD,ABC,ACD,ABD,ABCD,D,BD,CD,BCD.

[@nathamuni9435]

yep,correct

[@priyanshupatel3005]

All i just wanna say that Mam your teaching style is just awesome.... No one can take place of you in teaching like in cricket M S DHONI💙💙.....and my request is to again continue this course ......

[@riteshkatare1433]

kohli can

[@pradeepwavhale4329]

Thank you so much ma'am You Presentation is like serving delicious food..😊👍🏻

[@Selenic_c]

Needed playlist on TOC..!! Srsly ur teaching style is just amazing... I Cleared DS and DAA in first attempt..!Thanks u sooo much ❤️ 😊

[@fitoremorina2894]

Your lectures are AWESOME!!!

[@shivampandat8086]

Teaching is not all about the great knowledge you have.... Teaching is a skill... And literally mam yours 35 min Lecture is just like 5 min Lecture ☺

[@techie052]

Fully satisfied with this lecture.

[@whodunit9894]

Thank you!!! Love from Institute of space tech , Islamabad, U saved meeeee

[@radiagulzan]

finally understood the difference between subsets and proper subsets, omg! I always confuse them! But now I won't anymore, thank you!

[@dileepwriter1]

You are super key to every student

[@aravindhkrishna3082]

I cant say how much u helped to improve in me. Teaching is so clear cut continue this 👍✨

[@biggpappa2966]

Thank you very much. You don't know how much you are helping me my studying🥰🥰🥰 without you and your lecturer I would or will be in big trouble 😥 you are the ligth of my life. Love you from bottom of my heart ❤ and I mean that 100% 👍

[@onetapdax5921]

tomorrow is my DSA paper and here i am studying DBMS at 5 AM

[@bobbyrajayadav2003]

Thank you mam you are providing us great knowledge that our colleges might not be

[@elyasaf755]

A, AB, AC, AD, ABC, ABD, ACD, ABCD, D, DC, DB, DCB. Total: 12 SKs. Did I get it correctly?

[@lalitajain8308]

y

[@sampathkavala6976]

Yes

[@akankshajha7323]

D is not given in relation

[@deepaliverma5110]

@@akankshajha7323 d is super key

[@bense_tony]

Among the 15, we can ignore {B}, {C} and {B,C}. So, 12 is the answer I guess

[@studywithRj1998]

Great job......your teaching skill is amazing

[@bishalrajbhattarai5482]

Damn 💥 finally found some good stuffs in youtube !!

[@akashhudge5735]

This is wonderful explanation, I wish I had your lectures during my engineering time

[@elwhashms]

you Blow my mind but finally I can understand the different between Sk and CK so clearly The answer is 12 SK Right? I wish you Can explain when can I use (2^n)-1 ? or I can use it for thinking what is the maximum potential of having SuperKey

[@tejeswar5925]

you can use that formula when each and every individual attribute can act as a super key. In other words, each attribute can uniquely identify each record/tuple of the relation.

[@hemanthlishetti154]

THANK YOU SO MUCH MAM you are teaching so wonderfully....so many concepts got clarified..Respect and wish u Happy Womens day mam..with lots of love

[@jisanhasnat6770]

Thank you, your lectures helped me a lot.

[@abidaryn2121]

Amazing teaching Please keep it love you from Afghanistan

[@sauravsharma3893]

Thank You so much Ma'am for such great content...

[@miransh]

Beautifully explained- Keep it up ! Never seen anyone explain so easily - very easy to understand ! THANK YOU !

[@kempilivenkatesh1891]

A,D,AB,AC,AD,CD,BD,BCD,ABC,ACD,ABD the above mentioned are the superkeys mam

[@shubhikagupta7158]

ABCD should also be there

[@vivelafootball4835]

I finished my struggle of understanding keys after this video...great explanation ma'am ... Thank you for your efforts 😊

[@muhammadhamzabutt7172]

A,AB,AC,AD,ABC,ABD,ACD,ABCD, D,DB,DC,DCB Is It Correct Or Not Maam?? Plz Reply !

[@harithakumariphoghat6814]

Of course

[@devaKumar-du6mr]

@@harithakumariphoghat6814 ha.yes

[@devaKumar-du6mr]

@@harithakumariphoghat6814 are you Telugu

[@vikhyatverma4016]

Why DCBA is not included

[@magicalfacts5115]

@@vikhyatverma4016 ABCD or DBCA both are same only order is different.. that's we will take only one

[@soumyadeepchatterjee9802]

She explains very nice & she is very serious also.

[@saiprasadraktate3012]

How each attribute individually defines the row? If it's not defining individually, then it's not super key. So there will be not 31max. superkeys available.

[@paawantripathy9349]

31 is not max keys available , is the the max no of keys possible

[@induniljay2072]

world best teacher i ever seen ;)

[@roqayamuhammad7867]

12:12 NO,YES ;)

[@trinadhkalisetti8506]

same felling bro

[@LostHero1]

@muhammedshifan p no,yes or no,no(there can be another nisha in same course with same department and marks)

[@prarambhiksur2104]

@@LostHero1 same doubt I have here , there can be different student with same marks same department and same course . So I think NO and NO.

[@sominpal3188]

Yes i also got 12

[@ഇല്ലുമണവാട്ടി]

Really loved ur way of teaching... ❣️ thank u mam... Lots of love from kerala...❣️❣️❣️

[@letusc8497]

if we have more than one null value (and all values are unique) in an attribute will that be a candidate key? 35:44 my answer: A,D,AB,AC,AD,BD,CD,ABC,BCD,ABD,ACD,ABCD = 12 super keys

[@sarveshIASaspirant]

Your Explanation method is too good Mam and most important think is that your Voice is like a Koyal Bird really....

[@maitreyeroy8272]

amazing work!!

[@rajeshmoharana9366]

Hii

[@bookalicious9849]

hi sis!!!! i really wanna say this that you are my saviour!!!!!!!!i wish i knew about you earlier :( your lectures are wonderful and all my friends are a huge learning fan of yours:)....i will never forget you in my life ever ;)

[@mdomarfaruq3160]

12:00 {Name, Marks, Dept} Not Super Key {Marks, Course, Dept} Super Key 35:35 Super keys are { A, AB, AC, AD, ABC, ABD, ACD, ABCD, D, DC, DB, DCB}

[@waleedsajid2501]

marks , course and dept can be more than in a table but name,marks and dept can only be one so its a super key

[@ash_177]

Thank you, your DBMS series and explanations are really good.

[@sachinmaurya3259]

thank you very much!!! is teaching your full time job??

[@sukh-e4206]

Best clarity of concept ever

[@aymannasr1323]

yesss finally I understand Candidate Key tyyyyyyyyyyyyyyyyyyyyyyyyyyy

[@adityaverma10114]

Ma'am no words are enough to compliment you

[@pancekaradzov3885]

I like your attitude a lot, it screams to me 'YOU GONNA PASS!', even tho I feel like a donkey for my tomorrow's exam lol

[@yashupadhyay8993]

Bhut easy way me padhate he mam aap 😍😍

[@rawlife3666]

I like your videos, & the most interesting thing is my professor when I learned RDBMS didn't tell me about SK, and now after asking about SK to him he told me. So, is it important in DBMS interviews?? waiting for your reply.

[@stutipandey9514]

Mam, you teaching and content is excellent, no comparison, it's unique