Lec 7: How to Find Number of Candidate Keys in a Relation - part 1 | DBMS Tutorials

In this lecture, I have discussed a Simple Trick to Find Out all Candidate Keys in a Relation.

*******************************************

Connect & Contact Me:

*********************************************

More Playlists:

#dbms #dbmstutorials #normalization #jennyslectures #losslessjoin
#howtofindcandidatekeyinarelation
#candidatekey
#DBMS
#ugcnetcomputerscience
#jennylectures

[samsons]

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 !! 🙌

[SkyJunkie]

These lectures have been filling in all the information that is missing in the text books. Thank you so much!

[jubinsoni]

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

[parikhmansi]

After watching several videos, not getting clear such concepts, but you make it so simple to understand. thank you so much.

[theuniverse]

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...

[titusjapan]

AM TITUS from Ghana i have been watching your videos on data structure which is really helpful to me .God bless you .Thank you.

[raheemasghar]

Absolutely Brilliant. There is no doubt you are the best instructor on YouTube. I have checked out quite a few videos but none have been able to explain this core concept as clearly as you have.

[muhammadshahzaib]

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

[zuhairbilal]

Answer for last question to cross check!!
got AB, CB, CD, AD.

[shivateja]

Your videos helped me in cracking GATE. Thank You so much mam.

[clebsonmachado]

The best course for competitive examination in Brazil cannot pass a subject at its level. Congratulations.

[suvankar]

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.

[supriyosaha]

😍 Mam, I got Ck{ AB, CD, AB, CB } as the Candidate keys

[Sok_Masterly]

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. ❤

[knowledge_withkanha]

I can't explain my word.. To say thank you.. But Thank you so much mem for your efforts to the students... 🙏💝❤

[namratapatil]

Prime attributes - A, B, C, D
Ck - AB, AD, CB, CD

[jaishreeramjaanki]

After watching this video first time,
"Kitni awesome hain yaar.. "
🥰🥰🥰🥰🥰

[unnayan_sharma]

Thank you mam, you are such an inspiration for all of us who are preparing for GATE

[videosforfun]

All the lecture in English Just The word "Ayaa Button" :)
Very informational videos ever i seen :)

[MunoBhaiSialkoti]

Your teaching method is best and easy to understand you are really a genius. ❤❤❤