Database Design 23 - Superkey and Candidate Key

So. Many. Ads.

This was very useful buddy! Keep it up!!

Thank you

".....shame on you." LOL

My graduate school professor couldn't explain this. Thank you for helping me understand what is actually a pretty simple concept. - New subscriber

"If you have twins and named them the same thing SHAME ON YOU" lmaoo

simple, clear and very helpful. thanks

Annoying ads throw me out every single time. This is so bad for learning.

this series will help me a lot getting my exam cleared tomorrow. thanks

Fave teacher ever!

this video DID NOT need to be 19 minutes long caleb...

Your example is much much much much much much... better than my notes given by school's lectures.

get a fucking white board

Text book wasting my time, trying to tell me these concepts but they made it long and it is confusing. I just say Thank you. I was upset and now I am laughing .

I thought you did a pretty good job of explaining. Helped me out, so keep up the good work, and don't worry about the length of the video. You could always add bookmarks in a long video to allow viewers to quickly scrub ton the info they are looking for. Thanks for doing this.

can i buy you a whiteboard

Chef Curry 👍🏿👍🏿

Young, Smart, Funny, finally I got what is candidate key :) the video is 5 years old, but, anyway, thx for fun, and Very good explanation.

You explained better than my professor. Nice job! You earned a new subscriber.

19 minutes and 14 seconds? Time to use 1.5x playback speed

thank for your joke

real helpful man !!

Great work! Your video helped me understand DB a little more.

so are superkeys and andidate key a form compostie key?

Keys are the Key to succes LOL

you explained this better than my professor. great job!

you did not know how to explain what you understood. you talked about many topics

I just realized you're left handed

Happy Birthday!

Great video, time is great because your explaining it. Thanks.

Who else is thinking he looks a lot like Dylan from Modern Family?

Now I understand.

يابني ابلع ريقك

much more clear than my professor :p

Thanks Caleb, Learning a lot form your video.keep up the good job.

I think George Foreman named all of his sons George. I don't know if any of them were twins.

I am not sure what your background is, but if you are not an professional educator in some capacity, the world is missing out! I am a 45 yr old college junior majoring in CIT and if it was not for your videos I would be failing Database Systems!!! Thank you Caleb!!!!

''so nice your lecture but some times you make littlebit fun is awesome thank you for representing ''

Will email you :

1) Elmasri Navathe - Fundamentals Of Database Systems (BOOK on DBMS)
2) Important Exams oriented PDFs
3) Few Other PPT Presentations

This will be highly useful for all, who want do self study easily.

This will cost Rs. 20 only through PayTM on +91 9429801543 (Whatsapp me your email address on the same)

Regards,
AM

In the vid you said that the candidate key is the least # of columns that force every row to be unique. So why would you refer the composite key (first name, last name, address, birthday,..) as a CK even though the number of columns it includes is greater than one ( the username only needs one column)?

Cringy but understandable. .-.

Thank you, you're videos are a great help!

candidate key can be a super key or not or vice versa?

thanks a lot!!