4.2 Basic Concept of Normalization

📝 Talk to Sanchit Sir: forms.gle/WCAF...
💻 KnowledgeGate Website: www.knowledgeg...
📲 KnowledgeGate Android App: tiny.cc/KG_Offi...
➡ Do not miss our Bestseller Courses:
🔴 GATE Guidance-2025: www.knowledgeg...
🟠 GATE Guidance Plus-2025: www.knowledgeg...
➡ Contact Us:
🟩 Whatsapp Chat: wa.me/91859512...
📞Call on: [phone]
🟦 Telegram Updates: t.me/kg_gate
🟩 Whatsapp Updates: www.whatsapp.c...
📧 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_D...
▶️ Compiler Design: tiny.cc/kg_yt_C...
▶️ Computer Architecture: tiny.cc/kg_yt_COA
▶️ Data Structure: tiny.cc/kg_yt_D...
▶️ Algorithms: tiny.cc/kg_yt_A...
▶️ Set, Relation, Function: tiny.cc/kg_yt_D...
▶️ Graph Theory: tiny.cc/kg_yt_g...
▶️ Group Theory: tiny.cc/kg_yt_g...
▶️ Proposition: tiny.cc/kg_yt_p...
#knowledgegate #GATE #sanchitjain
*********************************************************

[@KNOWLEDGEGATE_kg]

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

[@SiddharthMaurya7]

46 dislikes! Why would any one do that?! Way better explanation than professor at my university!

[@KNOWLEDGEGATE_kg]

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

[@harshitjain8823]

This is my first youtube comment as this time I can't help thanking you for this. You are an amazing teacher, who actually knows how to teach. Even most of our IIT professors don't teach as good as that. And you never make me feel bored sir, your little jokes always makes me smile :D p.s. you have a killer smile too.

[@kartikchauhan5498]

Sir, you're too awesome... I'm having my university exam tomorrow n ur well-organized n well-explanatory lectures are working perfectly for me...

[@akashvlogs1329]

Kartik Chauhan same here

[@SUBRONEEL]

"A paragraph denotes a single idea, when the idea change the writer changes the paragraph"- You are just tooo awesome brother. I wish you had lectures on whole modules on CS Subjects for GATE and NET. your lectures are best ,I have seen so many online lectures but you are by far the best.

[@harshadkoravi7520]

Come back to your videos after almost 3 years ,watched your videos in 2 nd year, now watching again for quick revision as I have interview tomorrow ❤️

[@KNOWLEDGEGATE_kg]

Thanks Harshad.. All the best for your interview 👍👍👍 Keep learning & supporting !!

[@harpreetv761]

Sir maine apke method se yha rural area main normalization teach kiya.. unko bhut pasand aya.. thanks sir.. jese khte he zindagi main agar ache teacher ho toh students pkka success hote he.. aap meri life main sabse ache teacher lge.. sir agar mera nta clear ho gya.. i ll support you sir.. abhi mera income itna nhi he.. but i ll .

[@manobhavjain6245]

I purposely disabled by ad blocker refreshed the page and clicked on the ad to support you. Thank you so much for such lucid explanations. I am preparing now for my placements, i wish these videos were there when i was taking the dbms course. Would recommend this to all my juniors. Keep going :-)

[@akhiljain561]

Awesome teacher. He is a good teacher than what we have in several coachings. Sir! Salute to you and your knowledge.

[@cRAYonhere]

You Sir, Are Legendary ! Kudos to you. -From Sydney

[@niteshsingh7157]

Sir can you help me in my obe exam please reply

[@asliAshutosh]

Thanks for your efforts sir, we can feel the effort in your voice thanks

[@KNOWLEDGEGATE_kg]

So nice of you, Please review our new app tiny.cc/yt_KgApp😃

[@shadabsiddiqui28]

I love you brother U r a great teacher Allah apko duniya aakherat ki kher ata fermay Bht achcha kam kr rhe hn aap jinke pass. Coaching k paise nhi hn unko padha kr... Thankyou so much

[@sayantanchakraborty639]

you are great. and awesome... i didnt know anything beffore today. and from today i have become a master..

[@shatakshisharma4084]

