1000 times better explanation than our college teachers.. 👍
@user-bk3zf5me7o3 ай бұрын
Which university
@rajwindersinghlall14683 ай бұрын
True
@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
@kawizekambowa34883 ай бұрын
Clear explanation indeed .
@nurlanacc162319 күн бұрын
@@Hey_Haroon Email in alone is superkeu? Because it has null row
@ragapriyakarthikeyan313911 ай бұрын
The session is too engaging ,Sir. Got cleared with all the concepts🙂.Thankyou sir
@danielsims577111 ай бұрын
Oh my goodness. You explained the complex Lecture to a lay_man's view. I subscribed right away. Sending love from Zambia
@mutalekapambwe68829 ай бұрын
🇿🇲🇿🇲🇿🇲🇿🇲🇿🇲
@user-rd8rs4xl7b11 ай бұрын
Such a great teacher with clean and clear explanation! thank you!
@robertbehrens7026 Жыл бұрын
you explained it 10/10, thank you so much!
@exploreyourself6776 Жыл бұрын
Precise And to the point.Well done 👍
@user-uw6tl4oz5b2 ай бұрын
1.75 X club
@aakankshakhawase1860Ай бұрын
Thank you for the explanation. Your explanation really helped in clearing the concepts regarding the keys.👍Great work!
@rayaneziadeh1879 Жыл бұрын
thank you for speaking clearly, finally found a video in which i can understand what its said
@kawizekambowa34883 ай бұрын
It is not that difficult , it was just clarity i needed. Thank you
@Torchbearer777Ай бұрын
Thank you for giving the knowledge about DBMS Keys ❤
@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😢
@m-47recordzz35 Жыл бұрын
Nicely explained , Thnxx alot 💙
@tuikasrivastava1763Ай бұрын
seriously better than my professor!!!
@user-bl1tm3su6c3 ай бұрын
really! understood very clearly , mainly this session has been too engaging without lag.
@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? 🤔🤔🤔
@baranhamoglu407210 ай бұрын
we need an answer to this, @funkiel-nowka if you found out can you explaine to me aswell ?
@baranhamoglu407210 ай бұрын
@Neso Academy
@haneenbaghdadi59669 ай бұрын
Even (Name, email) can't be a superkey coz what if email is Also null and the name might have repeated too...
@gokulnaathb26276 ай бұрын
You're right! I have the same doubt. Most probably, that part of the explanation is wrong.
@gauravsrivastava173 ай бұрын
clears all the concept about keys
@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.
@Cobenis_Kar Жыл бұрын
Beautifully explained, thank you!
@RenuSharma-iv7cs4 ай бұрын
Very nicely explained
@regilearn21382 ай бұрын
Wow, appreciate you for this.
@samuelayine4183 ай бұрын
Great teacher !!!
@KathirNatarajan-wk3nc7 ай бұрын
Very very clear, really useful, wonderful explanation.great mentor u r sir, pls put more videos regarding dbms sir 🙏🙏🙏
@kabir737223 ай бұрын
Thanks very clear explanation
@jesusbrideindeed16577 ай бұрын
You are a great teacher
@manasvikumarthakur54715 ай бұрын
Great Explaination Sir !!!!
@shresth_bhakta Жыл бұрын
Thanks NESO academy for this! Indeed and infromative video !
@abdullateefidris-jf3ub10 ай бұрын
Well understood, Thanks❤
@umaraju5936 ай бұрын
very clear explanation. thank you
@sanjeebamat4485 Жыл бұрын
Great lacture thank you for making such wonderful video .
@user-de4im7hf8iАй бұрын
Thanks for a lot
@modiallo9686 ай бұрын
excellent work sir, thank you!
@Saha121-h6y7 ай бұрын
Fantastic... Teaching..Great Sir Thank you sir
@umabharathyts1998Ай бұрын
Thanks !
@monicabhattacharya9029 Жыл бұрын
Thank you so much sir 😃😃👌
@tinkupavan5655 ай бұрын
Super explanation 👌👌👌
@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}?
@dawaphunsumlodey153 Жыл бұрын
Simple and effective explanation. Thank you
@mohitzen Жыл бұрын
Thank you sir 😊
@HetShah-ww8ph4 күн бұрын
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…
@adriand.2884 Жыл бұрын
Where is the tutorial of Normalization? I need it right now hehe, were done at keys in rdbms
@RishtonKiBaatein Жыл бұрын
Thank you so much!
@hscodingdairies1410 ай бұрын
Can someone please explain what is a unique key because it seemed same as alternate keys
@abizeta750710 ай бұрын
great teacher😊
@Bharathsuru Жыл бұрын
Nice explanation 💥💥💯
@giack62354 ай бұрын
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?
@sumanthkumar40354 ай бұрын
"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
@rivaldondezwenayo4028 Жыл бұрын
thank you i learnt alot from your work 😃😃😃😃😃😃
@yoyo-hm2qo5 ай бұрын
wonderful!!thanks,i understand it 100%😂
@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
@haneenbaghdadi59669 ай бұрын
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....
@zeeleditz015 ай бұрын
Thankyou sir ✨
@Abhishek-jh9lz9 ай бұрын
100/10 ❤
@kousik8042 Жыл бұрын
super key is like super set.but actually it is power set of keys
@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
@nurlanacc162319 күн бұрын
Email in alone is superkeu? Because it has null row
@A2Blearning199910 ай бұрын
Thank You
@GIGAlex63 ай бұрын
Composite key at 19:28
@Amdebirhan_Abebe Жыл бұрын
Thank you !
@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.
@ravindrathakur4563 Жыл бұрын
Thanks
@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.
@sonuudarokar09 Жыл бұрын
You can add one thing here that is unique key allow only one null value....not more than one
@sumanthkumar40354 ай бұрын
So, the unique key, must support null values apart from being unique ?
@shrutiagnihotri5263 ай бұрын
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
@gokulnaathb26276 ай бұрын
Thank you
@statuslover4867 Жыл бұрын
Thank you sir for nice explanation ❤️
@utsabbanerjee27708 ай бұрын
Lecturer key loves names like yusuf, alya, John , Robin etc.
@somendrasarkar78379 ай бұрын
Let's assume a airplane reservation system. What can be a primary key? Flight Number or Flight Number+Date
@Hahe20237 ай бұрын
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.
@samsonsumba78752 ай бұрын
Great
@mjordan1117 Жыл бұрын
why is salary on the table if you dont make use of it? Why is it not an alternate key?
@tricks_without_treat Жыл бұрын
Thanks bro
@jovankumar7780 Жыл бұрын
Thankyou sir ❤❤❤❤😊😊😊
@utube_int2075 Жыл бұрын
So, super key is set of all possible combinations of attributes that can uniquely identify tuples. Is it right?
@Ganeshay-9967 ай бұрын
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
@SatyamMaurya..5 ай бұрын
12:41 here , (salary and phone) too.
@aswin52269 ай бұрын
Is it possible for a unique and composite key to be something other than a candidate key?
@gottipadthasahithisahithig11373 ай бұрын
Sir could you post SQL tutorial
@ishalkumar9037 Жыл бұрын
Which one was the foreign key ??? Dept. Code or any other ??
@kavinarasan2619 Жыл бұрын
nandri thale
@varanaze.11 ай бұрын
😂😂 Mass bro nee 😂
@gokulanvs3 ай бұрын
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
@HetShah-ww8ph4 күн бұрын
It is possible that both john have null phone numbers than how can we identify the actual john?????????? From the table ………
@userkanikanika2 сағат бұрын
Simple It's ID ID is always Unique
@hosseinramezani50256 ай бұрын
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
@hewansolomon19735 ай бұрын
phone no is unique also it is can be null so it is super key i think
@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
@steveboel126 ай бұрын
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_974 ай бұрын
Super key is possible of all combinations even null attributes can be used
@Debugger_974 ай бұрын
Phone number alone and with others can be made super key but name won't !
@Debugger_974 ай бұрын
Ask ChatGpt after providing some attributes to it
@yoga_with_atharva4 ай бұрын
why email is not unique key> as it is unique and null value
@poulomisantra21843 ай бұрын
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.
@gokulnaathb26276 ай бұрын
How can {Name, Phone} uniquely identify a tuple? Phone is nullable, right?
@moatemsulongchar84184 ай бұрын
I think we can set it to NOT NULL
@skyskitchen78725 ай бұрын
salary also can't be a superkey, right?
@C4_NETIC5 ай бұрын
Yupp
@vaalarivan_p Жыл бұрын
yramirp yek dne: 14:32
@hehehe9925 Жыл бұрын
can a candidate key have null values?pls anyone reply
@haneenbaghdadi59669 ай бұрын
Yess...Candidate key attribute can contain null values. Also know that it does not allow the same value in the attribute field.
@lakshminarayanachintaginja18417 ай бұрын
Evatiki keys chepdam Saritha radhu ra😂😂😂😂😂
@obito324811 ай бұрын
bro in 12:42 {name,email } will come or not ?
@haneenbaghdadi59669 ай бұрын
No...becoz name attribute has already appeared ...in {Name, phone} so u can't have repeated attributes in candidate keys... same goes for email...see this part again 12:17 ...as u can see the email has also appeared once{Email} so u can't hv it again.