How to do database normalization

In this video, Kaustubh Joshi talks about how to normalize RDBMS tables up to 3NF.
1:23 - Need for Normalization
8:20 - 1NF (First Normal Form)
12:47 - 2NF (Second Normal Form)
19:07 - 3NF (Third Normal Form)
C programming series (pointers, functions, and DMA):
• Introduction to Pointe...
C++ programming concepts series:
• Reference in C++ (Epis...

Пікірлер: 357

  • @kalMHe
    @kalMHe4 жыл бұрын

    OMG.. you taught me a lot here, but the Mortgage Freeman part killed me man ! I hope Mortgage Freeman watches this video !

  • @WilliamOrgan
    @WilliamOrgan5 жыл бұрын

    Like this is straight up amazing! I sat through lectures on this topic given by a bad lecturer thinking I was a moron for not getting it. Watched a 20 minute video by this legend of a man, and it's like someone turned a light on in my brain for how we normalize, and why. You just earned yourself a sub!

  • @ghulamhassanhassani8465

    @ghulamhassanhassani8465

    4 жыл бұрын

    William Organ, I cannot be more agree with you

  • @victherocker

    @victherocker

    7 ай бұрын

    Good students aren't just good on their own. Half of their results come from good teachers like this.

  • @SHOAIBKHAN622
    @SHOAIBKHAN6226 жыл бұрын

    What I like about your videos is you make things so easier and explain technical things in simple words.

  • @shanilkakuruppu4932
    @shanilkakuruppu49325 жыл бұрын

    One of the simplest videos to understand database form normalisation. Thanking you, all the way from Sri Lanka.

  • @jennylenesmith-drayton8677
    @jennylenesmith-drayton86775 жыл бұрын

    I have looked through lots of material on NORMALIZATION and this has been the **BEST** explanation. Great Job!!!

  • @dakneedeeder
    @dakneedeeder6 жыл бұрын

    Thanks for this great video. The names are hysterical. Concise explanation of normal forms.

  • @foggianism

    @foggianism

    5 жыл бұрын

    Bread Pith is my favorite.

  • @mcjb73
    @mcjb732 жыл бұрын

    I have never had someone explain something to me that was as clear as this presenter did! Excellent job! Now I would like to see how to move a database into the next forms! But only by this guy..absolutely amazing!

  • @maclife1321
    @maclife13215 жыл бұрын

    literally after going through 4 other videos from different people explaining Normalization, you got the best explanation thanks man keep it up.

  • @walimorris2406
    @walimorris24064 жыл бұрын

    Literally the BEST video on RD normalization! In 21+ mins you broke this process from bottom - up. You went over the small details, where does the primary key come from, what is CUD anomalies and how to satisfy 1NF++. You answered al our questions, the reason we came here. They say you truly know something when you can explain it in a very simple way, given this is not rocket science and is capable of explaining in simple ways, you sir have accomplished that! Thankyou! P.S Thanks for adding the subtitles!

  • @chikangeng7208
    @chikangeng72084 жыл бұрын

    Thank you for explaining. Only 20 minute and I master 0NF to 3NF already! Thank you so much!

  • @chauharyfaisal1616
    @chauharyfaisal16165 жыл бұрын

    Before this lecture, many teachers guided me how to normalize the data. But this lecture is awesome. My all concepts about normalization are cleared in just half an hour. Excellent And Great Teacher. Thank you so much!

  • @breakpoint6752
    @breakpoint6752 Жыл бұрын

    I had seen many videos on Normalization before this and still was not confident on the concept. Loved the simplicity with which the concepts were covered. Confident and satisfied :)

  • @mihlalisixolo6240
    @mihlalisixolo62402 ай бұрын

    straight to the point. I am studying database introduction as one of my modules and this video helped alot

  • @imadkhan7420
    @imadkhan74204 ай бұрын

    Watched many videos on this topic, this is by far one of the better if not the best one! Much appreciated.

  • @BDagys
    @BDagys6 жыл бұрын

    RIP Gori Diamond 1967 - 2017

  • @swapnilnair3342

    @swapnilnair3342

    6 жыл бұрын

    ?

  • @chamelion100

    @chamelion100

    6 жыл бұрын

    hahaha.....he could say...he got transfer or left the company...........but he killed him :)

  • @shaunonmt

    @shaunonmt

    5 жыл бұрын

    He sent Morgage Freeman to the moon.

  • @ghme4421

    @ghme4421

    4 жыл бұрын

    ROFL LMAO... Yes, He killed GORI Diamond... That's homicide...

  • @rodanm

    @rodanm

    4 жыл бұрын

    @@shaunonmt betterrr

  • @ummemarzinajotey7616
    @ummemarzinajotey76164 жыл бұрын

    Don't know how to thank you! U made it understandable in 21 min which my professor couldn't do in 3 hrs.. make more videos like this. God bless u!!

  • @StarGEntertainment
    @StarGEntertainment5 жыл бұрын

    after 2 years at collage not understand normalization, but i was able to put my tables into the 3nf (i know its werd). i was final able to understand normalization perfectly. this video saved my life as its the best one out of all the normalization videos ive watched, thank you so much

  • @sandramaniscalco4887
    @sandramaniscalco48875 жыл бұрын

    This was a very helpful video. I had been reading through a lot of material prior to this and it just was not making sense to me. Your explanation cleared up all my confusion! Thank you!!!

  • @aidangasim
    @aidangasim3 жыл бұрын

    tons of people clarified it on youtube but noone did like you,big respect thank you Man!!!!!

  • @avinashkumar6327
    @avinashkumar63276 жыл бұрын

    ONE OF THE BEST EXPLANATION OF NORMALIZATION I CAME THROUGH ON KZread.........

  • @bralabala
    @bralabala2 жыл бұрын

    to think this video was made in 2017 and it made the most impact to my understanding of the subject in 2022. thank you.

  • @yuvrajoberoi7834
    @yuvrajoberoi78343 жыл бұрын

    You have explained this really well. All other youtubers are just giving examples with those arrows and relations etc. but you took a real world example and explained it.

  • @BBarters

    @BBarters

    3 жыл бұрын

    Thank you for your kind words.

  • @KMFDM_Kid2000
    @KMFDM_Kid20002 жыл бұрын

    This man is an excellent teacher. Thanks for the lesson.

  • @aaliquegrahame7957
    @aaliquegrahame79574 жыл бұрын

    Shoutout Mortgage Freeman lmao

  • @michaelbartnicki9464

    @michaelbartnicki9464

    4 жыл бұрын

    Hey man don't forget about Bread Pith!

  • @ParadiseBiker

    @ParadiseBiker

    4 жыл бұрын

    For sure, LOooOL!

  • @justjase10

    @justjase10

    2 жыл бұрын

    Was he referencing the Boondocks😂, as in Morgan Jebediah Freeman?

  • @chq012
    @chq012 Жыл бұрын

    Your teaching style is amazing and your wealth of knowledge on the subject is incredible. Very well explained. Thank you.

  • @investigate3_11
    @investigate3_115 жыл бұрын

    This video is fantastic. I thought he genuinely didn't know how to pronounce those names but then I saw him doing the same with Indian names so I'm sure he's just messing with us. This video had me in stitches at times! Also, more importantly, I've gotten a good overview of what normalisation means. Thanks, man!

  • @brandenvs
    @brandenvs6 жыл бұрын

    This really helped ! You dont rush through things and very easy to listen to.

  • @BBarters

    @BBarters

    6 жыл бұрын

    Thanks a ton Branden for your kind words.

  • @sangwaemmanuel6936
    @sangwaemmanuel69366 жыл бұрын

    this is a super video explaining Third normal form, easy and straight forward, thanks

  • @andreakarlvassallo2950
    @andreakarlvassallo29506 жыл бұрын

    Great teacher. Simply explained.

  • @riyagoswami4925
    @riyagoswami49254 жыл бұрын

    6 Feb 2020: Before watching this video, I was clear with most of the normalization process. Still I was making occasional mistakes. The part of your video that helped me a lot is : To find out if the non-key columns are dependent on primary key, ask this question, does that non-key column describe what the primary key identifies? If the answer is "no", that information should not be in that column. Thank you very much :)

  • @DayeetaDasdona2012
    @DayeetaDasdona20124 жыл бұрын

    Brilliant video. Thank you so much for the wonderful explanation.

  • @AKASHSHARMA-uo4dj
    @AKASHSHARMA-uo4dj6 жыл бұрын

    THE BEST EXPLANATION OF NORMALIZATION ON KZread. HATS OFF MATE!!!! (:

  • @fahimkffs
    @fahimkffs6 жыл бұрын

    Really Best Teaching Methodology - Great Work

  • @edwardleonard5274
    @edwardleonard52745 жыл бұрын

    This was an awesome and well explained video. Thanks so much!

  • @bogdanvidrean4728
    @bogdanvidrean47286 жыл бұрын

    Amazing lecture! The best so far on youtube on this subject.Also I appericate the good English accent.It was a pleasure to watch it!

  • @shaunpoursoltan1922
    @shaunpoursoltan19226 жыл бұрын

    one of the best explanations

  • @pradeepasivanesan
    @pradeepasivanesan4 жыл бұрын

    You explained it very clearly. Thank you so much

  • @sadam_khan
    @sadam_khan2 жыл бұрын

    such a good communicator. good explanation.

  • @love-hammer
    @love-hammer6 жыл бұрын

    Fantastic explanation and the time markers are really helpful as well.

  • @azharmangat165
    @azharmangat1656 жыл бұрын

    Execellent explaination of normalization in a very simple way....thank you soo much sir

  • @krishansharma7145
    @krishansharma71455 жыл бұрын

    Great Teacher to learn even for P.hd candidates.

  • @sunilsahu9858
    @sunilsahu98586 жыл бұрын

    One of the best explanation. Good work.

  • @radio1100
    @radio11006 жыл бұрын

    Very great explanations. I learned the essentials of good relational database design...

  • @najeebullah6276
    @najeebullah62766 жыл бұрын

    Well done Sir thanks a lot to explaining all forms by one complete example. keep it up GOD BLESS YOU

  • @shreyadiwate4005
    @shreyadiwate40056 жыл бұрын

    It helps a lot.Data normalization done in DBMS project efficiently. Thank you.

  • @BBarters

    @BBarters

    6 жыл бұрын

    Thanks a lot for your kind words Shreya.

  • @BrackersProductions1
    @BrackersProductions16 жыл бұрын

    Great video, was entertaining with concise and simple explanations.

  • @jobdoliguez7803
    @jobdoliguez78036 жыл бұрын

    thank you very much sir of your tutorials it helps all computer related courses anywhere in the country keep it up sir i hope you wont stop uploading videos

  • @aliciavasquezspiritu
    @aliciavasquezspiritu4 жыл бұрын

    I'm officialy in love with you! jaja great explanation!

  • @arnodolisandro
    @arnodolisandro Жыл бұрын

    Amazing video, better than my teacher! You guys are amazing!!! Keep it up!

  • @pradeepsawant2604
    @pradeepsawant26046 жыл бұрын

    Thanks buddy.. I like a lot ur video. Happy to watch again new videos too.

  • @ZiadACM
    @ZiadACM2 жыл бұрын

    this 21 min video is worth months of study, your explanation is fantastic and very clear, i have also watched you "how to draw ER diagram" video and it was as good and i heavily recommend everyone to watch it, thank you Mr Kaustubh Joshi for providing all of these nice videos to us for free!

  • @BBarters

    @BBarters

    2 жыл бұрын

    Glad it was helpful! Thank you for your kind remarks.

  • @SirShadowKnight1
    @SirShadowKnight16 жыл бұрын

    Absolutely fantastic!! Great explanation!

  • @sunnysunde3495
    @sunnysunde34955 жыл бұрын

    That is one handsome teacher! Thank you for the lessons.

  • @avien9068
    @avien9068 Жыл бұрын

    Fantastic video. Thank you from Australia :)

  • @jennylenesmith-drayton8677
    @jennylenesmith-drayton86775 жыл бұрын

    Excellent presentation! I understand it completely...

  • @Sakshi_suman16
    @Sakshi_suman166 ай бұрын

    best video ever thanks from Australia😃

  • @michalroesler
    @michalroesler3 жыл бұрын

    Great Video. A lot of information served clearly.

  • @ranishadas7116
    @ranishadas71166 жыл бұрын

    Best concept explanation ever 💜

  • @hamzahahmad1670
    @hamzahahmad16705 жыл бұрын

    I just noticed, you typed the subtitles for this video yourself, right? Dedication, right there. Great video.

  • @garyjohnston2777
    @garyjohnston27772 жыл бұрын

    Great Video, thankyou so much and keep uploading great educational content

  • @kartiknand4357
    @kartiknand43576 жыл бұрын

    I actually wanted the video to explain about the BCNF (Boyce Codd Normal Form) which comes before the 4NF. The video shows a thorough explanation of the concepts, thank you so much.

  • @kartiknand4357

    @kartiknand4357

    6 жыл бұрын

    At around 13:49 of the video, he said that if a customer is removed from its table, the agent will not be affected. My question is, what if the Primary Key of the Agent table is a Foreign Key in Customer table and Referential Integrity is enforced and Cascade Update and Delete Related Fields and Records is checked in the Relationship, will it affect the Agent's table in any way?

  • @arpitaupadhyay5531
    @arpitaupadhyay55316 жыл бұрын

    Such easy explanation . Thankyou 😊

  • @AbolfazlNasseri
    @AbolfazlNasseri5 жыл бұрын

    Excellent explanation... I learned a lot. Thanks!

  • @MrRabindransharma
    @MrRabindransharma4 жыл бұрын

    Very well explained! I liked your way of teaching. It is indeed a very nice explanation. Keep it up.

  • @deepthiramana
    @deepthiramana6 жыл бұрын

    Tq brother, you have helped me clear my exam

  • @deanl2k12
    @deanl2k125 жыл бұрын

    Hey, Dean From Ireland. My database lecture is not good a teaching in general. I thought I was screwed for my summer exams until I came across this. Thanks you

  • @aaronartha4958
    @aaronartha49584 жыл бұрын

    Excellent explanation, thank you

  • @Sssaann
    @Sssaann6 жыл бұрын

    Very good explanation

  • @shreyashachoudhary480
    @shreyashachoudhary480 Жыл бұрын

    Really intuitive explanation! Thanks

  • @abhisheksrivastava877
    @abhisheksrivastava8776 жыл бұрын

    Great Explanation Man. Simply Great.

  • @ibrahimal-mahfooz8737
    @ibrahimal-mahfooz87374 жыл бұрын

    One of the best on KZread. Thank you.

  • @BBarters

    @BBarters

    4 жыл бұрын

    Glad you think so!

  • @StudentChambers
    @StudentChambers6 жыл бұрын

    This is a great video, keep up the good work.

  • @nischalbohara4135
    @nischalbohara41356 жыл бұрын

    Thank you Sir. I appreciate your hard work 👍.

  • @Josmi_K_J
    @Josmi_K_J Жыл бұрын

    Nice video sir.. Able to understand the concept 👍🏻

  • @yasaraperera5010
    @yasaraperera50104 жыл бұрын

    thank you very much for the video it really helped me to understand normalization

  • @ifririchahazarika6224
    @ifririchahazarika62246 жыл бұрын

    Too handsome and obviously very smart and helpful. Literally loved it.

  • @mohdimaduddinyusof8358
    @mohdimaduddinyusof83586 жыл бұрын

    Excellent and clear explanation..!!

  • @taufiqsafi5569
    @taufiqsafi55696 жыл бұрын

    Thanks a lot for such a great lectures u r the best tutor

  • @alphacoder3822
    @alphacoder38223 жыл бұрын

    1 hr Nptel and 2 hrs of my university class couldnt make me understand this topic but your videos made me understand everything.

  • @BBarters

    @BBarters

    3 жыл бұрын

    I am glad that it was useful !

  • @manjunathreddy7605
    @manjunathreddy76056 жыл бұрын

    Great Teaching!!!simple Explanation ..

  • @tubeexplorer7595
    @tubeexplorer75956 жыл бұрын

    Morgan freeman to Mortgage freeman was funny i couldn't stop cracking but Sir you are doin' a great job!

  • @arsalanuljamil6840
    @arsalanuljamil68406 жыл бұрын

    Excellent video. Very well explained.

  • @vsubbu21
    @vsubbu215 жыл бұрын

    Awesome Video. Clean narrative

  • @SuperBenayoun
    @SuperBenayoun Жыл бұрын

    Amazing explanation sir..!

  • @anilmenariya2733
    @anilmenariya27336 жыл бұрын

    Very well explained. Thank you.

  • @KARTHIKPANCH97
    @KARTHIKPANCH976 жыл бұрын

    excellent work bro!! keep making more vidoes really helps a ton

  • @RajKumar-zu5nj
    @RajKumar-zu5nj4 жыл бұрын

    Very funny video, full of comedy...I have started to watch very seriously but couldn't stop laughing so much..

  • @prathameshmahankal4180
    @prathameshmahankal41804 жыл бұрын

    Wonderful explanation!

  • @mr.mustache4743
    @mr.mustache47433 жыл бұрын

    Amazing teacher, great job sir. Thank you for making this accessible and easier to understand =]

  • @BBarters

    @BBarters

    3 жыл бұрын

    You're very welcome! Thanks

  • @increpf1
    @increpf14 жыл бұрын

    Correct and to the point. Thank you!

  • @drkenny7928
    @drkenny79282 жыл бұрын

    Amazing explanation

  • @chamelion100
    @chamelion1006 жыл бұрын

    Thanks a lot for such a wonderful explanation

  • @adamwallace9702
    @adamwallace97023 жыл бұрын

    This was an excellent description. thankyou!

  • @BBarters

    @BBarters

    3 жыл бұрын

    Glad it was helpful!

  • @greatguy928
    @greatguy9286 жыл бұрын

    Great way of explaining

  • @artywealchipendo9632
    @artywealchipendo96326 жыл бұрын

    real nice stuff. Thank you Mr sir

  • @madmaxonliner
    @madmaxonliner5 жыл бұрын

    Good job, man! Nice explanation.

  • @nharalhashemi7484
    @nharalhashemi74844 жыл бұрын

    Thank you. Very clear explanation

  • @ezepauline6229
    @ezepauline62294 жыл бұрын

    So amazing. All my confusions on this specific topic has just been cleared. So simple and direct to understand. Thank you so much. Subscribe

  • @sarzfredie2400
    @sarzfredie24006 жыл бұрын

    Excellently explained...thanks

  • @jennylenesmith-drayton8677
    @jennylenesmith-drayton86775 жыл бұрын

    Brilliant explanation!!