Sir i didnt know even about dbms......and even computer sciences were far apart from me......as i am from non computer background but just because of you i am enjoying dbms.....i had no idea about it......i dont know any language about computer.....but want to be a data analysist ....normalization is very much clear to me just beacause of you.....if possible please upload videos on query........not able to understand query from anywhere else .

[@hazrathamza25]

Great Sir. :) Let me Click an ad for you.

[@bhumikagupta1268]

Awwwwwww this is the sweetest comment I've ever come across :')

[@salmananjum-thestoryteller1515]

Your Awwwwwww was aweome as well :D

[@Arjun8BPCracker]

pad le bhai tu

[@MeetYourArchitect]

bhai ek hi baar click krio.... kaheen josh mei aake uska account ban karwade

[@rickywastaken]

itni mat chaato.

[@yolodude17]

When your teacher is so shit that you have to go to KZbin to learn. Anyways great video man. Learned more in 1 hour from you than i did from my teacher for 3 months

[@jackfrost8969]

relatable

[@AbhishekPandey-yb8fe]

What Ultrainstict Doing Here??

[@jackfrost8969]

@@AbhishekPandey-yb8fe it's Goku black, you idiot. He ain't got no ultrainstinct.

[@kumarramesh46]

What a AWeSomeee explanation Sir ji :-) .. maza aa gaya.. Aap hindi mein bolte ho to aur acha lagta hai... Beautiful explanation in a very simple way.. :-) which helped me understand better.. thanks .

[@lazycrazy863]

What a clear concept about normalization.. Keep it up sir... Keep teaching.. I ll keep learning ☺️☺️

[@akshaymore5655]

This is the only one and the best video series to learn normalization

[@rutikkansare9574]

Sir ur explanation cleared all my doubts and ur explanation was simple to understand , thank you very much

[@KNOWLEDGEGATE_kg]

Hi buddy, we are glad that we could be helpful :)

[@smritigupta821]

Your lectures are really helpful. Thank you so much sir!!

[@niteshsingh7157]

Didi can you help me in my obe exam i am too weak in dbms

[@GP-ol6mw]

Good work ..your work is really good. clearly reflects hard work you put in making video

[@anandsinha9692]

aap masiha ho bahot logon ke .... Thank You

[@florencegeorge335]

i could'nt stop myself from writing this comment ! this was one of the best dbms lecture i ever had, class mai mam samjhati rahi, it all went over my head finally kuch (sab) samajh aaya thanks a lot sir . i appreciate your work

[@csmazindia]

Excellent explanation....I hope it is helpful for every people who really wants to know the concepts.....My best wishes with you...Thanks..

[@MohdRashid-hi7cp]

Thanks a lot....sir your way of teaching is very easy and more understandable...... many people have commented on your little mistake already..... I know, it happens sometimes, but I appreciate you very much, over all you are very good. Wish you all the best and keep going....

[@harshalchaudhariflute1832]

Thank you sir I just completed DBMS in one day because of your videos for my university exam. once again thanks alot

[@KNOWLEDGEGATE_kg]

All the best !! visit www.knowledgegate.in for more courses and content !!

[@ash_engineering]

please upload MVD , 4NF and 5NF videos also .. your explanation are really very easy to comprehend, and I really dont understand these topics at all. I am preparing for GATE 2017

[@ash_engineering]

thank you sir..

[@ranjithkanaralliprasanna2141]

One of the best lecture i saw in my life on DBMS!!! Thank you so much!!!Keep your excitment of the way you teach :)Thank you once again !!!

[@NeelakanthaRaoP]

Thankyou Sir for making it soo simple ! please do upload videos on lossless decomposition and lossy decomposition in Normalisation. This is important in NET exam.

[@KNOWLEDGEGATE_kg]

Hi Neelakantha, Thank you so much for showing your interest, We'll try to cover all the topics as soon as possible. Please subscribe this channel for regular updates.

[@premshankar5967]

sir you are grate. The way in which you teach the concept is amazing. thank you sir. I am learning a lot from your lectures which makes me some what different from others.

[@ArpanDasS]

A little correction on insertion anomalies: You cannot insert branch info only, you have to insert a student info too which is not logically correct. Where, for a new branch, this situation exists. Otherwise, nice video :)

[@mr.unique7689]

thanks you sir......you explation is clear and awsome...students are no need to force to gain concept...very little attention is enough to understand...

[@sravaniharish3898]

