Keys in RDBMS

[@anjaligupta7532]

1000 times better explanation than our college teachers.. 👍

[@Idiot-ashim]

Which university

[@rajwindersinghlall1468]

True

[@dicey.1422]

shruti memda

[@Mojpedia]

You are a data science student

[@Hey_Haroon]

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

[@debasisnath9951]

from where are u pursuing mba? is it mba in IT?

[@Hey_Haroon]

@@debasisnath9951 yes, From GL Bajaj institute greater Noida

[@kawizekambowa3488]

Clear explanation indeed .

[@nurlanacc1623]

@@Hey_Haroon Email in alone is superkeu? Because it has null row

[@ragapriyakarthikeyan3139]

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

[@danielsims5771]

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

[@mutalekapambwe6882]

🇿🇲🇿🇲🇿🇲🇿🇲🇿🇲

[@peterlor4126]

My professor doesn't even know what he's most of the time, thankfully we have the help we can get here. Thank you very much!

[@robertbehrens7026]

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

[@BRIMACONTEH-d3v]

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

[@exploreyourself6776]

Precise And to the point.Well done 👍

[@rayaneziadeh1879]

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

[@kawizekambowa3488]

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

[@m-47recordzz35]

Nicely explained , Thnxx alot 💙

[@aakankshakhawase1860]

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

[@Torchbearer777]

Thank you for giving the knowledge about DBMS Keys ❤

[@tuikasrivastava1763]

seriously better than my professor!!!

[@Cobenis_Kar]

Beautifully explained, thank you!

[@VigneshwaranS-n2i]

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

[@gauravsrivastava17]

clears all the concept about keys

[@Saha121-h6y]

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

[@shresth_bhakta]

Thanks NESO academy for this! Indeed and infromative video !

[@sanjeebamat4485]

Great lacture thank you for making such wonderful video .

[@KathirNatarajan-wk3nc]

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

[@ashokkumarpadmanabhan6483]

Really use very usefull. Appreciated your efforts of sharing !!!

[@shrts-l8i]

1.75 X club

[@umaraju593]

very clear explanation. thank you

[@modiallo968]

excellent work sir, thank you!

[@geetashah4430]

Good explanation 😊

[@abdullateefidris-jf3ub]

Well understood, Thanks❤

[@dawaphunsumlodey153]

Simple and effective explanation. Thank you

[@jesusbrideindeed1657]

You are a great teacher

[@manasvikumarthakur5471]

Great Explaination Sir !!!!

[@kabir73722]

Thanks very clear explanation

[@regilearn2138]

Wow, appreciate you for this.

[@RenuSharma-iv7cs]

Very nicely explained

[@monicabhattacharya9029]

Thank you so much sir 😃😃👌

[@rivaldondezwenayo4028]

thank you i learnt alot from your work 😃😃😃😃😃😃

[@yoyo-hm2qo]

wonderful！！thanks，i understand it 100%😂

[@tinkupavan565]

Super explanation 👌👌👌

[@samuelayine418]

Great teacher !!!

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

[@baranhamoglu4072]

we need an answer to this, @funkiel-nowka if you found out can you explaine to me aswell ?

[@baranhamoglu4072]

@Neso Academy

[@haneenbaghdadi5966]

Even (Name, email) can't be a superkey coz what if email is Also null and the name might have repeated too...

[@gokulnaathb2627]

You're right! I have the same doubt. Most probably, that part of the explanation is wrong.

[@mohitzen]

Thank you sir 😊

[@nitikaphogat8084]

At 12:14 Wouldn't name ,email also be candidate key ...because name alone cannot be a key but when combined with phone number it become candidate key ....so I think name combined with email will also be candidate key ...... correct me if I am wrong

[@ezanatadesa2485]

You're right, If PhoneNumber and Email are not unique across tuples then both {Name, PhoneNumber} and {Name, Email} can be candidate keys.

[@JasGawera]

@@ezanatadesa2485 If Phone Number can be NULL, then (Name, Phone Number) cannot even be a candidate key can it? If John 101 and John 105 both have a NULL phone number then the key does not uniquely identify the tuple.

