KEYS IN DBMS | Difference between composite and candidate key
Вставка
- Опубліковано 21 чер 2019
- 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:
work.sadiasiddiqui@gmail.com
✨If you appreciate my work and would like to donate to support our channel, you can do so here:
paypal.me/sadia1702
✨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)
Foreign Key is mapped to Primary Key of Parent table. FK is not a PK and it can have duplicate values as well.
the best thing about your videos is that it is very short and comparatively much informative than others.
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.
Ask students to bring different number of Mom and Dad if siblings
@@vasimuddinsheikh3766 Gareeb bacche hain 2 phone Kaha se layenge😂
nicely explained in short time. REALLY APPRICIATE YOUR WORK👍🏻
excellent video with good example....struggle to get this on internet and finally got here
Great job. Thanks for the easy to understand explanation 🧡🤝
Thank your for the explanations very helpful 💛💛
Thank you mam for sharing the video's. it's helping alot of students throughout the world! Keep going😊🙏
HIghly appreciate your work.....great!
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.
Sunil Kumar yeah i was thinking the same
Thanks
Mass bro
Thank you for sharing the answer! It's helping many students like me! God bless you😊🙌
Thanks for such content. I think we missed Surrogate key.
thanks. help me a lot. mam plz make other videos on DBMS.
Nice.
Please make video on SQL constraints with example.
Yes. Very soon
Very easy way of understanding of sql for beginners like me🤗. Wishing for much more video like this.
Love from mangalore❤
Helpful explanation
Hey mam what is the difference between the composite key and super key?
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.
Yes, I will surely make. Thanks a lot!
Really awsome
Mam should we also contain phone no in super key?
This is was the shortest and best explaining video..
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.
help me alot . mam plz make other videos on dbms.
Glad it helped you. Will definitely make more videos.
Thanks fot the nice class,😊
Voice ❤️
Thanks😊
Thank you🙏
What was your GATE rank?
my understand level currently 100%
Thank you
THANK U QUEEN'
thanks
Candidate key’s attributes can contain NULL value which oppose to the primary key
Nope
Yes candidate key can be null
Sweet
Mem plzz implement all the keys in practical
Mem plzz make a vedio fast to implement keys in details with cammond s
Best and shortest 💕💕💕
this is very helpful, can you please convert your notes into .pdf and share them to us?
I want to buy that e book
Tell me how 9560421042
Mam Is superkey is same as composite key..both of them same or not mam.. reply mam
i too have the same doubt vaishnavi...
why is phone not part of the super key?
How can student name be a super key? Any two students might have the same name.
Salaam! can you please provide me the video capturing method? i need it actually how you maintain and made it....! thanks❤
Where in Unique Key concept
Surrogate key ?
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.
R