super key in dbms

[@abdullahalamil4276]

I really don’t know how to thank you. Your explanation is amazing and easy to understand. Thank you 🙏🏼

[@codestudy2035]

great, wasted hours searching in google and tried to read and understand. This video cleared my doubt in 3minutes. thank you

[@kecojune6857]

same

[@beastking143]

Nice joke 🤣🤣😂

[@rohitgore1792]

Ia m a professional and studying for my degree... Tue concepts that u have explained are clear and crisp you are awesome mam... Thank you so much 😊😊

[@alhassandumbuya3601]

Thanks you very much you lectures are easy to understand.

[@sushantbhatia9930]

madam apne jo table ke sath samjaya usse super key clear hua thanku madam

[@danielthapamagar2179]

your examples helps to understand easily, thanks ...

[@apekshakhandare55]

First time I understand all the concept about keys like primary key, candidate key, foreign key, etc.thanx

[@markafetorgbor7603]

Your explanation is very very superb and understandable. Thanks for the great work

[@piyushverma7280]

mam your explanation is excellent and understandable. If you can provide those notes it is also good Thanks mam

[@vinaykumaryadav2974]

I have seen all your videos, you tell or explain very well.

[@adarshcs6018]

Phn no. Can not be a Primarykey...because two students from a same home May have same phn no.......usually keys are not set In ph no.s

[@Paradise-kv7fn]

she wrote all mobile numbers which will be unique to each student...so in a way she is correct...the column name should've been "mobile no." though

[@nikhilparab1815]

Id no or roll no can be a primary key and phone no can be super key

[@veerachegu]

Madem i am Electrical background just i saw ur videos dbms nice explanation never will explain like u thkyou so much

[@galamdilliganesh5025]

Thank you mam for the knowledge

[@KULDEEPSINGH-em3nd]

well, at last i came through minimum investment video filmed with. best of luck mam

[@clashclans9783]

thank you so much for the explanation, my professor made it harder to understand this.

[@baranhamoglu4072]

I assume that we can take (age,name) as a super key in this specific example...

[@blogsbarrel4734]

Hey why only three ? , we can choose as many to find records ? ex: (stid , name) , (stid , phone) (st id , age), (name , phone) (phone, age) +++++ are all these examples of super key ? , plz explain it to me if im wrong

[@VJY90]

Am really thank u from my bottom of my heart very good explanation

[@discriplinehelpusDas]

Great explaination

[@Rakesh-ed4nn]

mam (name,age) cannot be a super key . am i correct mam

[@sohaibahmad6921]

phone number can be the same if 2 students of the same parent admit in the same class in the same school in same section . or if 2 students are brother

[@sudhasasikumar6719]

Clear explanation mam....

[@Anagha_VK]

Whats the difference btwn primary key and super key

[@sudhasasikumar6719]

Primary key should be unique and not null value (our Aadhar id). Super key holding more than one key(one key+ another one key) so these 2 keys super keys

[@rhul0017]

Super keys for which no proper subset is a super key is called candidate key,what is this ,its confusing ,can some one help me?

[@satheeshkumar-tb7xe]

Then what is the difference between primary n super....both same concepts....pl clarify.....soon

[@demongaming7716]

The age can also be the same mam right

[@sheharajayasooriya9523]

thank you so much! it was very helpful

[@alemayehutsegaye3002]

The way you explain is so...keep it up

[@maninderkaur9278]

Good explanation

[@vikasdsem9914]

Very well defined thanks

[@swathik5692]

Maam can you please provide classes of MySQL.

[@parthik6223]

miss is it possible to put student id, name, phone?

[@vamshianand959]

Mam if we take I'd and phone number then it will be more easy identify the record

[@ctrainer1195]

thank you madam

[@awaneetaim4729]

can we say combinaton of (std id,age) as key ??

[@rizvicomputercodes3968]

Well done mam

[@Rpprabu1]

Madam one doubt Stu id and age both are super key or not ?

[@manassahoo2750]

Yes

[@rajkamalsingh4728]

Super key vs composite key

[@siddharthrathore5958]

I think there would be more than 3 superkey

[@anshsharma7961]

Thanks mam

[@jaan4563]

Clealry explanation 👍tq

[@vinothinijawahar6938]

Then what is the diff bw primary and super key

[@faezakamran3793]

The basic difference is that you can take a single unique attribute as Primary Key but Super Key is a combination of multiple unique attributes.

[@manavmalhotra8513]

How can std id be the superkey?

[@blogsbarrel4734]

it's a unique value which can be used to find data of whole row,, and super key consist of a single attribute or set of attribute, so stid is a single attribute that's why super key ... If m not wrong

[@naushadnh4413]

Thank u very much

[@Gulshankumar-qh5gr]

Also age is a super key or not??

[@abhishekij001]

No age cannot be a super key , since two or more persons can have same age

[@missamal4553]

what about age attribute

[@dev1866]

plz madam can you share that wrtitten papers

[@ganeshbharadwaj1366]

Mam it's number. You are saying nember

[@KaranKaran-ob7rf]

Thanks

[@SaadQureshiOfficial]

can we have super key Phone and age?

[@faezakamran3793]

Age cannot be taken as a key because two students can have the same age. A key needs to be unique to a specific student.

[@madhudewangan7663]

mam unique key k bare me btye

[@faezakamran3793]

Unique means one. Any attribute that is specific to a person is unique. For example your National Identity number or Social Security Number. These are unique to you no other person can have the same ID or SSN.

[@nizazupin]

nice

[@manassahoo2750]

Is name a super key

[@brijeshvish6696]

Hindi me STD krao mam please

[@beastking143]

😡😡

[@vincyc8010]

I think priya is ur frnd😝😝😝

[@fakrulalam3309]

Finishing is not good