@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.
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
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.
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...
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.
@@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.
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.❤️
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!
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
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.
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 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 !!!
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
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% 👍
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
{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
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 ......
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.
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.
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.
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.
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.
![[#2024MAMA] G-DRAGON - 무제(Untitled, 2014)+POWER+HOME SWEET HOME+뱅뱅뱅+FANTASTIC BABY | Mnet 241123 방송](http://i.ytimg.com/vi/Ox29z5Nf1Uk/mqdefault.jpg)
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
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
You're much better even 100x than mine university teachers. Thanks Ma'am
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.
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...
Thank you from the United States! You are an amazing professor. Very grateful for your Python, database, and data structures content.
0:34 dd
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 ❣️❣️❣️
From my college teachers to RUclips and then Nptel, no one could explain it
You really are best teacher
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💗💖
You make my life... Till now I always got confused in KEYS... now all clear in mind... Great explanation...👏👏👌👌
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........
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
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.
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.❤️
I like ur teaching style more attractive..thanks alot
Explanation is so good that I can easily understand at 1.25x too
2x here
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!
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.
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.
Mam super .two year I don't know this concept.now I have. Very clear.
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
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?
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
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 !!!
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
Your explanation is simply superb ma'am not only DBMS Im following your OS videos also
Ma'am your making complex concepts into simple concepts really helpful and thank you so much ma'am.
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% 👍
Alot of thanks to you mam.
Even hindi videos are much difficult to understand but I found yours video very helpful only.
Mam your way of teaching is so awesome. 10M deserves ♥️♥️♥️
Love from Pakistan
Very much enlightening! I did understand DBMS keys practically but still confuse in the theory. A thousand thanks to you from Indonesia! :)
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
Super explanation..I think trainers like u are raree♥️
{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
It's not just a key; it's a super explanation.
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
Thank you so much ma'am
You Presentation is like serving delicious food..😊👍🏻
Thank you so much mam your lecture is very clearly not any problems in your lectures. Thank you so much again 🙏
Your videos saved my life this semester! Thank you Jenny!
Needed playlist on TOC..!! Srsly ur teaching style is just amazing... I Cleared DS and DAA in first attempt..!Thanks u sooo much ❤️ 😊
If u are my teacher my attendance will be 100% and I learn full subject from u
What a productive Saturday. Thank you, hugs from Brazil
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.
These are the only decent lectures available on DBMS.
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
After watching a lots of videos,I visited one the best video.
Your videos are really helping dull students,
Much love and support from mumbai ❤💯
She explains very nice & she is very serious also.
A,D,AB,AC,AD,CD,BD,BCD,ABC,ACD,ABD
the above mentioned are the superkeys mam
ABCD should also be there
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.
Really excited to learn such new concepts from you.. Mam....
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 ☺
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
This is wonderful explanation, I wish I had your lectures during my engineering time
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.
Great lecture Never see this level of content anywhere. We need teacher like you
Yes mam , We Need more Lectures on DBMS .You are Doing Fabulous Work Mam.
I have fast paced ones.
you are an amazing teacher...
love from Hazaribag (Jharkhand)
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??
[name, marks, dept] is a superkey
[marks, course, dept]is also a super
I understood the concept clearly thank mam
finally understood the difference between subsets and proper subsets, omg! I always confuse them! But now I won't anymore, thank you!
U change the way of understanding computer thank you so much mam😊😊😊😊
Fully satisfied with this lecture.
Thanx alot, got DBMS exam on 16th Dec, hope the topics will be covered till then.... u'r the best
I cant say how much u helped to improve in me. Teaching is so clear cut continue this 👍✨
Mam you are definitely teach to better than other teachers of cs and it on RUclips so thankyou so much mam
Your lectures are AWESOME!!!
Mam, you teaching and content is excellent, no comparison, it's unique
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
There are 10 super keys for the relation {A,B,C,D} having A &D as Candidate keys.
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 really find your lectures effective, every time I watch. Much credits to you mam. 👍
Thank You so much Ma'am for such great content...
I finished my struggle of understanding keys after this video...great explanation ma'am
... Thank you for your efforts 😊
Mam plzz upload vedio on SQL
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
Thank you, your lectures helped me a lot.
you are a wonderful teacher and you have made my learning easy.God bless you
so much
thank you very much!!!
is teaching your full time job??
Thanks oswaal books for giving me the link of this wonderful channel ❤
tomorrow is my DSA paper and here i am studying DBMS at 5 AM
Super mam in easy way u understand the concepts with no confusion thank 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
Mam You are such a great teacher
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
Mam, superb teaching with a wonderful explanation skills, thank u keep teaching
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
You are super key to every student
yesss finally I understand Candidate Key tyyyyyyyyyyyyyyyyyyyyyyyyyyy
Great job......your teaching skill is amazing
Ans. Is 11 for sk of A,B,C,D
12 key s bro
@@SanDBeast_SDB how. Can you pls explain
@@godasriaddanki9782 a,d,ad,ab,ac,cd,bd,abc,bcd,acd,abd,abcd which is 12 bro
@@avinabg1511 tq bro
Best clarity of concept ever
amazing work!!
Hii
Thank you madam your teaching was too good than our university lecturers