4.7 How to Decompose a relation into 2NF

[@KNOWLEDGEGATE_kg]

For complete DBMS, check out this video: kzbin.info/www/bejne/j4PRm3qbhsemfrM

[@aditichavan3427]

After searching for long time Passing By Jenny' Lectures , Gate Smashers etc at last I had to come to Sanchit Sir Only !!...He is a True Saviour of Students 👌👌👍

[@KNOWLEDGEGATE_kg]

Thank you so much dear for your kind words & valuable feedback❤Keep supporting & stay connected for more amazing contents👍😊 You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

[@choudhary.0402]

Same here

[@Otaku_toki]

Same here.Tomorrow I have my exam and yesterday only my friend told me about this channel. I am so grateful to you sir for your lectures, they are really helpful. Truly you are a saviour!!🙌🤗

[@TanuSingh-yy2et]

Same here 🥲

[@Freekamall957]

Same here bro

[@shivamshukla-tu2sq]

I can't complete my graduation with regular beacause of some financial problems thanks again for your tutorials.Your vidios are very helpful for me.

[@narendraparmar1631]

Neta banane wale example se easily samjh aa gaya. Please always use such kind of examples. Thanks sir ji

[@animeshmishra4282]

I watch all the advt to pay tribute to such an amazing teacher. He is like an angel for me.

[@khubeb1]

Correct

[@SahilYadav-ry4bp]

angel hota h bhai

[@fatinishrakarian2267]

angel

[@animeshmishra4282]

Hn bhai gwar nhi ho typo ho gya

[@shashankkestwal4454]

Your lectures appear to be ab upgraded version of normal university classes. Easy to understand languages and great explaination.

[@KNOWLEDGEGATE_kg]

Thank you so much dear Shashank for your valuable feedback, keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents !

[@sohinidhar3344]

Ap sach mein savior ho sir, pura ka pura semester padne ke baad bhi jab doubts aaye toh ap hi hok bharosha.....

[@KNOWLEDGEGATE_kg]

Haha am glad❤ Wish you all the very best for your sem exams & stay connected for all the upcoming contents & videos👍

[@HarshShah-hm9xg]

Those who knows all the concept and came here just for solve questions ans 1 :- 6:06 ans 2 :- 9:32 ans 3 :- 14:30 Thanks.

[@KNOWLEDGEGATE_kg]

🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg 🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg

[@tidbitz1955]

Awesome explanation for converting the relation to 2nf

[@KNOWLEDGEGATE_kg]

Glad you liked it, thank you. Keep learning & following. You can also check out our website www.knowledgegate.in for more content👍

[@sagarchowdhury4u]

sir i have a request for you ,sir please make a complete series of videos on fuzzy mathematics whenever you have time because there are hardly any good videos on fuzzy mathematics and you teach really well so please make videos on this topic as well

[@muhammadibnwahid6405]

7:28 Important point that B to E is not a partial dependency

[@ProudNepaliChannel]

TYSM for the crystal clear concept. No words to thank you sir!

[@alapanroy1114]

clg me jab mujhe explain karneko kaha maine bhi bataya do atribute neta banne ki kosis ki,,,,,....... LOL

[@mianreyes9382]

hahahaha

[@rakhshandamujib2793]

Duniya ke sabse achhe teacher ho aap!

[@TheSAWR]

I don't even understand hindi, but your explaination is understandable than prof. in my class, lol.

[@sarikaj7562]

U have explained this concept in very easy way.Ur videos are really good

[@niteshpandey43]

candidate key ka koi proper subset kisi non prime ko find kare toh partial dependency...itni baar sun liya yaad ho gya sir

[@AbhishekKumar-yu1mf]

Woww Kamaal Dhamaal explanation. Thank you sir.

[@KNOWLEDGEGATE_kg]

Most welcome dear Abhishek, keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents !

[@abhishekjan9026]

Sir all your videos on dbms are worth watching life saviour for students

[@qanbar-pucit8534]

Waoo ! Great Explanation with no Boring Love from Pakistan 😍😍

[@KNOWLEDGEGATE_kg]

Thanks a lot dear❤keep learning & supporting! Stay connected for more amazing videos & contents 👍😊

[@vinayaksharma-ys3ip]

Sanchit Sir is such a wonder teacher💯💯👍

[@KNOWLEDGEGATE_kg]

Thanks a lot dear Vinayak..keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@UmangMundhara]

thanks for the video series and other video series and your explaining capacity is really good, it makes subject crystal clear.Thanks again!!

[@yugalsarkaar]

superrrbbb bhai... mjja aa jata hai itna accha koi nahi explain kr skta ...thankyou so much bhai :-)

[@nishantrawat4882]

Thank you so much sir , after finding so long , finally i get your video and understand this concept

[@KNOWLEDGEGATE_kg]

Glad you understood the concept, thank you for following our content. Stay connected & keep learning👍

[@trisha4985]

Never Understand with this much Clearity Thank you so much Sir.

[@KNOWLEDGEGATE_kg]

You are most welcome Trisha ❤️❤️..Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents !!

