Lec 3: Super Key | Candidate Key | Primary Key | Types of keys in DBMS
Вставка
- Опубліковано 20 лис 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 😊
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.
Mam, just want to say - Thank you. I have no better words to describe how thankful I am to you.
@@tejasrinivas_ wtf
@@raunvk really
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 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 !!!
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
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
our entire group watches your video lecture and learn from it...thank you so much for such a beautiful explantion💗💖
i have watched many videos on youtube about that topic. But you provide something unique than others. i am grateful to you.
Very much enlightening! I did understand DBMS keys practically but still confuse in the theory. A thousand thanks to you from Indonesia! :)
From my college teachers to UA-cam and then Nptel, no one could explain it
You really are best teacher
Your videos saved my life this semester! Thank you Jenny!
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!
I have not seen this kind of explanation of keys in DBMS anywhere. You explain everything in a very simple way!
Hi Jayanthi,
I really liked the way of your teaching. It’s so amazing. I feel so fortunate to find your UA-cam 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.
Ma'am your making complex concepts into simple concepts really helpful and thank you so much ma'am.
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
Really excited to learn such new concepts from you.. Mam....
Beautifully explained- Keep it up ! Never seen anyone explain so easily - very easy to understand ! THANK YOU !
Great lecture Never see this level of content anywhere. We need teacher like you
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.
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........
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 ❣️❣️❣️
Alot of thanks to you mam.
Even hindi videos are much difficult to understand but I found yours video very helpful only.
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
Thank you from the United States! You are an amazing professor. Very grateful for your Python, database, and data structures content.
0:34 dd
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.
Thank you, your lectures helped me a lot.
Thank You so much Ma'am for such great content...
Explanation is so good that I can easily understand at 1.25x too
Thank you, your DBMS series and explanations are really good.
Thanx alot, got DBMS exam on 16th Dec, hope the topics will be covered till then.... u'r the best
Your lectures are AWESOME!!!
Super explanation..I think trainers like u are raree♥️
you are a wonderful teacher and you have made my learning easy.God bless you
so much
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% 👍
You make my life... Till now I always got confused in KEYS... now all clear in mind... Great explanation...👏👏👌👌
I like ur teaching style more attractive..thanks alot
Excellent teaching. Thank you very much Jenny. I will watch all your videos.
This is wonderful explanation, I wish I had your lectures during my engineering time
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.
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
I really find your lectures effective, every time I watch. Much credits to you mam. 👍
finally understood the difference between subsets and proper subsets, omg! I always confuse them! But now I won't anymore, thank you!
I cant say how much u helped to improve in me. Teaching is so clear cut continue this 👍✨
Your videos are really helping dull students,
Much love and support from mumbai ❤💯
Thank you so much mam your lecture is very clearly not any problems in your lectures. Thank you so much again 🙏
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
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.
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
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.
Mam, superb teaching with a wonderful explanation skills, thank u keep teaching
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.❤️
Thank you ma'am, your elaboration is just awsome, Thank you
Fully satisfied with this lecture.
Damn 💥 finally found some good stuffs in youtube !!
Best clarity of concept ever
Great Video, great style, and great examples. Everything's superb about this Girl. Thankyou
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
It's not just a key; it's a super explanation.
You are really a great teacher!
Hi Jenny, As per the definition of the Primary Key, can Super Keys and Candidate Keys consists with "Null Values"? Also If we consider "BC" as the Primary Key in your example, then it should be called as the Composite Key right? @31:00
hey jenny tutor i big fan
your my mind pulse for study
thank you so much mem ..!
Beautiful and detailed explanation !
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?
Mam plzz upload vedio on SQL
What a productive Saturday. Thank you, hugs from Brazil
You explained it very clearly. Bunch of thanks❤❤❤
Yes mam , We Need more Lectures on DBMS .You are Doing Fabulous Work Mam.
I have fast paced ones.
A, AB, AC, AD, ABC, ABD, ACD, ABCD, D, DC, DB, DCB. Total: 12 SKs. Did I get it correctly?
y
Yes
D is not given in relation
@@akankshajha7323 d is super key
Among the 15, we can ignore {B}, {C} and {B,C}. So, 12 is the answer I guess
thanks maam , for making this subject interesting and simple.. best wishes maam
🙏 Thanks for your easily understandable lectures.
If u are my teacher my attendance will be 100% and I learn full subject from u
A,AB,AC,AD,ABC,ABD,ACD,ABCD,
D,DB,DC,DCB
Is It Correct Or Not Maam??
Plz Reply !
Of course
@@harithakumariphoghat6814 ha.yes
@@harithakumariphoghat6814 are you Telugu
Why DCBA is not included
@@vikhyatverma4016 ABCD or DBCA both are same only order is different.. that's we will take only one
It was soo easy to understand through this video🌸 great work
Consider the relation CLASS(Course#, Univ_Section#, Instructor_name, Semester, Building_code, Room#, Time_period, Weekdays, Credit_hours). This represents classes taught in a university, with unique Univ_section#. Identify what you think should be various candidate keys,
yesss finally I understand Candidate Key tyyyyyyyyyyyyyyyyyyyyyyyyyyy
thank you very much!!!
is teaching your full time job??
Really good explanation...even a fresher can catch it...lots of love ☺️
Super mam in easy way u understand the concepts with no confusion thank u
amazing work!!
Hii
Miss jenny,Can you please upload video about normalization in DBMS?i'm from sri lanka
Amazing work! Thanks for the help. From sg
You an amazing job explaining. Keep it up!
12:12 NO,YES ;)
same felling bro
@@muhammedshifanp7455 no,yes or no,no(there can be another nisha in same course with same department and marks)
@@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.
Yes i also got 12
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.
Mam can two attributes in a table forming a candidate key, possible to become a primary key? or I there any constraint that only one attribute can be primary key
Well explained, It seemed hard but upon explaining I'm confident
A,D,AB,AC,AD,CD,BD,BCD,ABC,ACD,ABD
the above mentioned are the superkeys mam
ABCD should also be there
tomorrow is my DSA paper and here i am studying DBMS at 5 AM
Mam super .two year I don't know this concept.now I have. Very clear.
Brilliant, thank you very much!
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