Ur explanation was awsome..how simply u explained by taking small example.. anyone can understand easily irrespective of branch...thank you so much sir..🙏🙏🙏

[@rohitnayak4610]

Sir aapka explain krne ka tarika bahut acha lga dil s dhanyawad

[@learnenglishwithhindi7737]

Sir u have a great gift from god to teach people and I know your experience is going to be amazing and unbelievable so be happy and upload ur videos and we will always be ur online student☺️☺️

[@swaroop6044]

My exam is on tomorrow and ur all videos helped me a lot, thx sir

[@jibanmondal6823]

Thank You Sir for your videos, its help me lot. God may bless you.

[@KNOWLEDGEGATE_kg]

Hi Jiban, we truly appreciate your kind words for our efforts.We upload more topics every week, Please subscribe this channel for best GATE tutorials. :)

[@souvikpal3746]

Sir Thanks a lot ..your videos are awesome

[@KNOWLEDGEGATE_kg]

Thank you so much brother :)

[@shivendraverma9506]

outstanding....sir i have seen your all videos it helps me a lot :) now came to know what real DBMS is and its fun learning

[@kanchi8174]

Very useful video. Thank you and keep uploading these videos. Very clearly explained. :)

[@purvidevmurari5252]

Hello Sanchit sir, understood the basics for the normalization i.e functional dependencies and from that closure set of attributes...was awesome. pls upload the video containing all types of normalization soon.

[@AbhaySingh-qk7px]

God bless you sir ❤ you're great and thanks for teaching us

[@DaveAquib]

mazaa aagaya :) respect from Kashmir.

[@saikirankorri2180]

thank you very much sir ... because of u i understood funcational dependncy perfectly

[@KNOWLEDGEGATE_kg]

Hi Sai Kiran, we truly appreciate your kind words for our efforts.We upload more topics every week, Please subscribe this channel for best GATE tutorials. :)

[@sunnyjain630]

What a great explanation!! It clears all my doubts regarding topic...Thanking You Sir.....

[@KNOWLEDGEGATE_kg]

Always a pleasure :)We are glad that we could be helpful :)

[@zubichaudhary6800]

m really appriciate your teaching power nd your comunication skills ....thats owsome

[@omeganyirongo842]

Let me subscribe. .this guy is excellent 👌thank you again and again

[@speakup2888]

Great Great Great Job. I appreciate your hard work. Just a small request, keep the whole lecture in English so everybody can understand. Thank You!

[@adams8849]

Very nicely explained, in a simple manner. Please do similar videos on Big Data.

[@KNOWLEDGEGATE_kg]

we shall. :) :) Please subscribe this channel to get regular updates.

[@jamesdechavez7826]

your videos are the best; very good teacher

[@mukeshsolanki4608]

superb video sir.... thank-you for ur priceless effort!!

[@harismunawar1342]

You are AWESOME, the way you explain and the flow of information is so smooth. I got a complete understanding. Respect from Pakistan :)

[@nitishni30vaibhav]

sir u are too osm...the way u deliver the lecture its suprb...now i can even teach my friends too..

[@sahilsharma7013]

Sir please make videos on computer architecture

[@vimalkumardubey6834]

Thank you sir for this course !!❤️

[@KNOWLEDGEGATE_kg]

Most welcome! Keep learning & supporting! Do visit our website www.knowledgegate.in for more amazing contents & complete courses 👍😊

[@niteshkusagar3666]

Very nice lecture, sir .Hats off to u brother !

[@callum-abbas326]

i just passed my OS course only with your lectures now DBMS (Same condition) Thank uuuuuuuuuuuuuuu

[@user-qy6xs7xz2u]

best teacher. thanku sir.

[@KNOWLEDGEGATE_kg]

Thank you for the kind words @Aisha😍 Keep learning & stay connected👍

[@priyankajoshi3687]

Your teaching is superb sir.... I honestly would like to meet you some day and study one to one from you.

[@reddyhonnalli6433]

hi sir ..ur explanation is too gud ..i understand the normalization topic very well..plz upload more video

[@KNOWLEDGEGATE_kg]

Hi Buddy, thank you so much for showing gratitude towards our efforts, we will upload more videos soon. Please subscribe our channel for regular updates .

[@vaishnavidhobale8130]

