DBMS - Second Normal Form (2NF)

DBMS - Second Normal Form (2NF)
Watch more Videos at www.tutorialsp...
Lecture By: Mr. Arnab Chakraborty, Tutorials Point India Private Limited

[@TutorialsPoint_]

To Get Certification, Click Here: bitly.ws/PXXy Use coupon "KZbin12" to get ‘’FLAT 12%’’ OFF at Checkout.

[@scienceblossom6197]

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.

[@abdirahmanfarah4886]

Very well understood Thank u my proffessor of youtube

[@_piyusharma]

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-me3fi]

In course relation cid is primary key it should not contain duplicate value s

[@mrwilbroadtv4230]

thanks alot..always proud of tutorialpoint

[@36-shruthikashree.k38]

Thank you sir. Your vedio is best for the normalization.

[@pratishmashankar9910]

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.

[@ashkaras2336]

Thank you sir for making this clear 😊

[@sajeeb4]

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?

[@mohitveersinghsandhu8930]

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-jv4mp]

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

[@_MdArifulHoque]

It was very helpful .Thank you sir

[@rafsanpranto6100]

In course relation, CID IS11 has come for twice.

[@arnabchakraborty3593]

You are correct. We should omit one of them.

[@lekhshisodiya6094]

There is a little suggestion for you to please change the size of the text

[@jagginadivya3680]

we need to keep common column in table

[@maharshithakar007]

sir it's 'ANIL' not 'ONIL' but very nice explanation AND Thank you! for that!

[@abhiramj1934]

Bengali's have this type of accent, try to learn but not to judge.

[@starattaker4803]

well explained

[@rushalinavdurge474]

Thanku sirr

[@kishorsingh4317]

Best lecture

[@amandagezahegne7038]

amazing!!!!

[@NahidulIslam-te1py]

can i get this material ? i need this script please

[@mariaasad920]

explain partial dependency in detail this explanation is not understandable

[@ayushraj-zb6sv]

is se acha book hi parh leta yaar....

[@Rafayrealityfun]

you can teach it in hindi

[@syedahmedshah3663]

hina mir naam mera

[@mertkarababa885]

WHAT THA FAK

[@nabeeltech7885]

Improve your English sir . Ur accent is hard

[@maharshithakar007]

Improve your DBMS sir . Ur MARKS are hard😂😂😂😂