super key in dbms

  Рет қаралды 204,684

Education 4u

Education 4u

Күн бұрын

Пікірлер: 68
@abdullahalamil4276
@abdullahalamil4276 5 жыл бұрын
I really don’t know how to thank you. Your explanation is amazing and easy to understand. Thank you 🙏🏼
@codestudy2035
@codestudy2035 2 жыл бұрын
great, wasted hours searching in google and tried to read and understand. This video cleared my doubt in 3minutes. thank you
@kecojune6857
@kecojune6857 8 ай бұрын
same
@beastking143
@beastking143 7 ай бұрын
Nice joke 🤣🤣😂
@rohitgore1792
@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
@alhassandumbuya3601 8 ай бұрын
Thanks you very much you lectures are easy to understand.
@sushantbhatia9930
@sushantbhatia9930 4 жыл бұрын
madam apne jo table ke sath samjaya usse super key clear hua thanku madam
@danielthapamagar2179
@danielthapamagar2179 6 жыл бұрын
your examples helps to understand easily, thanks ...
@apekshakhandare55
@apekshakhandare55 5 жыл бұрын
First time I understand all the concept about keys like primary key, candidate key, foreign key, etc.thanx
@markafetorgbor7603
@markafetorgbor7603 3 жыл бұрын
Your explanation is very very superb and understandable. Thanks for the great work
@piyushverma7280
@piyushverma7280 Жыл бұрын
mam your explanation is excellent and understandable. If you can provide those notes it is also good Thanks mam
@vinaykumaryadav2974
@vinaykumaryadav2974 Жыл бұрын
I have seen all your videos, you tell or explain very well.
@adarshcs6018
@adarshcs6018 6 жыл бұрын
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
@Paradise-kv7fn 5 жыл бұрын
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
@nikhilparab1815 4 жыл бұрын
Id no or roll no can be a primary key and phone no can be super key
@veerachegu
@veerachegu 5 жыл бұрын
Madem i am Electrical background just i saw ur videos dbms nice explanation never will explain like u thkyou so much
@galamdilliganesh5025
@galamdilliganesh5025 5 ай бұрын
Thank you mam for the knowledge
@KULDEEPSINGH-em3nd
@KULDEEPSINGH-em3nd 6 жыл бұрын
well, at last i came through minimum investment video filmed with. best of luck mam
@clashclans9783
@clashclans9783 Жыл бұрын
thank you so much for the explanation, my professor made it harder to understand this.
@baranhamoglu4072
@baranhamoglu4072 11 ай бұрын
I assume that we can take (age,name) as a super key in this specific example...
@blogsbarrel4734
@blogsbarrel4734 4 жыл бұрын
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
@VJY90 4 жыл бұрын
Am really thank u from my bottom of my heart very good explanation
@discriplinehelpusDas
@discriplinehelpusDas 2 жыл бұрын
Great explaination
@Rakesh-ed4nn
@Rakesh-ed4nn 3 жыл бұрын
mam (name,age) cannot be a super key . am i correct mam
@sohaibahmad6921
@sohaibahmad6921 4 жыл бұрын
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
@sudhasasikumar6719 5 жыл бұрын
Clear explanation mam....
@Anagha_VK
@Anagha_VK 5 жыл бұрын
Whats the difference btwn primary key and super key
@sudhasasikumar6719
@sudhasasikumar6719 5 жыл бұрын
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
@rhul0017 5 жыл бұрын
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
@satheeshkumar-tb7xe 5 жыл бұрын
Then what is the difference between primary n super....both same concepts....pl clarify.....soon
@demongaming7716
@demongaming7716 5 ай бұрын
The age can also be the same mam right
@sheharajayasooriya9523
@sheharajayasooriya9523 5 жыл бұрын
thank you so much! it was very helpful
@alemayehutsegaye3002
@alemayehutsegaye3002 6 жыл бұрын
The way you explain is so...keep it up
@maninderkaur9278
@maninderkaur9278 4 жыл бұрын
Good explanation
@vikasdsem9914
@vikasdsem9914 6 жыл бұрын
Very well defined thanks
@swathik5692
@swathik5692 5 жыл бұрын
Maam can you please provide classes of MySQL.
@parthik6223
@parthik6223 Жыл бұрын
miss is it possible to put student id, name, phone?
@vamshianand959
@vamshianand959 3 жыл бұрын
Mam if we take I'd and phone number then it will be more easy identify the record
@ctrainer1195
@ctrainer1195 5 жыл бұрын
thank you madam
@awaneetaim4729
@awaneetaim4729 5 жыл бұрын
can we say combinaton of (std id,age) as key ??
@rizvicomputercodes3968
@rizvicomputercodes3968 6 жыл бұрын
Well done mam
@Rpprabu1
@Rpprabu1 5 жыл бұрын
Madam one doubt Stu id and age both are super key or not ?
@manassahoo2750
@manassahoo2750 Жыл бұрын
Yes
@rajkamalsingh4728
@rajkamalsingh4728 3 жыл бұрын
Super key vs composite key
@siddharthrathore5958
@siddharthrathore5958 3 жыл бұрын
I think there would be more than 3 superkey
@anshsharma7961
@anshsharma7961 5 жыл бұрын
Thanks mam
@jaan4563
@jaan4563 6 жыл бұрын
Clealry explanation 👍tq
@vinothinijawahar6938
@vinothinijawahar6938 5 жыл бұрын
Then what is the diff bw primary and super key
@faezakamran3793
@faezakamran3793 5 жыл бұрын
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
@manavmalhotra8513 5 жыл бұрын
How can std id be the superkey?
@blogsbarrel4734
@blogsbarrel4734 4 жыл бұрын
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
@naushadnh4413 6 жыл бұрын
Thank u very much
@Gulshankumar-qh5gr
@Gulshankumar-qh5gr 4 ай бұрын
Also age is a super key or not??
@abhishekij001
@abhishekij001 3 ай бұрын
No age cannot be a super key , since two or more persons can have same age
@missamal4553
@missamal4553 6 жыл бұрын
what about age attribute
@dev1866
@dev1866 2 жыл бұрын
plz madam can you share that wrtitten papers
@ganeshbharadwaj1366
@ganeshbharadwaj1366 4 жыл бұрын
Mam it's number. You are saying nember
@KaranKaran-ob7rf
@KaranKaran-ob7rf 6 жыл бұрын
Thanks
@SaadQureshiOfficial
@SaadQureshiOfficial 5 жыл бұрын
can we have super key Phone and age?
@faezakamran3793
@faezakamran3793 5 жыл бұрын
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
@madhudewangan7663 5 жыл бұрын
mam unique key k bare me btye
@faezakamran3793
@faezakamran3793 5 жыл бұрын
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
@nizazupin 5 жыл бұрын
nice
@manassahoo2750
@manassahoo2750 Жыл бұрын
Is name a super key
@brijeshvish6696
@brijeshvish6696 5 жыл бұрын
Hindi me STD krao mam please
@beastking143
@beastking143 7 ай бұрын
😡😡
@vincyc8010
@vincyc8010 4 жыл бұрын
I think priya is ur frnd😝😝😝
@fakrulalam3309
@fakrulalam3309 4 жыл бұрын
Finishing is not good
candidate key in dbms
9:43
Education 4u
Рет қаралды 190 М.
Keys in RDBMS
22:49
Neso Academy
Рет қаралды 356 М.
What's in the clown's bag? #clown #angel #bunnypolice
00:19
超人夫妇
Рет қаралды 42 МЛН
Keys in dbms | Introduction |  types of keys | Bhanu Priya
20:41
Education 4u
Рет қаралды 169 М.
foreign key in dbms
19:42
Education 4u
Рет қаралды 156 М.
constraints in dbms | key, domain & referential integrity |
13:47
Education 4u
Рет қаралды 475 М.
Lec 3: Super Key | Candidate Key | Primary Key | Types of keys in DBMS
35:55
Jenny's Lectures CS IT
Рет қаралды 759 М.
Concept of Keys in DBMS - Super, Primary, Candidate, Foreign Key, etc
9:16
Studytonight with Abhishek
Рет қаралды 517 М.
Lec-8.0: Integrity Constraints in Database with Examples
7:14
Gate Smashers
Рет қаралды 395 М.
Super Key, Candidate Key and Primary Key | Database Management System
9:49
Edredo for Learners
Рет қаралды 396 М.
1NF 2NF 3NF DBMS
8:32
Saghir School
Рет қаралды 263 М.