KEYS IN DBMS | Difference between composite and candidate key

This video will explain 5 keys in dbms
1. Super key
2. Candidate key
3. Primary key
4. Secondary key
5. Composite key
Knowing keys in dbms is very important as it is a very common interview question.
Please subscribe to my channel if you liked the video.
Thank you!
✨Work related mails can be sent on:
[e-mail]
✨If you appreciate my work and would like to donate to support our channel, you can do so here:
paypal.me/sadia1702

[@crackconcepts]

✨Link to my SQL e-book: imojo.in/rkajq9
✨Link to 'Switch your career easily' e-book: imojo.in/1FL7KaG
(Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)

[@kiranachanta9741]

Foreign Key is mapped to Primary Key of Parent table. FK is not a PK and it can have duplicate values as well.

[@zishanafzal6671]

the best thing about your videos is that it is very short and comparatively much informative than others.

[@HarjotSingh-eq6jq]

Phone number also will be same for two students if both are siblings. Hence, we can not consider phone number as a Primary Key or Unique Key.

[@vasimuddinsheikh3766]

Ask students to bring different number of Mom and Dad if siblings

[@theengineerguy_]

@@vasimuddinsheikh3766 Gareeb bacche hain 2 phone Kaha se layenge😂

[@parichaybhatt46]

Great job. Thanks for the easy to understand explanation 🧡🤝

[@raj-lu6sm]

excellent video with good example....struggle to get this on internet and finally got here

[@ezzati8235]

Thank your for the explanations very helpful 💛💛

[@designers_rockwall]

nicely explained in short time. REALLY APPRICIATE YOUR WORK👍🏻

[@Mayankkumar-eh8yb]

HIghly appreciate your work.....great!

[@CelebrateWithVani]

Thank you mam for sharing the video's. it's helping alot of students throughout the world! Keep going😊🙏

[@sathyasathyam6930]

Really awsome

[@hishamkv8118]

Helpful explanation

[@amanbhargava2702]

Thanks😊

[@surajsingh-sm7qx]

Hey mam what is the difference between the composite key and super key?

[@hardikjaggi700]

Thanks for such content. I think we missed Surrogate key.

[@sayanthankathirkamanathan8699]

thanks. help me a lot. mam plz make other videos on DBMS.

[@adss5095]

Thanks fot the nice class,😊

[@pannagabm2100]

Thank you🙏

[@mujahithhilalmml1577]

Thank you

[@vijaytorani9631]

Mam should we also contain phone no in super key?

[@irocksify]

Nice.
Please make video on SQL constraints with example.

[@crackconcepts]

Yes. Very soon

[@SHASHANKRUSTAGII]

What was your GATE rank?

[@stormroxx3487]

THANK U QUEEN'

[@aravindas2591]

thanks

[@naveenshagala3136]

Concepts are crystal clear. Even I used to get confused with candidate key and composite key. but now it's clear. Mam please make videos on normalisation concept.

[@crackconcepts]

Yes, I will surely make. Thanks a lot!

[@Bestclipz007]

Very easy way of understanding of sql for beginners like me🤗. Wishing for much more video like this.
Love from mangalore❤

[@funnydonkiran3884]

Voice ❤️

[@urvishfree0571]

I know it's been long time but does anyone have notes. And mam if you have bandwidth can you just combine all your SQL pages and give the pdf notes it would be very much helpful to us.

[@thecodebehavior]

help me alot . mam plz make other videos on dbms.

[@crackconcepts]

Glad it helped you. Will definitely make more videos.

[@dildokafir5058]

Correction: alternate/secondary key are those key which are left from candidates keys that qualifies to primary key.
Ex- students id & phone no. are candidates keys and students id is chosen as primary key, therefore the key which is left i.e phone number is alternative /secondary key.

[@simay9773]

Sunil Kumar yeah i was thinking the same

[@ajims9093]

Thanks

[@deewan2588]

Mass bro

[@CelebrateWithVani]

Thank you for sharing the answer! It's helping many students like me! God bless you😊🙌

[@ritihajagadesh4629]

This is was the shortest and best explaining video..

[@aloneajay6393]

Sweet

[@chilly2171]

why is phone not part of the super key?

[@__________________________6910]

my understand level currently 100%

[@vyshnavib8023]

Mam Is superkey is same as composite key..both of them same or not mam.. reply mam

[@sasidhar143]

i too have the same doubt vaishnavi...

[@aaoKahaniDalien]

Salaam! can you please provide me the video capturing method? i need it actually how you maintain and made it....! thanks❤

[@sharabhkochar779]

this is very helpful, can you please convert your notes into .pdf and share them to us?

[@vikasgrajzz]

I want to buy that e book

[@vikasgrajzz]

Tell me how 9560421042

[@surajprajapat4639]

Mem plzz implement all the keys in practical

[@surajprajapat4639]

Mem plzz make a vedio fast to implement keys in details with cammond s

[@sameerpandey5561]

Candidate key’s attributes can contain NULL value which oppose to the primary key

[@arundhatisharma6367]

Nope

[@Urstrulypnr]

Yes candidate key can be null

[@debatenepal9417]

Best and shortest 💕💕💕

[@abhishekyadav7832]

How can student name be a super key? Any two students might have the same name.

[@tushardeepsingh4976]

Surrogate key ?

[@sarojsahoo8763]

Where in Unique Key concept

[@sandeepgaming4004]

R

[@abhisheksaurav]

Your videos are helping me a lot. Thanks.
Feedback: Please try to speak bit louder or use a mic which can catch your voice. Phone's microphone is suppressing your voice.