[@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}?

[@giack6235]

Thank you for the very clear explanation. Just a question: at 11:50 you are considering among candidate keys also {Name, Phone} but according to definition, candidate key is a minimal set of attributes to be key. Since we have already considered {ID} and {SSN} as keys, minimal set of attributes to be key is 1, while in the case {Name, Phone} set of attribute is 2, which is greater. So why do we consider {Name, Phone} still as candidate key?

[@sumanthkumar4035]

"minimal set of attributes" it implies that if you remove an attribute from it, it's no longer a key. minimal doesn't mean number of attributes, implies no extra attributes

[@Bharathsuru]

Nice explanation 💥💥💯

[@MEHARAsad-n3e]

great ...explanation

[@statuslover4867]

Thank you sir for nice explanation ❤️

[@abizeta7507]

great teacher😊

[@RishtonKiBaatein]

Thank you so much!

[@atharva..deshmukh]

Excellent!!

[@ayaanshaidahusain507]

Damn good explanation

[@sachinragu1742]

If one name is repeated twice and both the rows have null as their phone number then how will {name, phone} be a super key?

[@Kanna12377]

{name, phone} is not a key because u can't identify a unique tuple by using this in that condition

[@anusuyag5183]

@@Kanna12377for the super key u said like we can use name, phone as key right … that eg is coming for all candidate key primary key and alternative key.. then how come u r saying it’s not a keys

[@Raven812]

It is candidate key

[@ritasen225]

First you should make name and phone number as a key because it's not null but it's not not unique also

[@queenkhan500]

Am also confused😢

[@Abhishek-jh9lz]

100/10 ❤

[@adriand.2884]

Where is the tutorial of Normalization? I need it right now hehe, were done at keys in rdbms

[@AhmadRazaNaveed]

Thanks for a lot

[@kousik8042]

super key is like super set.but actually it is power set of keys

[@SaucedUpShawty]

Im getting a Neso Academy tattoo

[@sonuudarokar09]

You can add one thing here that is unique key allow only one null value....not more than one

[@Amdebirhan_Abebe]

Thank you !

[@Getagrip8]

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

[@A2Blearning1999]

Thank You

[@utsabbanerjee2770]

Lecturer key loves names like yusuf, alya, John , Robin etc.

[@sumanthkumar4035]

So, the unique key, must support null values apart from being unique ?

[@jovankumar7780]

Thankyou sir ❤❤❤❤😊😊😊

[@kavinarasan2619]

nandri thale

[@varanaze.]

😂😂 Mass bro nee 😂

[@HetShah-ww8ph]

One doubt : Super keys contain null values : {name,phone number} but if 1.{ john,null } and again in table we have 2.{john,null} than how we will identify the actual john than how it is valid…

[@atharvdeshmukh8192]

Name and phone no can't be super key. Super key should able to uniquely identify tuple. It should have atleast one attribute which is able to uniquely identify tuple, along with it can continue additional attribute which are not helping to uniquely identify the tuple. Ssn,name and phone no can be super key

[@umabharathyts1998]

Thanks !

[@ravindrathakur4563]

Thanks

[@Tijiyabhanu]

Sir Unique key means it accepted null values or not

[@hscodingdairies14]

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

[@somendrasarkar7837]

Let's assume a airplane reservation system. What can be a primary key? Flight Number or Flight Number+Date

[@Hahe2023]

I think both can act as a primary key but according to lecture " primary key should never and rarely be changed " 15:55 So there may be chance of date not mentioned (null) so flight number will definitely be a primary key.

[@nurlanacc1623]

Email in alone is superkeu? Because it has null row

[@DaiMoscv]

(Name, email) what if the email is Null but the name alone cannot identify uniquely a tuple? In my opinion in this case it cannot be a superkey

[@haneenbaghdadi5966]

Yess....even (Name, phone) can't be a super key...the phone no. Can also be null and the name can be repeated too...ig we hv to assign these attributes with certain keys separately....

[@tricks_without_treat]

Thanks bro

[@boy-bf3si]

12:16 why phone number isn't a candidate key

[@aswin5226]

