4.7 How to Decompose a relation into 2NF

📝 Talk to Sanchit Sir: forms.gle/WCAFSzjWHsfH7nrh9
💻 KnowledgeGate Website: www.knowledgegate.in/gate
📲 KnowledgeGate Android App: tiny.cc/KG_Official_App
➡ Do not miss our Bestseller Courses:
🔴 GATE Guidance-2025: www.knowledgegate.in/learn/GA...
🟠 GATE Guidance Plus-2025: www.knowledgegate.in/learn/GA...
➡ Contact Us:
🟩 Whatsapp Chat: wa.me/918595120657
📞Call on: [phone]
🟦 Telegram Updates: t.me/kg_gate
🟩 Whatsapp Updates: www.whatsapp.com/channel/0029...
📧 Email: [e-mail]
➡ Our One Shot Semester Exam Videos: 👇
▶ Operating System: • Complete Operating Sys...
▶ DBMS: • Complete DBMS Data Bas...
▶ Computer Network: • Complete CN Computer N...
▶ Digital Electronics: • Complete DE Digital El...
▶ Computer Architecture: • Complete COA Computer ...
▶ Data Structure: • Complete DS Data Struc...
▶ Algorithm: • Complete DAA Design an...
▶ Software Engineering: • Complete Software Engi...
▶ Theory of Computation: • Complete TOC Theory of...
▶ Compiler: • Complete CD Compiler D...
▶ Discrete Maths: • Complete DM Discrete M...
➡ Free Subject-Wise Complete PlayList: 👇
▶️ DBMS: tiny.cc/kg_yt_DBMS
▶️ Operating System: tiny.cc/kg_yt_OS
▶️ TOC|Automata: tiny.cc/kg_yt_toc
▶️ Computer Networks: tiny.cc/kg_yt_CN
▶️ Digital Electronics: tiny.cc/kg_yt_Digital
▶️ Compiler Design: tiny.cc/kg_yt_Compiler
▶️ Computer Architecture: tiny.cc/kg_yt_COA
▶️ Data Structure: tiny.cc/kg_yt_DataStructures
▶️ Algorithms: tiny.cc/kg_yt_Algorithm
▶️ Set, Relation, Function: tiny.cc/kg_yt_Discrete_Relations
▶️ Graph Theory: tiny.cc/kg_yt_graphtheory
▶️ Group Theory: tiny.cc/kg_yt_grouptheory
▶️ Proposition: tiny.cc/kg_yt_prepositions
#knowledgegate #GATE #sanchitjain
*********************************************************

[@KNOWLEDGEGATE_kg]

For complete DBMS, check out this video: ua-cam.com/video/YRnjGeQbsHQ/v-deo.html

[@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 !

[@ProudNepaliChannel]

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

[@UmangMundhara]

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

[@supriyabhide5095]

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

[@yugalsarkaar]

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

[@sarikaj7562]

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

[@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

[@abhishekjan9026]

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

[@shivaclasses1683]

Tysm sir... bahut ache se example karaye

[@arjunm.r8641]

Your class is very awesome.Thank you for this video

[@nezmika2911]

Thanks a lot !
Very much clarity!

[@alapanroy1114]

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

[@mianreyes9382]

hahahaha

[@abhinandank8725]

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

[@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👍

[@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👍

[@niteshpandey43]

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

[@triptibhardwaj9454]

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

[@shashanksaxena6189]

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

[@utsavpatel9315]

great job!! really helpful

[@sudarshanprajapati9742]

very helpful lecture....thanku sir

[@khyati7549]

Thanks a lot sir....Big help 🙌

[@sajidh4179]

Thnx sir.excellent method of teaching.

[@OmitA25]

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

[@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👍

[@TheSAWR]

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

[@nibir24]

dhanyabaad sir
it means a lot to us.

[@shivamshukla-tu2sq]

Thanks sir..for all videos.

[@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 !!

[@kondapallysaimanasa5261]

Ur explanation is really useful sir

[@colossalgaming1244]

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

[@muhammadibnwahid6405]

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

[@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 !!

[@rahulagrawal4635]

best ... Only one word to describe you.

[@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👍

[@rahilraikwar7981]

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

[@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 !

[@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👍

[@sayaksen3359]

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

[@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.

[@dinkarmehta1445]

Thanks a lot, Sir !!

[@RaviSingh-yf6jd]

Thanks sir but also upload computer network series please thanks again

[@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

[@ruchirrathore5055]

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

[@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 👍😊

[@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 !!

[@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 ?

[@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. ..

[@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👍😊

[@rakhshandamujib2793]

Duniya ke sabse achhe teacher ho aap!

[@riyavijay6487]

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

[@gopibharti4362]

Learn alot form u sir

[@___.reyan.]

you are great.

[@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 👍😊

[@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

[@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 !!

[@pavitkalra1869]

Bachaa liya aapne❤

[@mixedmashup778]

thank god i found you sir

[@gangatravels3606]

Thank you sir.

[@mohammadashfandshaikh2347]

Thank you so much sir

[@programmer1783]

thank you sir

[@yashpratapwar6490]

Thanks a lot sir🙌🙌

[@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 👍😊

[@shaifaliagarwal1749]

grt explanation sir

[@ayushmaheswari8827]

😍😍😍 loved it

[@harekrishna9587]

Awesome sir 👍👍

[@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 ?

[@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.

[@alapanroy1114]

apki voice amazing hai

[@suneelakrishna9141]

Very helpful sir

[@manishjarodia2561]

thnkyu sir

[@ChandanAkbarpuria]

Crystal clear in one shot
Thank you sir

[@KNOWLEDGEGATE_kg]

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

[@AdeshPaul]

dhanyawad

[@junaidshaikh3597]

Thank you sirg

[@shaifaliagarwal1749]

awsm explanation sir

[@KNOWLEDGEGATE_kg]

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

[@anushyasundarrajan1198]

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

[@optimistichomosapien7484]

Great explanation ❤️

[@KNOWLEDGEGATE_kg]

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

[@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

[@alokpunjsharma]

Agar 2 different subsets of Key ek same non key ko transitively le rahe hain to konse subset ke separation me us non key ko daala jaye?

[@adityapai5147]

Thank You Sir.

[@KNOWLEDGEGATE_kg]

You're most welcome dear! Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing courses & contents 👍😊

[@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.

[@rimmisidhu1308]

Thank you

[@SUMITKUMAR-eo9iu]

sir please make video with multiple c.k

[@lsuremusic3787]

Thank u sir ji

[@sadiq4933]

Lit Sir🔥🔥🔥🔥🔥

[@riya53397]

Thank you sir aapne bahut acha padaya❤

[@KNOWLEDGEGATE_kg]

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

[@WaqasAli-ev7ge]

Thanks

[@muhammadyounis7321]

Bundles of thanks Sir...

[@KNOWLEDGEGATE_kg]

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

[@anujgamer4185]

table me common attributed nahi raha to chalega kya

[@sumeetchandel9521]

sir do you offer classroom course for students

[@monikasharma1184]

Thanks sir g 🙏

[@Korosensei-vj9xb]

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

[@pihumamma7248]

ThQ Sir

[@sukanyahaque3024]

Thank you so much Sir. You made my all doubts clear

[@sumitsinghrawat7657]

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

[@jetha_lil3134]

maan gye guru
🙏📿