Answer for exercise at 18:31 Number of candidate keys = 4 Set of candidate keys = { AB, CB , AD , CD } Prime attributes = { A, B, C, D } Thanks a lot ma'am !! 🤩🎊 This is one of the epic channels to learn DBMS !! Hats off !! 🙌
@@carishmakhan4694 r(a,b,c,d) ab->cd , d->b,c->a (prime attribute a,b,c,d)(if prime attribute is on the left arrow side, u can replace it with a new attribute) ck? abcd=(abcd) abd=(abcd) ab=(abcd) ->ck (c->a so cb is sk but not sure bout ck) cb=(abcd)-> ck (d->b so ad is sk but not sure bout ck) ad=(abcd) -> ck (ab->cd so cd is sk but not sure bout ck) cd=(abcd)-> ck
Thank you jenny for such awesome videos...The thing that separate u from rest of the teachers is that you explain every concept with an example...and I'm a person who looks to knowledge for acquiring skill and making something from that skill rather than to just pass exams ....Thank's a lot for making such informative videos
If this type of teacher will be available in India then all peoples will not have to learn like copy from book or Google then paste in exam nd also never forget any topics.... 😊 Thank you ma'm...
Absolutely Brilliant. There is no doubt you are the best instructor on RUclips. I have checked out quite a few videos but none have been able to explain this core concept as clearly as you have.
i dont know why u didnt start this series three month ago, coz i really wanted it in my last semester. I m from pakistan and i always watch your videos to clear concepts because u r much better than my lecturer ...... ->Brilliant teacher
How we got CD as candidate key: we are given that C-> A and D->B, now by the help of Composition rule CD -> AB, thus AB is replaced with CD. ** Composition Rule of Armstrong's Axioms.
Really Your Technique of Teaching is Awesome.Your Viodeos are Really Helpful and understandable. Thank you Mam. You Make My Understanding About Candidate Key.
Please add english subtitle so that we(people who not having a very good listening skill) can understand you completely , thanks for well explained video though.
@@SanjeevKumar-yt7sn I don't think it is sarcasm, if you are not used to one type of accent it can be difficult to understand sometimes. Anyway, awesome lectures
Miss please do all videos in English because as ure thinking the whole world should benefit from your videos. For example u had done diwali video in hindi. I couldn't understand dear mam
Explanation [Kindly correct If I'm wrong] @18:24 Ans. 4 - AB, CB, CD, AD 1. [ABCD]+ = {A,B,C,D} -> Super Key. But not candidate Key Using, C->A, D->B, We simplify 1 as [ABAB]+ which is nothing but [AB]+ Now, [AB]+ = {A,B,C,D} -> Super key. To check if [AB] is a candidate key, [A]+ = {A}, [B]+ = {B} which are not super keys. So, AB is a CK Also, Prime Attributes are {A,B} which is on the RHS of C->A and D->B. So, the next possible super keys which we have to check as candidate keys are Replace A with C, B with D and also AB with CD . Results are CB,CD,AD [CB]+ -> super key. [C]+ = {C,A}. [B]+ = {B} which are not super keys => CB is a candidate key. [CD]+ -> super key. [C]+ = {C,A}. [D]+ = {D,B} which are not super keys => CD is a candidate key. [AD]+ -> super key. [A]+ = {A}. [D]+ = {D,B} which are not super keys => AD is a candidate key.
Chehre pe tere sanam laila ki hain shokhiyan Heer se badhke hain aankhon ki yeh mastiyan Juliet ki tarah hothon pe hain surkhiyan Dekh le khud ko tu nazar se meri jaan-e-jaan Dekhi jo teri adaa main fidaa ho gaya Seene se lag ja zara jeene ka aaye maza Jeene ka aaye maza Yeh bikhri bikhri zulfein Yeh jhuki jhuki palkein Yeh gori gori baahein Hum kyun na tumhein chaahein Aisa to humne pehle dekha nahin kamaal Yeh kaali kaali aankhen Yeh gore gore gaal Yeh teekhi teekhi nazren Yeh hirni jaisi chaal
I can not decide how AD is candidate key. Actually by replacing derterminant it is clear AD is SK but i can not figure out how its closure is containg all the attribute. This is what i am doing Given FD: AB->CD, D->B, C->A from above given fd i have done this AB->C, AB->D, CD->AB, CD->A, CD->B, D->B AD->AB AD->A AD->B Using above given and calculated fd I could only idententify A, B, D attributes in the closure set of AD I want someone help me how AD is SK And rest i can figure out myself I apprepriate you invaluable help.
![Twenty One Pilots - “The Line” (from Arcane Season 2) [Official Music Video]](http://i.ytimg.com/vi/E2Rj2gQAyPA/mqdefault.jpg)
Stuying computer sience in germany and i gotta say this is the best playlist for DBMS
Answer for exercise at 18:31
Number of candidate keys = 4
Set of candidate keys = { AB, CB , AD , CD }
Prime attributes = { A, B, C, D }
Thanks a lot ma'am !! 🤩🎊
This is one of the epic channels to learn DBMS !! Hats off !! 🙌
can you explain it?
@@carishmakhan4694 r(a,b,c,d)
ab->cd , d->b,c->a (prime attribute a,b,c,d)(if prime attribute is on the left arrow side, u can replace it with a new attribute)
ck?
abcd=(abcd)
abd=(abcd)
ab=(abcd) ->ck
(c->a so cb is sk but not sure bout ck)
cb=(abcd)-> ck
(d->b so ad is sk but not sure bout ck)
ad=(abcd) -> ck
(ab->cd so cd is sk but not sure bout ck)
cd=(abcd)-> ck
@@dsadsa5447
How does ad->c?
what I know is that you can only determine c using ab by applying decomposition rule. a alone can not determine c.
@@manytuch i think, AD->B after that we can use AB->CD to get C
@@rishabhsharma3022
Sure, I figured that out after watching the next video. Thanks
These lectures have been filling in all the information that is missing in the text books. Thank you so much!
After watching several videos, not getting clear such concepts, but you make it so simple to understand. thank you so much.
Thank you jenny for such awesome videos...The thing that separate u from rest of the teachers is that you explain every concept with an example...and I'm a person who looks to knowledge for acquiring skill and making something from that skill rather than to just pass exams ....Thank's a lot for making such informative videos
The best course for competitive examination in Brazil cannot pass a subject at its level. Congratulations.
If this type of teacher will be available in India then all peoples will not have to learn like copy from book or Google then paste in exam nd also never forget any topics.... 😊 Thank you ma'm...
Exactly..
AM TITUS from Ghana i have been watching your videos on data structure which is really helpful to me .God bless you .Thank you.
Absolutely Brilliant. There is no doubt you are the best instructor on RUclips. I have checked out quite a few videos but none have been able to explain this core concept as clearly as you have.
somebody award this playlist!
i dont know why u didnt start this series three month ago, coz i really wanted it in my last semester. I m from pakistan and i always watch your videos to clear concepts because u r much better than my lecturer ...... ->Brilliant teacher
Prime attributes - A,B,C,D
Ck - AB,AD,CB,CD
I've came to the same solution. So, is this correct?
AB,CB,AD,BD
@@fitnessgurl1396 BD is not even a super key. 🤣🤣
how can you please explain
how bc is termed as candidate key
mine toh only three is there AB AD AC
How we got CD as candidate key:
we are given that C-> A and D->B, now by the help of Composition rule CD -> AB, thus AB is replaced with CD.
** Composition Rule of Armstrong's Axioms.
Your videos helped me in cracking GATE. Thank You so much mam.
Whats is GATE?
You are the teacher. I can understand very clearly of finding candidate key😻. Before I really confused of it.😭 Thank u so much my lovely teacher. ❤
After watching this video first time,
"Kitni awesome hain yaar.. "
🥰🥰🥰🥰🥰
Bhai thodi padhai bhi kar leta
Answer for last question to cross check!!
got AB,CB,CD,AD.
Yes
@@dineshtelangi3233 how AD?
@@essentialsATAesthetics D is determining B.... in place of B we can use D
got the same
All the lecture in English Just The word "Ayaa Button" :)
Very informational videos ever i seen :)
Thank you mam , you are such an inspiration for all of us who are preparing for GATE
I can't explain my word.. To say thank you.. But Thank you so much mem for your efforts to the students... 🙏💝❤
Candidate Keys are :AB,CD,AD,CD Prime Attributes are : A,B,C,D
Your teaching method is best and easy to understand you are really a genius. ❤❤❤
CANDIDATE KEY : AB,AD,BC,CD
PRIME ATTRIBUTE : A,B,C,D
How can AD be candidate key plz explain
@@manishpritmani same doubt
@@manishpritmani proper subset of AD are A and D ,whose closure are not superkey ,therefore it is candidate key.
Its remember my maths teacher. U give tough portion as assignment 😁
Candidate keys: 2 (CD, AB)
Prime attributes: 4 (C,D,A,B)
CANDIDATE KEYS : 3 (AB, AD,CB,CD)
PRIME ATTR. : 4 (A,B,C,D)
Yes i also got the same
Ans. Of hw question is
CK={AB, BC, AD, CD}
Prime Attributes are
A,B,C,D
AMAZING LECTURE ❤
@@mq4950 plz can u explain how?
My question is solved after watching this video 😊
Thank a lot . 4 candidate key . ck = {AB,ADBC,CD}
Plz bro explain how
your way of explanation is too good...MAM
simply amazing. better than my professor.
PRIME ATTRIBUTES- A,B,C,D
CANDIDATE KEYS- { AB, CB, CD }
why can't AD be a candidate key?
@@pittavivekreddy5022 ad also
@@155.p.vijayaraju5 actually i knew that, am actually questioning her, i intend to let her know the mistake she has done
@@vivekreddy7315 please tell how ad is candidate key
please can you give the clear explanation?
Normalise watching Jenny ma'am's lectures in 1.5x 😅
stop reading comments and focus on study........
hello bro....ans for questions asked by her will be seen in comment section .so that many will see comment section for that purpose.
@@tejaswigopaladasu7372 ok ok...
@@harshadlokare terer jaise hi jobless hote hein
@harshad lokare Stop commenting and focus xD...
Great video and excellent explanation! Thank you, J
Got it ma'am AB,CB,CD,AD
PA-A,B,C,D
Ck-4
AB,CD,AD,BC
PRIME ATTRIBUTES-{A,B,C,D}
Dhar
Hiii
How can you find
Really Your Technique of Teaching is Awesome.Your Viodeos are Really Helpful and understandable. Thank you Mam. You Make My Understanding About Candidate Key.
you are a lifesaver, thanks for making such wonderful videos,
Hi ...myself mtech graduate ,,, your classes are amazing
Thank you so much mam really superb video 💫👌
Super Explanation... Very Very Thankx Maam...👌👌
you have taught very well but it is very complex
Thanks for your technique on finding the candidate keys. It's very very reliable compared to what I was taught in class.
Answer for question at 18:31 :
Number of candidate keys = 4
Set of candidate keys = { AB, CB , AD , CD }
Prime attributes = { A, B, C, D }
4 CK:-{CD,AB,CB,AD}
Prime Attributes:-{A,B,C,D}
AD kaise aayega??
Bunch of thanks for the clear explanation🧡🧡
Please add english subtitle so that we(people who not having a very good listening skill) can understand you completely , thanks for well explained video though.
She's trying to teach in english,not her native language.so cooperate u moron.Instead of doing sarcasm....
@@SanjeevKumar-yt7sn I don't think it is sarcasm, if you are not used to one type of accent it can be difficult to understand sometimes. Anyway, awesome lectures
CK :- AB,AD,CB,CD Prime attribute :- (A,B,C,D).
Miss please do all videos in English because as ure thinking the whole world should benefit from your videos. For example u had done diwali video in hindi. I couldn't understand dear mam
maam u are great , i like ur all videos,ur lactures help me a lot. thanku a lot
thank u mam! u made this super easy
If I get three teachers personally 24×7, Code With Harry, Gate Smashers and Jenny
. I will crack Google surely.
Candidate Key :- AB, CB, CD, AD
Prime Attributes :- {A,B,C,D}
This answer I've got..
bhai answer bhejna
wtf this person is awesome thank u :)
The explanation is very clear and easy to understand. Thanks.
3 candidate keys AB,CD and AD all are prime attributes
BC will also be a candidate key
@@alphonseprakash7459 what BC can determine bro is it giving the whole relation then definitely it is if not it is not
BC also will give whole relation
@@viplovekadre9371 yes bro find CB closure u get CD and C->A and B->D hence CB-> CDAB which contains all keys
Really really such a wonderful video ma'am. Thanks a lot
I got AB, AD, CB, CD as candidate keys.
I got the same.
Yeah, I got these too.
I got these same
Explanation [Kindly correct If I'm wrong] @18:24
Ans. 4 - AB, CB, CD, AD
1. [ABCD]+ = {A,B,C,D} -> Super Key. But not candidate Key
Using, C->A, D->B, We simplify 1 as [ABAB]+ which is nothing but [AB]+
Now, [AB]+ = {A,B,C,D} -> Super key.
To check if [AB] is a candidate key,
[A]+ = {A}, [B]+ = {B} which are not super keys. So, AB is a CK
Also, Prime Attributes are {A,B} which is on the RHS of C->A and D->B.
So, the next possible super keys which we have to check as candidate keys are
Replace A with C, B with D and also AB with CD . Results are CB,CD,AD
[CB]+ -> super key. [C]+ = {C,A}. [B]+ = {B} which are not super keys => CB is a candidate key.
[CD]+ -> super key. [C]+ = {C,A}. [D]+ = {D,B} which are not super keys => CD is a candidate key.
[AD]+ -> super key. [A]+ = {A}. [D]+ = {D,B} which are not super keys => AD is a candidate key.
@@bense_tony nice work
Thank you ma'am 😊
Thank you very much mam, after watching so many videos, this found to be very informative
Candidate keys are {AB,AD,CB,CD}
Prime attributes are {A,B,C,D}
Very helpful, thank you very much
Amazing ma'am ☺️...i understand all the things... thank you so much ma'am ☺️🥳
U r best teacher thank u mam🙏
4 candidate keys possible- AB, CB, CD, AD
I think you're wrong there.
How can you find 'AD' please explain, I didn't understand this
Thank you very much ma'am . you are very kind . Thank you :)
Iss baar aap bhahut cute aur pyaari si lag rahi ho....aur explain to karti hi ho achha
AB, AD, BC, CD and all prime attributes
Can u pls tell me where u got that BC cuz I only have AB, AD, CD
@@altinarexha6134 CB from AB as C->A
@@altinarexha6134 I too got 3 composite keys ....I didn't get bc
@@anuragsoni1840 cd comes from c->a
Thanks mam
Allah ape ko buhat kamyabi day
thank you mam, clear concept :)
Much love from UTCN
Thank you MA'AM for such awesome video 🙌
Hi jenny, can you please make a short video explaining the answer of the last question for us? I just wanted to confirm the procedure. Thanks
Good one👌👌👌👌👌
You are a darling... Thank you so much!
3 candidate keys are present in my point of view
chaa
ck--CD,AB,CB
Chehre pe tere sanam laila ki hain shokhiyan
Heer se badhke hain aankhon ki yeh mastiyan
Juliet ki tarah hothon pe hain surkhiyan
Dekh le khud ko tu nazar se meri jaan-e-jaan
Dekhi jo teri adaa main fidaa ho gaya
Seene se lag ja zara jeene ka aaye maza
Jeene ka aaye maza
Yeh bikhri bikhri zulfein
Yeh jhuki jhuki palkein
Yeh gori gori baahein
Hum kyun na tumhein chaahein
Aisa to humne pehle dekha nahin kamaal
Yeh kaali kaali aankhen
Yeh gore gore gaal
Yeh teekhi teekhi nazren
Yeh hirni jaisi chaal
4 candidate keys are:{AB,AD,CB,CD}
Thank You Soo much mam
AV ,CB,DA,DC are the candidate keys :)
I can not decide how AD is candidate key. Actually by replacing derterminant it is clear AD is SK but i can not figure out how its closure is containg all the attribute.
This is what i am doing
Given FD: AB->CD, D->B, C->A
from above given fd i have done this
AB->C, AB->D, CD->AB, CD->A, CD->B,
D->B
AD->AB
AD->A
AD->B
Using above given and calculated fd I could only idententify A, B, D attributes in the closure set of AD
I want someone help me how AD is SK
And rest i can figure out myself
I apprepriate you invaluable help.
Thanku so much ma’am for these lectures 🙂
very helpfully video thank you mam
My favourite lectures and my favourite madam 😘😘 love you mam you are so beautiful but you didn't smile please smile mam 😅😅😅😝😬 👍👍👍
Mam could you please upload some videos related with database query . It will also be really helpful.
Thank You Mam❤!
Please numbered each video with1 2 and 3 in play list it will become more organise .
thanks for uploading candidate key .............
Thanku maam 😘
Thanks for this mam !!
I know this concept well. even then I am watching it because of you only mam...
I got CD, AB, AD & CB as candidate keys.
Same brother what about the answer is this right or wrong
we can get only 3 candidates keys how we can get 4
Jenny Mam....Really u r awesome to explain complex concept in understandable way....Really thanks to u.....
Nice video mam always give proper solutions
candidate keys: AB,BC,CD, AD
AB => A+ -> {A } , B+ -> {B }
BC => B+ -> { B} , C+ -> {C,A }
CD => C+ -> { C,A} , D+ -> { D,B}
AD => A+ -> { A} , D+ -> { D,B}
how cd beocmes ad?
Thank you
AB, AD, CB, CD are Primary key and also Candidate key
Prime attributes are {A,B,C,D}
Please explain how you got candidate key
I got only two candidate key
Candidate key is a key whose subset is not a super key
Like in AB
Subset is {A,B}
Here A+ ≠ All attributes
Or
B+ ≠ All attributes
So A or B is not super key
Last Q ans : AB, BC, CD, AD
Hi mam.. as a kind request... Pls make some videos on python programming language....