4.2 Basic Concept of Normalization

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

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

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

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

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

[@lazycrazy863]

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

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

[@HELL0-W0RL0]

hey....in which company u r working rn

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

[@sayantanchakraborty639]

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

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

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

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

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

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

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

[@AlphaWolfling]

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 .

[@csmazindia]

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

[@akshaymore5655]

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

[@GP-ol6mw]

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

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

[@anandsinha9692]

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

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

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

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

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

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

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

[@zubichaudhary6800]

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

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

[@nitishni30vaibhav]

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

[@omeganyirongo842]

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

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

[@Comicvishal]

Nice content sir: Normalization is a technique that is used to remove redundancy in relational table. For ex: If you a have table Student information table that contains Student branch Info and is same for all students then you can make two table one for student info and one for department info and then u can link to tables using foreign key... thus table is normalized. This what i understood....Tq sir

[@KNOWLEDGEGATE_kg]

You're welcome, keep learning👍

[@DaveAquib]

mazaa aagaya :) respect from Kashmir.

[@meershahidmanzoor]

Give this guy a medal 🥇🙆

[@kanchi8174]

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

[@PraveenSingh-no09ol]

Super video buddy really like it...it is really easy to understand, good job.

[@AbhaySingh-qk7px]

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

[@anuyadav384]

very detailed and explanatory ... much appreciated your effort ... Thanks for this much of knowledge !!!

[@srinidhich96]

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

[@mukeshsolanki4608]

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

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

[@rohitnayak4610]

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

[@sonalkarn2924]

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

[@haydo8373]

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

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

[@novastar120]

Great ho sir ji ! !! excellent work

[@harismunawar1342]

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

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

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

[@Ankushkumar-dz9np]

sir your way of explaination is awesome 👌

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

[@callum-abbas326]

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

[@adityasingh5002]

great work sir... its very helpful

[@Akvn1000]

Very well explained Sir. Awesome teacher.

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

[@saifalikhan5206]

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

[@ravisaw7492]

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

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

[@jamesdechavez7826]

your videos are the best; very good teacher

[@kalicharankhetwal]

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

[@sarikahp1067]

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

[@quratulain8496]

Great way of Explanation great work

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

[@niteshkusagar3666]

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

[@Hrefstellar]

Osm.....i watch your videos before the exams ..now iam confident....so let me pay you some little fess by clicking your add

[@priyankajoshi3687]

Your teaching is superb sir.... I honestly would like to meet you some day and study one to one from 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.

[@swaroop6044]

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

[@shivamlasiyal1795]

Wow nice teaching technique sir.

[@siddhantmeru8863]

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

[@shrutirajpoot6310]

Amazing videos things explained precise and accurate literally in minimum time possible 😎

[@jiyelaljaiswal7458]

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

[@souvikpal3746]

Sir Thanks a lot ..your videos are awesome

[@KNOWLEDGEGATE_kg]

Thank you so much brother :)

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

[@chaithanyakarkera154]

Very clear explanation :-)I will to listen to all your lecturers regarding sql. Thank you..(Y)

[@chaithranayak7537]

v helpful video.. thank u sir.upload some more

[@sumitsaini2916]

Awesome video thank you for sharing

[@CreativeWorldbyAbial]

well explained sir,may god bless you.ameen

[@sonikasingh5016]

Excellent teaching... thank you so much

[@779_faizullahkarimi8]

Thanks

[@ragivuthayakumaran3475]

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

[@Rampolice90]

Sir your explanation is awesome and I have passed in my exma by your lecture .... Thank you :-):-)

[@waqasmajeed6284]

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

[@KNOWLEDGEGATE_kg]

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

[@aditya.lakhani]

Thank you for the lecture... Really impressive and useful... Thanks

[@palashmoon3808]

nice lecture sir i understood every thing from it

[@shivamsahoo5878]

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

[@prakhartandon6672]

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

[@kalpanashah4754]

thanks a lott.really commendable work sir.

[@shubhams9156]

sahi explanation sir .. i m happy to subscribe u

[@KNOWLEDGEGATE_kg]

Thank you so much shubham :)

[@arzoomiglani8660]

Great explanation sir..

[@ravi41626devil]

Thank you so much sir🙏🙏🙏🙏

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

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

[@adilsolkar3469]

Awesome explaination sir

[@nikhilkumar8135]

best teacher 👍

[@KNOWLEDGEGATE_kg]

Thanks for you support brother :)

[@sayedasajida2665]

Thanks alot sir it helped me for my seminar