Keys in RDBMS

DBMS: Keys in RDBMS
Topics discussed:
1. Explanation about the need for having keys in tables.
2. Various keys involved in DBMS.
3. Super key with example.
4. Candidate key with example.
5. Primary key with example.
6. Alternate key with example.
7. Unique key with example.
8. Foreign key with example.

Music:
Axol x Alex Skrindo - You [NCS Release]

#DBMSByNeso #DBMS #KeysInDBMS

[anjaligupta]

1000 times better explanation than our college teachers.. 👍

[ragapriyakarthikeyan]

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

[Hey_Haroon]

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

[danielsims]

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

[robertbehrens]

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

[rdrsxlb]

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

[aakankshakhawase]

Thank you for the explanation. Your explanation really helped in clearing the concepts regarding the keys.👍Great work!

[rayaneziadeh]

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

[kawizekambowa]

It is not that difficult, it was just clarity i needed. Thank you

[Torchbearer]

Thank you for giving the knowledge about DBMS Keys ❤

[bltmsuc]

really! understood very clearly, mainly this session has been too engaging without lag.

[KathirNatarajan-wknc]

Very very clear, really useful, wonderful explanation.great mentor u r sir, pls put more videos regarding dbms sir 🙏🙏🙏

[rocklee]

one thing i would like to add is that...
(name + phone) cannot be a candidate key because they can have null values and the primary motive of candidate key is to uniquely identify a tuple. (name + phone) cannot be a primary key as well because primary key can't have null values.

[yusefiguess]

Thank you very much for the video. I have a question, why are we picking {Name, phone} and {email} as candidate keys instead of {Name, email} and {Phone}?

[sanjeebamat]

Great lacture thank you for making such wonderful video .

[Saha-hy]

Fantastic... Teaching..Great Sir Thank you sir

[funkiel-nowka]

@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? 🤔🤔🤔

[hscodingdairies]

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

[shresth_bhakta]

Thanks NESO academy for this! Indeed and infromative video !

[Getagrip]

In a candidate key what if one attribute values are not unique and other attributecan have a null value, How can we identify it...For example there are 3 john in the table and if two have no phone numbers then how can we identify the specific tuple