@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.
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.
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.
@@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.
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
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...
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
Hi Jayanthi, I really liked the way of your teaching. It’s so amazing. I feel so fortunate to find your RUclips 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.
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.
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 !!!
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
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!
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 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.❤️
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
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.
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% 👍
{Name, Mark, Dept} can not be super key because one duplicate is present but {Marks, Course, Dept} are uniquely identify each rows, hence it is a super key
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
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.
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 ......
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.
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.
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.
A and D are Candidate Keys. So, A and D must be SuperKeys too. So, the superkeys are -> A, AB, AC, AD, ABC, ACD, D, BD, CD, BCD Just to let you know, I am a 3rd year non-CS undergraduate student, and I am learning DBMS for the sake of my own interest. I have been following you since June and your lectures seem to be very useful in terms of Understanding Concepts. I have also subscribed your 2nd channel.
Hi, You said that if we want to find out max number of super keys which we can create on a table,then apply 2 (power n)-1. But in your example, there are 4 attributes i.e, A,B,C and D. If we apply same logic i.e, 2 (power n)-1, we will get 2(power 4)-1= 15. But you said that we can have 8 max number of super keys i.e A and A,C and A,B and A,D and A,B,C and A,B,C,D and A,B,D and A,C,D. It should be 15, as per your logic, but you got 8. Please explain clearly.
if we have n attributes with one candidate key then no of possible super keys are 2 power(n-1) .so we got 8 super keys.But for a relation R having n attributes...no of super keys are 2 (power n) -1.
For finding maximum possible super keys in that given relation we'll use that formula, here just we need to find the total no. of keys present in the given relation.
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
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
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
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
You're much better even 100x than mine university teachers. Thanks Ma'am
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.
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
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...
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
Hi Jayanthi,
I really liked the way of your teaching. It’s so amazing. I feel so fortunate to find your RUclips 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.
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
Thank you from the United States! You are an amazing professor. Very grateful for your Python, database, and data structures content.
0:34 dd
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........
Explanation is so good that I can easily understand at 1.25x too
I have not seen this kind of explanation of keys in DBMS anywhere. You explain everything in a very simple way!
i have watched many videos on youtube about that topic. But you provide something unique than others. i am grateful to you.
our entire group watches your video lecture and learn from it...thank you so much for such a beautiful explantion💗💖
From my college teachers to RUclips and then Nptel, no one could explain it
You really are best teacher
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 ❣️❣️❣️
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 !!!
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
You make my life... Till now I always got confused in KEYS... now all clear in mind... Great explanation...👏👏👌👌
Very much enlightening! I did understand DBMS keys practically but still confuse in the theory. A thousand thanks to you from Indonesia! :)
I like ur teaching style more attractive..thanks alot
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 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!
What a productive Saturday. Thank you, hugs from Brazil
Super explanation..I think trainers like u are raree♥️
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
It's not just a key; it's a super explanation.
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.
Alot of thanks to you mam.
Even hindi videos are much difficult to understand but I found yours video very helpful only.
Mam super .two year I don't know this concept.now I have. Very clear.
Ma'am your making complex concepts into simple concepts really helpful and thank you so much ma'am.
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.❤️
If u are my teacher my attendance will be 100% and I learn full subject from u
Your explanation is simply superb ma'am not only DBMS Im following your OS videos also
A,D,AB,AC,AD,CD,BD,BCD,ABC,ACD,ABD
the above mentioned are the superkeys mam
ABCD should also be there
Your videos are really helping dull students,
Much love and support from mumbai ❤💯
Really excited to learn such new concepts from you.. Mam....
These are the only decent lectures available on DBMS.
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
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
Yes mam , We Need more Lectures on DBMS .You are Doing Fabulous Work Mam.
I have fast paced ones.
Thank you, your DBMS series and explanations are really good.
Thank you so much ma'am
You Presentation is like serving delicious food..😊👍🏻
you are an amazing teacher...
love from Hazaribag (Jharkhand)
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.
Mam your way of teaching is so awesome. 10M deserves ♥️♥️♥️
Love from Pakistan
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.
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% 👍
thank you very much!!!
is teaching your full time job??
{Name, Mark, Dept} can not be super key because one duplicate is present
but {Marks, Course, Dept} are uniquely identify each rows, hence it is a super key
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
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
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
Needed playlist on TOC..!! Srsly ur teaching style is just amazing... I Cleared DS and DAA in first attempt..!Thanks u sooo much ❤️ 😊
finally understood the difference between subsets and proper subsets, omg! I always confuse them! But now I won't anymore, thank you!
After watching a lots of videos,I visited one the best video.
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.
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 ......
kohli can
I cant say how much u helped to improve in me. Teaching is so clear cut continue this 👍✨
Great lecture Never see this level of content anywhere. We need teacher like you
Your lectures are AWESOME!!!
Thanks oswaal books for giving me the link of this wonderful channel ❤
Fully satisfied with this lecture.
This is wonderful explanation, I wish I had your lectures during my engineering time
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
Thank you so much mam your lecture is very clearly not any problems in your lectures. Thank you so much again 🙏
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.
Just woww...from where you are learning these mam?
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
Super Keys = A, D, AB, AC, DB, DC, AD, ABC, ABD, ACD, DBC, ABCD
Total 12 super Keys
Thank you, your lectures helped me a lot.
Thank you. It really helps me a lot.
ruclips.net/channel/UC5UCDqBotPtxQgfum4iGM2A
R{A, B, C, D} and given..
There will have 12 super keys :
i.e. {A, AB, AC, AD, ABC, ABD, ACD, ABCD, D, DB, DC, DBC} .
According to the formula 2^n-1 there should be 15 super keys??
Great job......your teaching skill is amazing
amazing work!!
Hii
Thank you mam for this course, this lectures helped me a lot
Thank You so much Ma'am for such great content...
Really loved ur way of teaching... ❣️ thank u mam...
Lots of love from kerala...❣️❣️❣️
Mam plzz upload vedio on SQL
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 ☺
14:21 short trick , calculate the number of subsets.
2^n-(1)here n is number of attributes.
Thats wht she said....
2^n - 2 we are not considering phi
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.
ad and abcd?
A and D are Candidate Keys. So, A and D must be SuperKeys too.
So, the superkeys are -> A, AB, AC, AD, ABC, ACD, D, BD, CD, BCD
Just to let you know, I am a 3rd year non-CS undergraduate student, and I am learning DBMS for the sake of my own interest. I have been following you since June and your lectures seem to be very useful in terms of Understanding Concepts. I have also subscribed your 2nd channel.
ABD too?
you left ABCD ,ABD
Thanx alot, got DBMS exam on 16th Dec, hope the topics will be covered till then.... u'r the best
Hi,
You said that if we want to find out max number of super keys which we can create on a table,then apply 2 (power n)-1. But in your example, there are 4 attributes i.e, A,B,C and D. If we apply same logic i.e, 2 (power n)-1, we will get 2(power 4)-1= 15. But you said that we can have 8 max number of super keys i.e A and A,C and A,B and A,D and A,B,C and A,B,C,D and A,B,D and A,C,D. It should be 15, as per your logic, but you got 8. Please explain clearly.
your correct brother even ihave same doubt.if u have dare someone clear us
if we have n attributes with one candidate key then no of possible super keys are 2 power(n-1) .so we got 8 super keys.But for a relation R having n attributes...no of super keys are 2 (power n) -1.
sampath kumar I think this is the reason
For finding maximum possible super keys in that given relation we'll use that formula, here just we need to find the total no. of keys present in the given relation.
in {a,b,c,d} a - candidate key
d- candidate key
and the super keys will be
a, ab, ac, ad, abc, abcd, d, da, db, dc, dab, dac
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?
Beautifully explained- Keep it up ! Never seen anyone explain so easily - very easy to understand ! THANK YOU !
Damn 💥 finally found some good stuffs in youtube !!
She explains very nice & she is very serious also.
yesss finally I understand Candidate Key tyyyyyyyyyyyyyyyyyyyyyyyyyyy
Mam you are definitely teach to better than other teachers of cs and it on RUclips so thankyou so much mam
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
U change the way of understanding computer thank you so much mam😊😊😊😊
Miss jenny,Can you please upload video about normalization in DBMS?i'm from sri lanka
Mam You are such a great teacher