DBMS - Second Normal Form (2NF) Watch more Videos at www.tutorialsp... Lecture By: Mr. Arnab Chakraborty, Tutorials Point India Private Limited
Пікірлер: 32
@TutorialsPoint_ Жыл бұрын
To Get Certification, Click Here: bitly.ws/PXXy Use coupon "KZbin12" to get ‘’FLAT 12%’’ OFF at Checkout.
@scienceblossom61976 жыл бұрын
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.
@abdirahmanfarah48862 жыл бұрын
Very well understood Thank u my proffessor of youtube
@_piyusharma6 жыл бұрын
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.
@Kiran-me3fi5 жыл бұрын
In course relation cid is primary key it should not contain duplicate value s
@mrwilbroadtv42303 жыл бұрын
thanks alot..always proud of tutorialpoint
@36-shruthikashree.k385 жыл бұрын
Thank you sir. Your vedio is best for the normalization.
@pratishmashankar99105 жыл бұрын
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.
@ashkaras23362 жыл бұрын
Thank you sir for making this clear 😊
@sajeeb46 жыл бұрын
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?
@mohitveersinghsandhu89306 жыл бұрын
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
@AmitKumar-jv4mp6 жыл бұрын
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..
@narendratrump3313 Жыл бұрын
really good ra thooma sir big fan saaar
@_MdArifulHoque4 жыл бұрын
It was very helpful .Thank you sir
@rafsanpranto61006 жыл бұрын
In course relation, CID IS11 has come for twice.
@arnabchakraborty35936 жыл бұрын
You are correct. We should omit one of them.
@lekhshisodiya60944 жыл бұрын
There is a little suggestion for you to please change the size of the text
@jagginadivya36806 жыл бұрын
we need to keep common column in table
@maharshithakar0074 жыл бұрын
sir it's 'ANIL' not 'ONIL' but very nice explanation AND Thank you! for that!
@abhiramj19343 жыл бұрын
Bengali's have this type of accent, try to learn but not to judge.
@starattaker48037 ай бұрын
well explained
@rushalinavdurge4745 жыл бұрын
Thanku sirr
@kishorsingh43175 жыл бұрын
Best lecture
@amandagezahegne70384 жыл бұрын
amazing!!!!
@NahidulIslam-te1py2 жыл бұрын
can i get this material ? i need this script please
@mariaasad9203 жыл бұрын
explain partial dependency in detail this explanation is not understandable