I have used your videos several times sir, I have not written a "thanks" on each of them but here I'm going to thank you once for all of them. I appreciate it.
Sir, after splitting the table, you said there is no update anomaly. But if we see the Course relation, and if we want to update the title of Course ID - IS11, there can be update anomaly and that will restrict it from being in 2NF. Correct me if I'm wrong.
in course relation, there is a repetition of IS11 record, it will cause updation anomaly. IS11 should be IT11 in the second record else there will be no relation between student and course relation.
At 8:07 you have said that, 'Always remember if the relation does not have COMPOSITE KEY then it is in 2NF. But here in junction table [dbo.Registration] I've a composite key. ([CID, SID]) How?
What he said is If their is Only one Prime Attribute that means no Composite key, the relation will have Complete Functional Dependency. That is what we actually want in 2nf
you are right , Grade depends on SID and not on CID (Partially dependent )..... CID is not required when we are converting it to 2NF ....... Note : - a relation having composite key can be in 2NF if all the not key attributes fully dependent on all the attributes which contributes in composite key..
To Get Certification, Click Here: bitly.ws/PXXy
Use coupon "UA-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
Very well understood Thank u my proffessor of youtube
I have used your videos several times sir, I have not written a "thanks" on each of them but here I'm going to thank you once for all of them. I appreciate it.
thanks alot..always proud of tutorialpoint
Thank you sir. Your vedio is best for the normalization.
Sir, after splitting the table, you said there is no update anomaly. But if we see the Course relation, and if we want to update the title of Course ID - IS11, there can be update anomaly and that will restrict it from being in 2NF.
Correct me if I'm wrong.
In course relation cid is primary key it should not contain duplicate value s
really good ra thooma sir
big fan saaar
Thank you sir for making this clear 😊
in course relation, there is a repetition of IS11 record, it will cause updation anomaly. IS11 should be IT11 in the second record else there will be no relation between student and course relation.
It was very helpful .Thank you sir
In course relation, CID IS11 has come for twice.
You are correct. We should omit one of them.
At 8:07 you have said that, 'Always remember if the relation does not have COMPOSITE KEY then it is in 2NF. But here in junction table [dbo.Registration] I've a composite key. ([CID, SID]) How?
What he said is If their is Only one Prime Attribute that means no Composite key, the relation will have Complete Functional Dependency. That is what we actually want in 2nf
you are right , Grade depends on SID and not on CID (Partially dependent )..... CID is not required when we are converting it to 2NF ....... Note : - a relation having composite key can be in 2NF if all the not key attributes fully dependent on all the attributes which contributes in composite key..
well explained
amazing!!!!
we need to keep common column in table
sir it's 'ANIL' not 'ONIL' but very nice explanation AND Thank you! for that!
Bengali's have this type of accent, try to learn but not to judge.
Best lecture
Thanku sirr
There is a little suggestion for you to please change the size of the text
can i get this material ? i need this script please
hina mir naam mera
explain partial dependency in detail this explanation is not understandable
you can teach it in hindi
is se acha book hi parh leta yaar....
WHAT THA FAK
Improve your English sir . Ur accent is hard
Improve your DBMS sir . Ur MARKS are hard😂😂😂😂