Is it possible for a unique and composite key to be something other than a candidate key?

[@gokulnaathb2627]

Thank you

[@dipjoytidebnath5530]

its not mandatory chosen by DBA its depends on application developer which field is required and why so correct your knowledge DBA only responsible for permission related access not application related

[@utube_int2075]

So, super key is set of all possible combinations of attributes that can uniquely identify tuples. Is it right?

[@shrutiagnihotri526]

If a column does not uniquely identify a tuple..it can't be a key...then how can u say email I'd can be a super key while it can contain null value

[@GIGAlex6]

Composite key at 19:28

[@gokulnaathb2627]

How can {Name, Phone} uniquely identify a tuple? Phone is nullable, right?

[@moatemsulongchar8418]

I think we can set it to NOT NULL

[@SatyamMaurya..]

12:41 here , (salary and phone) too.

[@hovering900]

Can only a null value be a candidate key?

[@HetShah-ww8ph]

It is possible that both john have null phone numbers than how can we identify the actual john?????????? From the table ………

[@userkanikanika]

Simple It's ID ID is always Unique

[@gottipadthasahithisahithig1137]

Sir could you post SQL tutorial

[@Ganeshay-09]

Primary key --> PK PK is unique, NOT NULL, required , never duplicate and used for uniquely identify the data in table. every table have a max 1 PK. create table empinfo( id number primary key, ename varchar2(20), deptid number ); Unique key --> UK UK is unique, required, never duplicate and used for uniquely identify the data in table. table can have more than 1 unique key. UK allows null. every null is unique, we can not compare null to another null. thats why UK allows null, because it treats every null as unique. 10+null = null 10- null = null null is unknown and undefined, we do not know the value, so it always gives us null

[@talhashahid2176]

awesome

[@syedidrees7354]

how name and phone can be super key if there are 2 employees with same name and having null in their phone number field.

[@ishalkumar9037]

Which one was the foreign key ??? Dept. Code or any other ??

[@mjordan1117]

why is salary on the table if you dont make use of it? Why is it not an alternate key?

[@hosseinramezani5025]

l think Name and Phone togather cant be a super key, cause we can have two Johns that dont have phone numbers! please correct me if im wrong

[@hewansolomon1973]

phone no is unique also it is can be null so it is super key i think

[@gokulanvs]

In the super key what if two employees having same name both don't have phone number , how will you uniquely edit their data

[@AlphaNOVA69]

Then it is not a super key, a super key should have attributes that are uniquely identifiable for each entry

[@rocklee3254]

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.

[@TournamentNepal]

candidate key can also have a null value

[@skyskitchen7872]

salary also can't be a superkey, right?

[@4rithv1]

Yupp

[@steveboel12]

How can the set {Name, Phone} be a super key if multiple people can have the same name and not every person has a phone number?

[@Debugger_97]

Super key is possible of all combinations even null attributes can be used

[@Debugger_97]

Phone number alone and with others can be made super key but name won't !

[@Debugger_97]

Ask ChatGpt after providing some attributes to it

[@anusuyag5183]

Unique key can b id or ssn right.. how come name, phone will be unique key

[@enisozturk8075]

I have the same question how the phone number can be a unique key? There could be multiple nulls.

[@samsonsumba7875]

Great

[@hehehe9925]

can a candidate key have null values?pls anyone reply

[@haneenbaghdadi5966]

Yess...Candidate key attribute can contain null values. Also know that it does not allow the same value in the attribute field.

[@shivamtiwari9040]

at 19:19 name is not a unique key phone is a unique key and you are saying that set of name and phone is unique key, what if two employee of same name don't have phone number.

[@kousik8042]

only phone number is also not a key. multiple employee might have no phone....2ndnot- employees with same name might also have no phone. so 'only name', 'only phone number', 'both name and phone number' are not keys...forget which type...those are not key first

[@yoga_with_atharva]

why email is not unique key> as it is unique and null value

[@poulomi1801]

some companies allow employees to have multiple email addresses, or they might have an email alias system where multiple employees share the same email domain. Additionally, allowing null values means that not all employees are required to have an email address, which further complicates setting it as a unique key.