WHY NORMALIZATION IS NEEDED IN DBMS? (WITH EXAMPLE)

Sdílet
Vložit
  • čas přidán 16. 07. 2019
  • In this video, we'll learn why is normalization needed in dbms. The following four anomalies are discussed in detail in the video:
    1. Insertion anomaly
    2. Deletion anomaly
    3. Updation anomaly
    ✨Work related mails can be sent on:
    work.sadiasiddiqui@gmail.com
    ✨If you appreciate my work and would like to donate to support our channel, you can do so here:
    paypal.me/sadia1702

Komentáře • 95

  • @rahimmahat0007
    @rahimmahat0007 Před 2 lety +8

    i like how simple the presentation is no editing nothing, yet short but simple. Appreciate the effort👍

  • @junaidbashir7265
    @junaidbashir7265 Před 3 lety +21

    Mom says you have a very sweet voice. Thank you for your work :)

  • @jenbac.s1858
    @jenbac.s1858 Před rokem

    Now , I got a clear, straightforward and concise explanation about the why. Thank you my dear for this great job! 🎉

  • @prasaddotcom
    @prasaddotcom Před 3 lety +24

    We studied very blindly about normalization. Now got the clear understanding about it. Good explanation mam. Please do more videos , really helpful.

  • @vysakhkailas940
    @vysakhkailas940 Před 3 lety +4

    Thank you for the amazing explanation!!

  • @MultiAmitp
    @MultiAmitp Před 4 lety +59

    never understood while studying engg.... but this is just awesome explanation......Thanks a ton

    • @adonisjosue7509
      @adonisjosue7509 Před 2 lety +3

      instaBlaster

    • @raviramesh1992
      @raviramesh1992 Před 2 lety +1

      It's not because you studied engg, its because you have not concentrated at that time, and why you could not concentrated at that time is, your brain not developed to that level, u had less knowledge on other supporting areas(simply you don't have supporting files to run that software which leads to understand SQL concepts easily) 😆😆😆

  • @equiwave80
    @equiwave80 Před 3 lety +2

    Excellent explanation. Thanks for this video!!!

  • @SibenduChakraborty
    @SibenduChakraborty Před rokem

    this is the perfect way of preparing last night before interview. subbed

  • @aniketpatil8522
    @aniketpatil8522 Před 11 měsíci

    Thanks...!
    You've clear Normalisation in very Simple way...

  • @BijayKumar-bq1wm
    @BijayKumar-bq1wm Před 3 lety +2

    Thanks for this detail explanation !!!!!!!

  • @ajuology5803
    @ajuology5803 Před 4 lety

    You explained normalisation simply...awesome....

  • @pavlos.konstantinidis
    @pavlos.konstantinidis Před 2 lety +1

    clearly explained, thank you!

  • @dudlavarumakanth4671
    @dudlavarumakanth4671 Před rokem

    ur way of explaining the concept is really good . thanks for making videos . keep making .

  • @PoojaGupta-ge7uz
    @PoojaGupta-ge7uz Před 2 lety

    Explained this concept very nicely.. Thank u

  • @dudeyt1849
    @dudeyt1849 Před 3 lety

    Great Explanation. Thanks a lot

  • @tanujkasal
    @tanujkasal Před rokem

    That was really helpful, thanks!

  • @nishantyadav681
    @nishantyadav681 Před 4 lety

    Nice Video , easily understandable, Thanks

  • @alsafagroups
    @alsafagroups Před 4 lety +1

    Simple and good explanation, Keep ON, You will have good future

  • @mihirmehta7238
    @mihirmehta7238 Před 2 lety

    Such a sweet voice really helped me to understand every single things

  • @mohdtanveer3092
    @mohdtanveer3092 Před 3 lety +2

    Thanks for sharing these videos. These really helped me in my interviews. Can you share about windows functions, pivot or unpivot?

  • @sravanambala5074
    @sravanambala5074 Před 2 lety

    Understood the concept just in five minutes which I am neglecting from years. And your voice is soooo sooo sweet....

  • @abdulrashidsinancu1630

    short and useful ..good job

  • @Vanaja.Arigala
    @Vanaja.Arigala Před 10 měsíci

    I like the way u explained. Thank you ❤

  • @ajinkyagawade7176
    @ajinkyagawade7176 Před 2 lety

    Thanks alot
    Seen dozens of videos but got it now
    Make more videos keep it up

  • @kvrathnam9835
    @kvrathnam9835 Před 3 lety

    Really nice explanation and very good presentation

  • @kolipakapavankalyan8278

    Thank you for your explanation

  • @magl1003
    @magl1003 Před 2 lety +7

    Thank you for the video. You're very good at teaching. I watched your other video when I was studying for my other test. Now, I'm back watching your video to prepare me for the final exam. Keep up the good work!

  • @anirbansarkar6306
    @anirbansarkar6306 Před 2 lety

    masterpiece. Superb explanation!!!
    Thanks a lot😇😇

  • @damodarramdoyal5890
    @damodarramdoyal5890 Před 4 měsíci

    Simple and very informative

  • @aaqibkhalique
    @aaqibkhalique Před 2 lety

    Thank you for the video ❤️

  • @arpitham8104
    @arpitham8104 Před 3 lety +2

    Please make videos and make us to understand better ....the way you teach is unbelievable 🙌💕

  • @muralikrishna-ms5xu
    @muralikrishna-ms5xu Před 3 lety +3

    Can you please upload all functions available in oracle sql including analytical function. Now a days interview panels are focusing more on this topics so need those information with example.

  • @bhargav.h.prakash3681
    @bhargav.h.prakash3681 Před 3 lety +1

    You really have nice voice mam .... thank you for teaching mam

  • @dugginenichandrababu9615

    Nice explanation !! TQ

  • @MohdKhan02
    @MohdKhan02 Před rokem

    Thanks a lot Sadia,

  • @utkarshverma9234
    @utkarshverma9234 Před 2 lety

    mam you are so good i cleared my all concepts from your videos

  • @Hdhdhdjqqlsjdndndjwjwjs

    Beautiful handwriting!!! Love from Sri Lanka 🇱🇰

  • @avinasht125
    @avinasht125 Před 4 lety

    Awsm explain Mam..

  • @anilcool7460
    @anilcool7460 Před 2 lety

    awesome explanation....thanks madam......voice is also major role

  • @mahalingappabirajdar5285

    Wow nice 👌 explanation thanks mam

  • @meghamegha4849
    @meghamegha4849 Před rokem

    Thank you mam✨

  • @patilgayatri5148
    @patilgayatri5148 Před 3 lety

    Awesome thank you so much

  • @programingwithsharad3403

    osm video everything is clear

  • @madhurinarale5523
    @madhurinarale5523 Před 2 lety +1

    Mam please explain data validation and data integrity with example and also difference between them

  • @ethio-tok2552
    @ethio-tok2552 Před rokem +1

    excellent job keep it up👍👍👍

  • @ashishshukla6099
    @ashishshukla6099 Před 3 lety

    You have a sweet voice and You explain it very well

  • @harshalchaudhari330
    @harshalchaudhari330 Před 2 lety

    best Explaination of normalization

  • @vishal-jj7bz
    @vishal-jj7bz Před 2 lety

    good explain

  • @NaveenKumar-mp6ip
    @NaveenKumar-mp6ip Před 3 lety

    Nice explanation

  • @_Shubhamkumar-gg2fw
    @_Shubhamkumar-gg2fw Před 2 lety

    Thank you mam ❤️🙏🙏

  • @tanmaychoudhari7483
    @tanmaychoudhari7483 Před 3 lety +4

    Thanks alot Sadia
    This is awesome and really helpful.
    Tables made for explanation really clarifies everything

  • @devaduttaprusti4895
    @devaduttaprusti4895 Před 2 lety

    Thank you so much

  • @rishiraghuwanshi5762
    @rishiraghuwanshi5762 Před rokem

    The foriegn key music be unique as it is against the constraint pls clarify

  • @westy153
    @westy153 Před 2 lety

    Superb madam

  • @vishwankvrai
    @vishwankvrai Před rokem

    3:42 so over here also we have to keep branch id as null ryt

  • @theloudone2752
    @theloudone2752 Před 4 lety +2

    Khub bhalo bujhlam

  • @pendelacharan4430
    @pendelacharan4430 Před 3 lety +2

    super
    I never commented on videos but today, i cant keep myself without commenting. You made the concepts very easy to understand.

  • @abhistudytech2990
    @abhistudytech2990 Před 2 lety

    Why are you add a branchid in student table

  • @barshan2504
    @barshan2504 Před 2 lety

    Good one.

  • @shivankyadav6664
    @shivankyadav6664 Před 4 lety

    Very nice mam

  • @sush970
    @sush970 Před 3 lety +3

    By voice Iam assuming she is young but conceptually very good ...👍🏼

  • @rahulkallapu4648
    @rahulkallapu4648 Před 3 lety

    Very sweet voice... Mam...

  • @shankarraj3433
    @shankarraj3433 Před 2 lety

    Thanks.

  • @mallikarjunhj8768
    @mallikarjunhj8768 Před 2 lety

    What if student opts for change of branch?

  • @sVenkatrao
    @sVenkatrao Před 2 lety

    Really very explanation
    Could you provide data science

  • @mohdtanveer3092
    @mohdtanveer3092 Před 3 lety

    Ideas for next videos :- windows function, date & ER Diagram

  • @utkarshpandey4790
    @utkarshpandey4790 Před 2 lety

    Hii, can you help me with computer networks

  • @vinilprabhas4623
    @vinilprabhas4623 Před 2 lety

    Tomorrow is my exam now iam writing slip from this video thank you so much i hope i might pass the exam

  • @praisejesus-udaysunar2441

    Your voice is so beautiful and Thank you for explaining.

  • @ImranKhan-xw2lp
    @ImranKhan-xw2lp Před 4 lety

    great

  • @itssalmanvlogs_
    @itssalmanvlogs_ Před 2 lety +2

    One of the best explanation.. Keep it up 👌

  • @iamnoob7593
    @iamnoob7593 Před rokem

    in college , i blindly read it , did not understand it properly , now in project it is required

  • @priyadhardhini3017
    @priyadhardhini3017 Před 2 lety +2

    Thank you so much this was very helpful ☺️ 😊 🙂

  • @rajuodela9472
    @rajuodela9472 Před 2 lety

    Notes vudha madam

  • @ameetd8920
    @ameetd8920 Před rokem

    If possible plz make C# tutorial

  • @siddharthsanat2977
    @siddharthsanat2977 Před 3 lety

    Where are such good teachers???? Why don't we get them

  • @dataone7170
    @dataone7170 Před rokem

    Pad pad ke thak gaya kabhi samagh nahi aaya rat ke exam mai likh aaya .....
    Per aaj Jake samagh aaya ki normalisation kyo karte hai

  • @naveenshagala3136
    @naveenshagala3136 Před 5 lety +4

    Nice and easy.
    Mam can you explain types of normalisation. That would be really helpful to crack the interviews.

  • @tituranjan7561
    @tituranjan7561 Před rokem

    🔥🔥🔥

  • @akashprajapati4595
    @akashprajapati4595 Před 2 lety

    classic!!

  • @sohamghosh2331
    @sohamghosh2331 Před 4 lety

    Need to formulate the video a bit but explanation is good../

  • @rekhao6606
    @rekhao6606 Před 2 lety

    Please post plsql videos

  • @rohanhegde108
    @rohanhegde108 Před 2 lety +1

    Noice

  • @lifetechbadi369
    @lifetechbadi369 Před 10 měsíci

    Madam

  • @birajparikh3367
    @birajparikh3367 Před 4 lety

    Hello,
    Really nice explanations, I kindly request if you can share the notes as well.

  • @twilightpaps218
    @twilightpaps218 Před 4 lety +1

    Mam , please
    Could u upload dependencies BCNF & 4NF videos ?
    ASAP

  • @AbsurdFun8793
    @AbsurdFun8793 Před 3 lety +1

    Nice voice .....nd concept cleared but not that much teach little bit slow nd use hindi in between teaching...

  • @AftabBlogger
    @AftabBlogger Před rokem

    🙏 Speak Urdu/Hindi

  • @MrJoy-dd5ts
    @MrJoy-dd5ts Před 4 lety +1

    Mam thoda thoda Hindi mai bhi samjhao. Sab samaj nehi atahai

  • @shakiraafshan6544
    @shakiraafshan6544 Před 3 lety

    Nice explanation