Lec 3: Super Key | Candidate Key | Primary Key | Types of keys in DBMS
Vložit
- čas přidán 20. 11. 2019
- See complete series of DBMS:
• DBMS (Database Managem...
In this lecture, I have described all types of keys(Super key, Candidate Key, Primary Key, Alternate Key, Secondary Key) in DBMS with examples. Discussed all the important points about keys in DBMS,
See Complete Playlists:
Placement Series: • Placements Series
Data Structures and Algorithms: https: • Data Structures and Al...
Dynamic Programming: • Dynamic Programming
Operating Systems: // • Operating Systems
Connect & Contact Me:
Facebook: / jennys-lectures-csit-n...
Quora: www.quora.com/profile/Jayanti...
Instagram: / jayantikhatrilamba
#keysindbms
#typesofkeysindbms
#DBMSnotes
#ugcnet
#gatelectures
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.
sachme padhne ke liye dekha thana video LOL
@Noe Bishop took like 2 secs and Detected this scam
@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.
@@shahjugalr.5504 Thanks for pointing this out.
@Noe Bishop Scammer company.Good business dude.
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.
@@priyanshurai3501 Apne Mammi Papa ko Director office behjo 🤣🤣🤣... Fir wo ghar jaake tips forward karenge 😭😭🤣🤣🤣...
Even my college professor use to see Mam's video before taking lecture of DS🥲
Hi mamate u from java t point noida
Oooo maaa guuuuuuu!!!!!!!!! turu lobbbb!!!!!!!!!!!
@@amanprajapati3417 km se km apke professor ne apko smjhane k liye koi kdm to uthaya hmare yha book se pdhte the bs 😊
Mam, just want to say - Thank you. I have no better words to describe how thankful I am to you.
@@tejasrinivas_ wtf
@@raunvk really
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 !!!
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.
Can you understand Hindi?
@@yashupadhyay8993 why you asking that (˘･_･˘)
@@roronoa_zoro coz' she is from usa
@@yashupadhyay8993 the videos are in english
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
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
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
i have watched many videos on youtube about that topic. But you provide something unique than others. i am grateful to you.
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...
You're much better even 100x than mine university teachers. Thanks Ma'am
Very much enlightening! I did understand DBMS keys practically but still confuse in the theory. A thousand thanks to you from Indonesia! :)
our entire group watches your video lecture and learn from it...thank you so much for such a beautiful explantion💗💖
I have not seen this kind of explanation of keys in DBMS anywhere. You explain everything in a very simple way!
Great lecture Never see this level of content anywhere. We need teacher like you
Beautifully explained- Keep it up ! Never seen anyone explain so easily - very easy to understand ! THANK YOU !
From my college teachers to CZcams and then Nptel, no one could explain it
You really are best teacher
A, D, AB, AC, AD, DB, DC, ABC, ACD, ABD, BCD, ABCD= 12 SUPER KEYS
yes I also got that but is it correct ?
well done
yess it is correct@@63_tanishkgupta55
i had 8 super keys, since A and D are already CKs they both cant be put in one relation hence the 8
@@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.
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!
Ma'am your making complex concepts into simple concepts really helpful and thank you so much ma'am.
Your videos saved my life this semester! Thank you Jenny!
Hi Jayanthi,
I really liked the way of your teaching. It’s so amazing. I feel so fortunate to find your CZcams 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.
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.
Thanx alot, got DBMS exam on 16th Dec, hope the topics will be covered till then.... u'r the best
Alot of thanks to you mam.
Even hindi videos are much difficult to understand but I found yours video very helpful only.
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 ❣️❣️❣️
Really excited to learn such new concepts from you.. Mam....
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% 👍
Super explanation..I think trainers like u are raree♥️
You make my life... Till now I always got confused in KEYS... now all clear in mind... Great explanation...👏👏👌👌
I really find your lectures effective, every time I watch. Much credits to you mam. 👍
you are a wonderful teacher and you have made my learning easy.God bless you
so much
Excellent job Jenny. You're a very good teacher. Using your videos for a college database class. Thank you.
tu h to muje phie or kya chiye........
I like ur teaching style more attractive..thanks alot
Excellent teaching. Thank you very much Jenny. I will watch all your videos.
Thank you from the United States! You are an amazing professor. Very grateful for your Python, database, and data structures content.
0:34 dd
Explanation is so good that I can easily understand at 1.25x too
Thank you, your lectures helped me a lot.
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.
Thank you, your DBMS series and explanations are really good.
Your videos are really helping dull students,
Much love and support from mumbai ❤💯
Your lectures are AWESOME!!!
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
Thank You so much Ma'am for such great content...
I cant say how much u helped to improve in me. Teaching is so clear cut continue this 👍✨
Fully satisfied with this lecture.
Thank you so much mam your lecture is very clearly not any problems in your lectures. Thank you so much again 🙏
Great Video, great style, and great examples. Everything's superb about this Girl. Thankyou
finally understood the difference between subsets and proper subsets, omg! I always confuse them! But now I won't anymore, thank you!
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
i also got 12 super keys
Why don't u write DA as a super key
@@kalyanamephraim4393 it's same as AD
@@JungFilms nope its different
@@akhilreddy3434 no it is same ....order doesnt matter
This is wonderful explanation, I wish I had your lectures during my engineering time
Best clarity of concept ever
Thank you so much ma'am
You Presentation is like serving delicious food..😊👍🏻
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.
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.❤️
Mam, superb teaching with a wonderful explanation skills, thank u keep teaching
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
Damn 💥 finally found some good stuffs in youtube !!
You explained it very clearly. Bunch of thanks❤❤❤
Mam super .two year I don't know this concept.now I have. Very clear.
It's not just a key; it's a super explanation.
If u are my teacher my attendance will be 100% and I learn full subject from u
Thank you ma'am, your elaboration is just awsome, Thank you
Really good explanation...even a fresher can catch it...lots of love ☺️
Is this series completed or more are coming, because some topics like E-R and DFD diagrams, hashing, indexing etc are missing which are part of DBMS. It will be appriciated if you can post all other topics as well.
There will be total 12 superkeys which are given below..
A,AB,AC,AD,ABC,ABD,ACD,ABCD,D,DB,DC,DCB
no there will be 9SK because d is the last attribute
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
@@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)
can you elaborate it sir
You are absolutely correct.
Your explanation is simply superb ma'am not only DBMS Im following your OS videos also
What a productive Saturday. Thank you, hugs from Brazil
thank you very much!!!
is teaching your full time job??
thank you so much mem ..!
Beautiful and detailed explanation !
Super mam in easy way u understand the concepts with no confusion thank u
Yes mam , We Need more Lectures on DBMS .You are Doing Fabulous Work Mam.
I have fast paced ones.
hey jenny tutor i big fan
your my mind pulse for study
It was soo easy to understand through this video🌸 great work
thanks maam , for making this subject interesting and simple.. best wishes maam
amazing work!!
Hii
yesss finally I understand Candidate Key tyyyyyyyyyyyyyyyyyyyyyyyyyyy
Mam, you teaching and content is excellent, no comparison, it's unique
You are really a great teacher!
12:00 (name,marks,dept) can not be a super key,
(marks,dept,course) is a super key.
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.
@@poojapatidar8045 Yes it can be same but the question is only for the given 5 lines !
@@adityajoshi15 So do we have to answer on the basis of given table only ?
@@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.
35:40 SK = A, D, AB, AC, AD, BD, CD, ABC, ABD, ACD, BCD, ABCD
Correct me if i am wrong :)
12 yes it's correct same 🙋meri bhi 12 sk aa rahi h
its correct i got the same
@@afsanakhan589 yeah yaar I got the same
Correct 👍
yes 12 is correct
🙏 Thanks for your easily understandable lectures.
you are an amazing teacher...
love from Hazaribag (Jharkhand)
12:12
No, Yes
35:40
Super keys: A, D, AB, AC, AD, BD, CD, ABC, ACD, ABD, BCD, ABCD
in 12:12 neither the first one nor the second one are not super key... you cant identify a class by {marks,course,department}
why?,
how? why not 13 BC
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.
@@mehrdadghassabi2504 with the given data you can
@@jamesbaysah7630 because neither of b or c is a candidate key
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
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.
Great job......your teaching skill is amazing
A,D,AB,AC,AD,CD,BD,BCD,ABC,ACD,ABD
the above mentioned are the superkeys mam
ABCD should also be there
Miss jenny,Can you please upload video about normalization in DBMS?i'm from sri lanka
Excellent lecturing , Jenny mam.Thank you.
its another level maximum utilization woah . fantastic.
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.
31 is not max keys available , is the the max no of keys possible
tomorrow is my DSA paper and here i am studying DBMS at 5 AM
You covered very confusing topic in a very simple way. Good content. I subscribed. :)
you deserve more, thanks alot, hello from iraq
Mam plzz upload vedio on SQL
awesome explanation!
and for the last question here is my answer:
A,AB,AC,AD,ABC,ACD,ABD,ABCD,D,BD,CD,BCD.
yep,correct
I love you mam .. i love the way you teach and that cutest smile when you make while teaching i love that.
Well explained, It seemed hard but upon explaining I'm confident
mam i have a doubt about how did u call the combination of (BC) a super key while demonstrating a candidate key when they had some values in common, can u plss explain it
Hi i too have this same doubt...... Can anybody explain it?