Finding Candidate Key | Database Management System

Step by step guideline to proceed with finding candidate key. To ask your doubts on this topic and much more, click on this Direct Link: www.techtud.com/video-lecture/...
IMPORTANT LINKS:
1) Official Website: www.techtud.com/
2) Virtual GATE: virtualgate.in/login/index.php
Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share!
Our Social Media Links:
Facebook Page: / techtuduniversity
Facebook Group: / virtualgate
Google+ Page: plus.google.com/+techtud/posts
Last but not the least, SUBSCRIBE our CZcams channel to stay updated about the regularly uploaded new videos.

[@groomyClaimbodog]

When the random Indian teacher save you from final exam.

[@kat_enj]

My indian king

[@groomyClaimbodog]

@@kat_enj Yo he literally saved me. I passed the exam and now I already graduated. Thanks to this Indian Man.

[@kat_enj]

@@groomyClaimbodog i failed my exam from dmbs today :(( I missed one point. But still have 2 more attempts

[@groomyClaimbodog]

@@kat_enj oh no I gotchu bro. You still got 2 more attempts. Keep working bro.

[@Chumbuket]

@@kat_enjdid you pass?

[@TugasPT]

Dude I was about going to give up and get sleep, until I clicked this video as "last chance" and you explained in 4 minutes, thank you!

[@SaNdR0RM46]

Portugal crlh

[@FuriaKKK]

@@SaNdR0RM46 Portugal fds

[@leonelmessi3010]

did you pass the exam 4 years ago?

[@meetchovatiya5548]

@@leonelmessi3010 lollll

[@oricardoaragao]

@@SaNdR0RM46 calou

[@Frincles]

simple and well explained, thank you my man!

[@WaspHotel]

45 minute lecture solved in 3 minutes. You're getting a like from me

[@nox9079]

me too

[@bysh.babyyy]

when an indian dude explains in 4 minutes what a teacher couldn't do in hours

[@demolition_lovers]

This is the spirit of the internet.

[@AMEHZ1]

I know right.

[@AVEnhance]

Beacuse in class many number of students

[@novagames5719]

This video is from 2014 and we are here in 2023

[@hghchaito3972]

I had no idea about the subject and the exam was next day
That clear it much thanks man

[@mr.mustache4743]

Thank you for making this soo accessible amazing! Great example, thank you so much!

[@adriancollier4681]

Absolute legend just saved me after I couldn't understand my professor 1 hour lecture on this

[@SivaneshFiz]

Thanks a lot. I was confused during my lecture hours. but u made it easy ...

[@HumaRizwan]

I subscribed man....You saved my DAY
KEEP UP THE GOOD WORK!

[@shortsdeliveries]

thank you for your straight to the point explanation

[@MisterAki069]

omg thank you bro I like ur accent stay healthy bra, when you read this 5 years ago maybe I ll have my bachelor and will comment again see yaaaaaa

[@hotchaddi]

we are all waiting lol

[@1tz_dev]

Alright, now update us.

[@oliverthomas700]

Thanks for saving my weekend in 4 minutes!

[@sherl6ck168]

This is the video that I was looking for. I got it now.

[@cdefghia]

Fantastic explanation, you helped me a lot. Thanks!

[@VictoriaSyms]

Thank you, great video!

[@omarsh5269]

Thanks you are great , you helped me a lot

[@habib97se]

thank you so much for this video. You're the best.

[@madmaxonliner]

WOW. Thank you so much!

[@GG_Booboo]

Great explanation!!! Thank you!!!

[@swethakalidoss6578]

Thks a lot bro...cool lecture..i like it

[@miracles_makers3668]

God bless u for this excellent video

[@bradn1030]

you are a hero to the masses

[@a7madfriends]

Thank you so much .. you make it clear for me :D

[@mehyeddinahmad411]

ههههههههه يا ... شنو هذا

[@abhisheksuper20]

Awesome explanation

[@afg229]

I have an instance where one of the attributes from the candidate key showed up on the right side but it was proven to be a candidate key because the closure contained all of the attributes.

[@Astronomy.532lifenspace]

How do you go on finding other candidate keys on such scenario. Do you add another attribute to make them three or you only work with 2 in case you don't get to the answer on the first attempt

[@witnessmbadame3163]

Great content brother ......

[@madhavanmariappan3768]

Well done! Mate

[@hoangvietng7100]

You bless god, my Indian bro !!!

[@trupatikadbe4719]

Thank you sir , for best explanation ....

[@trupatikadbe4719]

It is very helpful for me... Best video

[@usharani1464]

Thank you sir. It helped me alot

[@AkashVermaNITian]

How should we find "all" candidate keys of R i.e. not stopping after finding just the first one i.e. when should we be satisfied that... "yes! there can NOT be any more candidate keys in this relation"

[@vickysharma9227]

Thanks for the great explaination

[@user-yj6kn6nf8g]

Thank you sooooooo much king

[@chantel2689]

So helpful thank you!!!! :)

[@koyavasudhalakshmi2073]

Very nice explanation 👌👌👌👌

[@visheshmehta5543]

What about DCA? Would it be a candidate key?

[@sunoharachan3820]

If all the attributes appear on the left, do we just choose a random attribute and perform a closure on it?

[@armcska582]

What he said is that you should look at the right hand side and check if there are missing attributes. If they are then the closure of those attributes is a kandidate key. If all the attributes are present in the left side then there may be is more than one key ?

[@raihanrifat8371]

Thank you sir

[@42vi-dsreekamaleshrm30]

Tq.
Clear explanation

[@hasarangawijesinghe5604]

Thanks man

[@muhammadshehzar8424]

what if all the attributes are also present on the right hand side? then what?

[@laithaj149]

thank you !

[@user-yy6sd5nn7c]

Thank you!

[@daixtr]

thank you nice tutorial. Can you please explain, why bother to combine columns to create keys when it is much quick to add another auto-increment column that also guarantees uniqueness?

[@GertdeWilde]

It could take too much space to add a seperate column for that, space vs time is always an issue

[@daixtr]

isn't it slower to combine two columns together (if both columns are string type) rather than a dedicated integer atomic native type?

[@GertdeWilde]

Dexter Aparicio
I think the dedicated integer is always faster, especially when indexed, but it costs more space (although little). Each DB manager/creator should consider the pros/cons of both options for each application.

[@arpitaghosh1426]

Thnx a lot

[@myway063]

thank you

[@aishwaryaranghar3385]

Short and best 🤩🤩🤩🤩

[@Chess_Enthusiast]

But AE is not akey?

[@sumansoni4249]

supeup thoughts

[@Raj-yj6fk]

what is simple candidate key. plz tell

[@shivamshah6579]

what if the set containing AE (proposed candidate key) does't determine all the other attribute?? shoud we still call it a candidate key?

[@vikasparmar6234]

so in that case we can't call it candidate key.... :P

[@sachiintha]

Thanks!!

[@hasarangawijesinghe5604]

you too bruhh

[@sachiintha]

😂💔

[@santhoshbahadurpaudel2788]

What if we have all the attribute in the right side??

[@AK-cy3ql]

find all possible candidate keys right? then is only one possible ? what about others

[@tasnimpatel5597]

I jst got ma mind fitting concept while kst going to give up thank you 😊

[@MOM777100]

prefecto

[@sanathkumar8491]

is candidate key is primary key..?

[@ADC3131]

what would happen if every attribute appears on the right hand side

[@daniealdecobray3774]

Super bro

[@TheGanner1]

holy shit thank you very much you are saving my ass

[@RAFIAhmed-qy4eq]

When the ride side will have all the elemants in a relation how can we then calculate candidate key

[@addymace4264]

wondering this aswell...

[@zu6166]

Nah mate I actually love you

[@arbaazm3761]

Wowwww

[@IntellectX12]

Why you people are not using an example of table

[@avkaranklair1353]

🐐

[@markusd6139]

Anyone know?
Find D' if D = (F' + G H)E

[@GoatMen]

So hard to understand accent.

[@aashishthedevilboy]

Find the closure and candidate key of this R(l,m,n,o,p) L->mn, NO->p, m->o, p->l

[@Judderplush]

detur mind

[@sujalutekar9417]

faltu

[@pranavarora6693]

Wrong information provided instead of fixed deposit he is saying functional dependency
Report him
Also he is not aware of alphabetical order

[@berkayklc1613]

thank you

[@dumsinghsolanki9796]

thankyou so much sir

[@pinjuhsaikia3821]

Thanks sir