Keys in RDBMS

100/10 ❤

Is it possible for a unique and composite key to be something other than a candidate key?

Let's assume a airplane reservation system. What can be a primary key? Flight Number or Flight Number+Date

Well understood, Thanks❤

great teacher😊

Thank You

Can someone please explain what is a unique key because it seemed same as alternate keys

Oh my goodness. You explained the complex Lecture to a lay_man's view. I subscribed right away. Sending love from Zambia

The session is too engaging ,Sir. Got cleared with all the concepts🙂.Thankyou sir

Such a great teacher with clean and clear explanation! thank you!

Nice explanation 💥💥💯

You can add one thing here that is unique key allow only one null value....not more than one

2.4 mil oof

Thanks bro

nandri thale

super key is like super set.but actually it is power set of keys

Thanks NESO academy for this! Indeed and infromative video !

can a candidate key have null values?pls anyone reply

Thank you !

I m from non tech background and this topics comes in my Mba course and you explain it very smoothly. thank you !

Who’ll say composite key? Me?

Simple and effective explanation. Thank you

thank you i learnt alot from your work
😃😃😃😃😃😃

thank you for speaking clearly, finally found a video in which i can understand what its said

@nesoacademy, are you sure that (Name, Phone) can be super key and candidate key?
In "super key" part you've mentioned that you can not force an employee to have a phone number, so it can be null.
What if we have in DB three employees named John without assigned phone number? 🤔🤔🤔

you explained it 10/10, thank you so much!

Thankyou sir ❤❤❤❤😊😊😊

(Name, email) what if the email is Null but the name alone cannot identify uniquely a tuple? In my opinion in this case it cannot be a superkey

So, super key is set of all possible combinations of attributes that can uniquely identify tuples. Is it right?

Beautifully explained, thank you!

Where is the tutorial of Normalization? I need it right now hehe, were done at keys in rdbms

why is salary on the table if you dont make use of it? Why is it not an alternate key?

Thanks man

Great lacture thank you for making such wonderful video .

Which one was the foreign key ??? Dept. Code or any other ??

Unique key can b id or ssn right.. how come name, phone will be unique key

If one name is repeated twice and both the rows have null as their phone number then how will {name, phone} be a super key?

Thanks

Thank you so much!

Precise And to the point.Well done 👍

Thank you sir for nice explanation ❤️

Thank you sir 😊

Nicely explained , Thnxx alot 💙

Thank you so much sir 😃😃👌