[@avijitbhadro3351]

Wow. I am amazed. Sir explains the concepts in superb way. ❤

[@KNOWLEDGEGATE_kg]

Glad you liked it, Avijit. Keep learning & stay connected for more amazing videos👍

[@SS-fz6qt]

Sir in last example you have created R2 (A, I) for A --> I, even you could have added I in R1 but you said there will be partial dependency that's why you made separate table R2. But in R3 you didn't make separate table for the dependency H --> J and you added J in R3 . Sir please elaborate it ,

[@shivis1531]

Because h is not pat of candidate key so it won't partial dependency and in A-> I A is part is candidate key so it will show partial dependency if wee keep it in R1 nd 2NF wi terminate

[@anjanikumar4933]

Such an easy and amazing explanation 🥰

[@KNOWLEDGEGATE_kg]

Thanks a lot dear 😍 keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@abhinandank8725]

Very awesome video sir,if you can,make a video on decomposition of table into 2nf which contains multiple keys.

[@colossalgaming1244]

oh man , this guy is a legend fr saved my day

[@arjunm.r8641]

Your class is very awesome.Thank you for this video

[@shababdev8225]

13:45 Q3 Relation 3 must contain ADGHJ Because H further point to j

[@kulbhushansingh1101]

yes you're right

[@dikshapandey5701]

thanku so much sir ..finally after so many lecture ..apke lecture se samj aagya ..

[@KNOWLEDGEGATE_kg]

Glad it's helpful, Diksha. Stay connected for more informative videos & keep learning👍

[@itz_me_imraan02]

add a video on converting ER diagram to table...then it will be a complete playlist ♥

[@KNOWLEDGEGATE_kg]

Dear Imraan, for complete course on DBMS, please check out the link given below: www.knowledgegate.in/learn/DBMSbysanchitsir

[@supriyabhide5095]

Thank you so much sir.. You are indeed all students' savior🙏🙏😊 Bohot bohot asani se samjhaya apne sir. Dhanywad

[@SS-fz6qt]

Do you mean that if there is partial dependency then we create separate table, but if there is transitive dependency then we include those attributes having transitive dependency in the table. Right ?

[@vijoo5896]

at 13:30 GH main say H -> J ko define krraha hy to wo R3 main q add nae kia? plz answer

[@sohamshinde1258]

same doubt

[@anmolgoyal6010]

Thanks you sanchit sir for clearing my concepts of various normal form because in college less understandable but this video really recommended 😊

[@KNOWLEDGEGATE_kg]

Thanks a lot dear @Anmol for your valuable feedback❤ Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing contents👍

[@optimistichomosapien7484]

Great explanation ❤️

[@KNOWLEDGEGATE_kg]

Thank you so much dear, Keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@AdityaSharma-cz5us]

For the given relation R(ABCDE) and F : {A->C, B->DE, D->C}, check which functional dependency (FD) violates the 2NF and decompose R into 2NF.

[@AdityaSharma-cz5us]

Any one plzz solve this question ??

[@nethrasri6387]

AB is candidate key. R1(A, C) R2(B, D, E, C) R3(A, B)

[@Netperson]

Thank you so much sir.... everything 2nf is so easy now

[@KNOWLEDGEGATE_kg]

You're most welcome dear student, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@BakchodMaafia]

Thankyou So Much bs bhot bhot dhanyawaad sir

[@KNOWLEDGEGATE_kg]

Most welcome dear Abhishek, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@OmitA25]

very nice...........try to upload videos on COA......

[@kondapallysaimanasa5261]

Ur explanation is really useful sir

[@rahilraikwar7981]

B,D neta ban ne ki koshish kr ra hai usko neeta bnaya jayega...😂😂😂

[@rushikrathod1376]

what if entire candidate key is creating partial dependency ? Ex : - AB --> CDE, B ---> DE. here c.k will be AB therefore, prime attributes are : AB and non prime attributes are : CDE so AB and B will create partial dependency. what will be the relations after decomposition to 2NF ?

[@RaviSingh-yf6jd]

Thanks sir but also upload computer network series please thanks again

[@sajidh4179]

Thnx sir.excellent method of teaching.

[@shivaclasses1683]

Tysm sir... bahut ache se example karaye

[@Vinit_Ambat]

Brilliant explanation!

[@KNOWLEDGEGATE_kg]

Thanks a lot dear! keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing courses & contents👍😊

[@SUMITKUMAR-eo9iu]

sir please make video with multiple c.k

[@anushyasundarrajan1198]

your explanations are good but it will be so much better if u can relate it with tables and teach rether than ABCD

[@ruchirrathore5055]

Hi SIr, if a dependency is AC->E, what type of dependency will it be?

[@shashanksaxena6189]

you made the topics so easy.........thnku sir

[@riyavijay6487]

Thank you thank you thank you soooo muchhh for making these videossss❤️❤️❤️❤️❤️❤️

[@shirazkhurana7327]