thank u so much sir aap yek perfect teacher ho

[@sonikasingh5016]

Excellent teaching... thank you so much

[@779_faizullahkarimi8]

Thanks

[@mariadas4344]

sir ,your videos are really helpful..please try to upload all the normal forms asap...and also make video on problems of relational calculus

[@haydo8373]

I understand this content better than my English lecturer even though this is partly in Hindu. Thanks.

[@sandeepankamley7990]

The explanation was very clear, specially on anomalies on un-normalized table. Would have been better if he had used Student_ID (as Primary Key on the first table) instead roll number which would be foreign key to the branch table (instead Branch code)

[@ravisaw7492]

Your video helps us a lot Sir, please tell us something about the denormalization and upload its video.

[@meershahidmanzoor]

Give this guy a medal 🥇🙆

[@sonalkarn2924]

This is seriously Awesome..... made me understand the topic really well

[@kalicharankhetwal]

best teacher i have ever seen on youtube...(Y)

[@meaningoflifewithkavi]

Brilliant. Brilliant. Brilliant.

[@lalitasethi8372]

best teacher ever thankyou

[@chandrashekarr1977]

Looks good. It would be better if we get English version.

[@sarikahp1067]

really KG videos super........thank you so much sir

[@siddhantmeru8863]

Well Explained....... Great Sir.

[@Akvn1000]

Very well explained Sir. Awesome teacher.

[@kalpanashah4754]

thanks a lott.really commendable work sir.

[@shivamsahoo5878]

Sir everything is good,and it can be best if u attach some notes with ur videos....

[@waqasmajeed6284]

God bless you sir, this video help me a lot.

[@KNOWLEDGEGATE_kg]

we are glad that our videos could be helpful. :)

[@callmesenpai02]

Sir, I have a question. How can you make the branch_id of second table as the foreign key of the branch_id in first table when the branch_id in first table isn't really the primary key of the table. The actual primary key was student's roll no., but you didn't mention that.

[@srinidhich96]

Very nice lectures sir good explanation.....😊

[@ritikrajtakehelp2094]

Sir u are best teacher.....

[@mamachinmayeemaharana5367]

I can't find the video of indexing...I understood rest all very well by watching your all videos..I need video of indexing in DBMS.pls share it.i am waiting for that video.

[@KNOWLEDGEGATE_kg]

Hi Buddy, Thank you so much for showing your interest, We are working on INDEXING. Please subscribe our channel to follow all updates. :)

[@shivamlasiyal1795]

Wow nice teaching technique sir.

[@nikunjgarg7898]

very useful videos sir, thanku sir

[@innocentprince6604]

Thank you sir for uploading great informative videos.plz upload some videos about data structure like linked list insertion and deletion and data structure basic thanks.

[@KNOWLEDGEGATE_kg]

Hi Prince, Thank you so much for showing your interest, We'll try to cover all the topics as soon as possible. Please subscribe this channel for regular updates.

[@quratulain8496]

Great way of Explanation great work

[@debanjansinha3750]

Sir the way u teach is just brilliant keep posting videos and please upload some videos on tuple relation calculus and domain relational calculus ...

[@niteshsingh7157]

Sir can you help me in my obe exam please reply

[@adityasingh5002]

great work sir... its very helpful

[@swetasingh9890]

hii sir, you said that u discuss lst no sum in next video which is come in 2013 and ans is 4. bdw i like ur way to talking nd discuss al d topc in easier manner.. i hope u reply my comment..

[@athirakurup7814]

Very informative

[@sahilnagar1619]

sir please upload a video on loosless decomposition

[@shivamsrivastava5140]

Sir in your example as you say that br_Id is a primary key but can we also say a br_Id a foreign key in first table after breaking the complete table.

[@prakhartandon6672]

thnks bro! im short of words to appreciate u!!

[@rajdave7357]

Thanks a lot sir, you are awesome

[@KNOWLEDGEGATE_kg]

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

[@saifalikhan5206]

hats off to u sir...u are doing so much efforts to teach us

[@jiyelaljaiswal7458]

Superb Man ... I was looking for this since long

[@palashmoon3808]

nice lecture sir i understood every thing from it

[@ragivuthayakumaran3475]

this is great video sir, I wish all the very best teaching skill is all about performing. you did well