I have a Question What will be the resulting division for this relation: R(ABCD) FD: AB->C, A->D, In this case AB will be Candidate key: R1: (ABC), R2(AD) so my question is Do I need to create a separate table for Candidate key? like R3: AB

[@mayurigarg3527]

No we don't becoz when we make a separate table for candidate key we first check that our whole candidate key is dependent on someone or not if yes then we also take that i.e in that case we take c along AB n if not we just write only our candidate key I hope ur doubt will clear

[@bidyadharmohanty528]

Thanks @Mayuri Garg i had the same doubt..

[@mayurigarg3527]

Welcome@@@bidyadharmohanty528

[@Aabara_ka_dabara]

best explanation sir..

[@KNOWLEDGEGATE_kg]

Thanks a lot dear 😍keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@ChandanAkbarpuria]

Crystal clear in one shot Thank you sir

[@KNOWLEDGEGATE_kg]

Great, you're welcome @Chandan, keep learning & supporting.

[@ajaychavda3392]

happy teachers day

[@decentflow2112]

Jo jo neta ban rhe hai use bna leve🤣🤣 Wonderful explanation sir

[@KNOWLEDGEGATE_kg]

Thanks a lot.. Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses & contents.

[@zXarianCzar]

Thanks a lot sir🙌🙌

[@pavitkalra1869]

Bachaa liya aapne❤

[@nibir24]

dhanyabaad sir it means a lot to us.

[@shaifaliagarwal1749]

awsm explanation sir

[@KNOWLEDGEGATE_kg]

Keep watching, visit tiny.cc/yt_kgwebsite for more helpful content & courses !

[@sayaksen3359]

sir agr transitive propertieds ko separate tables mei likhe toh woh galat ho jayega kya? sir pls say very urgent

[@gopibharti4362]

Learn alot form u sir

[@harekrishna9587]

Awesome sir 👍👍

[@sudarshanprajapati9742]

very helpful lecture....thanku sir

[@CSE_11]

Hello guys all good ?!

[@KhyatiSrivastv]

Thanks a lot sir....Big help 🙌

[@syedwajahat2135]

Sir kindly upload a video as you uploaded 1st normal form video with example of subjects I have to learn kindly its a request... I will wait for you.

[@rightclick4967]

Sir, in 3rd question R2 is (A I) AND R3 (ADGHJ) THEN WE CAN INCLUDE i in r3 like this r3 (A,D,G,H,I,J) because there is a dependency from A to I. plz replay

[@anantraj1275]

that'll be the case of partial dependency again if we include i in R3..then A will be subset of candidate key AD and it'll point to i..Hope this helps

[@Korosensei-vj9xb]

can we make r3 as adgh and r5 as abdhj in the last question?

[@omkardeshpande7482]

Sir, I didn't get the concept of Identifying of NF. How can we say that the questions in the above video ARE in 2NF? Infact the questions are reduced to 1NF, hence must be in 1NF initially, which we are reducing in 2NF. ..

[@nezmika2911]

Thanks a lot ! Very much clarity!

[@triptibhardwaj9454]

Thanku so much it helped me a lot ....

[@sadiq4933]

Lit Sir🔥🔥🔥🔥🔥

[@rahulagrawal4635]

best ... Only one word to describe you.

[@shaifaliagarwal1749]

grt explanation sir

[@shivamshukla-tu2sq]

Thanks sir..for all videos.

[@desthebest100]

These are extremely helpful but sometimes does he switch languages? Not trying to be mean but sometimes I can't understand and idk if im missing out on info

[@riya53397]

Thank you sir aapne bahut acha padaya❤

[@KNOWLEDGEGATE_kg]

You're welcome RIya, keep learning & following! Stay connected for more amazing videos & contents👍😊

[@utsavpatel9315]

great job!! really helpful

[@dinkarmehta1445]

Thanks a lot, Sir !!

[@bhupeshbhatt4334]

Sir, you created a third relation(ABD) in first question. Could you please tell, why it was required?

[@nethrasri6387]

ABD is the candidate key

[@suneelakrishna9141]

Very helpful sir

[@muhammadyounis7321]

Bundles of thanks Sir...

[@KNOWLEDGEGATE_kg]

My pleasure :) Visit www.knowledgegate.in for more content & courses !!

[@chirag_setia]

Can u cover the case with multiple candidate key

[@AdeshPaul]

dhanyawad

[@sohamajgaonkar3119]

Ek se jyada candidate keys hongi toh kya karenge??

[@mixedmashup778]

thank god i found you sir

[@divewithshubham]

sir OS k topics k topics ko cover kijiye na.

[@sumitsinghrawat7657]

how to eliminate extra FD without changing primary key? How it is solve?

[@juraijbinjamal5313]

I love you man

[@KNOWLEDGEGATE_kg]

Thanks a lot dear, keep supporting ❤️❤️

[@alapanroy1114]

apki voice amazing hai

[@ayushmaheswari8827]

😍😍😍 loved it

[@gautamkumarjha2686]

sir how many lectures left now?

[@jetha_lil3134]

maan gye guru 🙏📿

[@gangatravels3606]

Thank you sir.