WHY NORMALIZATION IS NEEDED IN DBMS? (WITH EXAMPLE)

Поділитися
Вставка
  • Опубліковано 16 лип 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

КОМЕНТАРІ • 95

  • @rahimmahat0007
    @rahimmahat0007 2 роки тому +8

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

  • @MultiAmitp
    @MultiAmitp 4 роки тому +59

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

    • @adonisjosue7509
      @adonisjosue7509 2 роки тому +3

      instaBlaster

    • @raviramesh1992
      @raviramesh1992 2 роки тому +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) 😆😆😆

  • @prasaddotcom
    @prasaddotcom 3 роки тому +24

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

  • @jenbac.s1858
    @jenbac.s1858 Рік тому

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

  • @junaidbashir7265
    @junaidbashir7265 3 роки тому +21

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

  • @magl1003
    @magl1003 2 роки тому +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!

  • @dudlavarumakanth4671
    @dudlavarumakanth4671 Рік тому

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

  • @vysakhkailas940
    @vysakhkailas940 3 роки тому +4

    Thank you for the amazing explanation!!

  • @SibenduChakraborty
    @SibenduChakraborty Рік тому

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

  • @aniketpatil8522
    @aniketpatil8522 11 місяців тому

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

  • @sravanambala5074
    @sravanambala5074 2 роки тому

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

  • @equiwave80
    @equiwave80 3 роки тому +2

    Excellent explanation. Thanks for this video!!!

  • @alsafagroups
    @alsafagroups 4 роки тому +1

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

  • @ajuology5803
    @ajuology5803 4 роки тому

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

  • @mihirmehta7238
    @mihirmehta7238 2 роки тому

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

  • @arpitham8104
    @arpitham8104 3 роки тому +2

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

  • @PoojaGupta-ge7uz
    @PoojaGupta-ge7uz 2 роки тому

    Explained this concept very nicely.. Thank u

  • @BijayKumar-bq1wm
    @BijayKumar-bq1wm 4 роки тому +2

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

  • @mohdtanveer3092
    @mohdtanveer3092 3 роки тому +2

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

  • @ajinkyagawade7176
    @ajinkyagawade7176 2 роки тому

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

  • @pavlos.konstantinidis
    @pavlos.konstantinidis 2 роки тому +1

    clearly explained, thank you!

  • @tanmaychoudhari7483
    @tanmaychoudhari7483 3 роки тому +4

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

  • @bhargav.h.prakash3681
    @bhargav.h.prakash3681 3 роки тому +1

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

  • @nishantyadav681
    @nishantyadav681 4 роки тому

    Nice Video , easily understandable, Thanks

  • @Hdhdhdjqqlsjdndndjwjwjs
    @Hdhdhdjqqlsjdndndjwjwjs Рік тому

    Beautiful handwriting!!! Love from Sri Lanka 🇱🇰

  • @dudeyt1849
    @dudeyt1849 3 роки тому

    Great Explanation. Thanks a lot

  • @Vanaja.Arigala
    @Vanaja.Arigala 10 місяців тому

    I like the way u explained. Thank you ❤

  • @tanujkasal
    @tanujkasal Рік тому

    That was really helpful, thanks!

  • @utkarshverma9234
    @utkarshverma9234 2 роки тому

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

  • @kvrathnam9835
    @kvrathnam9835 3 роки тому

    Really nice explanation and very good presentation

  • @anirbansarkar6306
    @anirbansarkar6306 2 роки тому

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

  • @abdulrashidsinancu1630
    @abdulrashidsinancu1630 3 роки тому

    short and useful ..good job

  • @ashishshukla6099
    @ashishshukla6099 3 роки тому

    You have a sweet voice and You explain it very well

  • @pendelacharan4430
    @pendelacharan4430 3 роки тому +2

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

  • @kolipakapavankalyan8278
    @kolipakapavankalyan8278 2 роки тому

    Thank you for your explanation

  • @madhurinarale5523
    @madhurinarale5523 2 роки тому +1

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

  • @sush970
    @sush970 3 роки тому +3

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

  • @damodarramdoyal5890
    @damodarramdoyal5890 4 місяці тому

    Simple and very informative

  • @anilcool7460
    @anilcool7460 2 роки тому

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

  • @aaqibkhalique
    @aaqibkhalique 2 роки тому

    Thank you for the video ❤️

  • @muralikrishna-ms5xu
    @muralikrishna-ms5xu 3 роки тому +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.

  • @mahalingappabirajdar5285
    @mahalingappabirajdar5285 4 роки тому

    Wow nice 👌 explanation thanks mam

  • @avinasht125
    @avinasht125 4 роки тому

    Awsm explain Mam..

  • @harshalchaudhari330
    @harshalchaudhari330 2 роки тому

    best Explaination of normalization

  • @dugginenichandrababu9615
    @dugginenichandrababu9615 2 роки тому

    Nice explanation !! TQ

  • @MohdKhan02
    @MohdKhan02 Рік тому

    Thanks a lot Sadia,

  • @meghamegha4849
    @meghamegha4849 Рік тому

    Thank you mam✨

  • @patilgayatri5148
    @patilgayatri5148 3 роки тому

    Awesome thank you so much

  • @ethio-tok2552
    @ethio-tok2552 Рік тому +1

    excellent job keep it up👍👍👍

  • @programingwithsharad3403
    @programingwithsharad3403 2 роки тому

    osm video everything is clear

  • @NaveenKumar-mp6ip
    @NaveenKumar-mp6ip 3 роки тому

    Nice explanation

  • @mohdtanveer3092
    @mohdtanveer3092 3 роки тому

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

  • @theloudone2752
    @theloudone2752 4 роки тому +2

    Khub bhalo bujhlam

  • @vinilprabhas4623
    @vinilprabhas4623 2 роки тому

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

  • @_Shubhamkumar-gg2fw
    @_Shubhamkumar-gg2fw 2 роки тому

    Thank you mam ❤️🙏🙏

  • @praisejesus-udaysunar2441
    @praisejesus-udaysunar2441 3 роки тому +2

    Your voice is so beautiful and Thank you for explaining.

  • @CodeWithVishal-IT
    @CodeWithVishal-IT 2 роки тому

    good explain

  • @devaduttaprusti4895
    @devaduttaprusti4895 2 роки тому

    Thank you so much

  • @rahulkallapu4648
    @rahulkallapu4648 3 роки тому

    Very sweet voice... Mam...

  • @westy153
    @westy153 2 роки тому

    Superb madam

  • @itssalmanvlogs_
    @itssalmanvlogs_ 2 роки тому +2

    One of the best explanation.. Keep it up 👌

  • @shivankyadav6664
    @shivankyadav6664 4 роки тому

    Very nice mam

  • @barshan2504
    @barshan2504 2 роки тому

    Good one.

  • @sVenkatrao
    @sVenkatrao 2 роки тому

    Really very explanation
    Could you provide data science

  • @shankarraj3433
    @shankarraj3433 2 роки тому

    Thanks.

  • @priyadhardhini3017
    @priyadhardhini3017 2 роки тому +2

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

  • @iamnoob7593
    @iamnoob7593 Рік тому

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

  • @abhistudytech2990
    @abhistudytech2990 2 роки тому

    Why are you add a branchid in student table

  • @rishiraghuwanshi5762
    @rishiraghuwanshi5762 Рік тому

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

  • @naveenshagala3136
    @naveenshagala3136 5 років тому +4

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

  • @siddharthsanat2977
    @siddharthsanat2977 3 роки тому

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

  • @ImranKhan-xw2lp
    @ImranKhan-xw2lp 4 роки тому

    great

  • @mallikarjunhj8768
    @mallikarjunhj8768 2 роки тому

    What if student opts for change of branch?

  • @vishwankvrai
    @vishwankvrai Рік тому

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

  • @tituranjan7561
    @tituranjan7561 Рік тому

    🔥🔥🔥

  • @ameetd8920
    @ameetd8920 Рік тому

    If possible plz make C# tutorial

  • @akashprajapati4595
    @akashprajapati4595 3 роки тому

    classic!!

  • @utkarshpandey4790
    @utkarshpandey4790 2 роки тому

    Hii, can you help me with computer networks

  • @dataone7170
    @dataone7170 Рік тому

    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

  • @sohamghosh2331
    @sohamghosh2331 4 роки тому

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

  • @rekhao6606
    @rekhao6606 2 роки тому

    Please post plsql videos

  • @rajuodela9472
    @rajuodela9472 2 роки тому

    Notes vudha madam

  • @birajparikh3367
    @birajparikh3367 4 роки тому

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

  • @rohanhegde108
    @rohanhegde108 2 роки тому +1

    Noice

  • @lifetechbadi369
    @lifetechbadi369 10 місяців тому

    Madam

  • @AbsurdFun8793
    @AbsurdFun8793 3 роки тому +1

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

  • @twilightpaps218
    @twilightpaps218 4 роки тому +1

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

  • @AftabBlogger
    @AftabBlogger Рік тому

    🙏 Speak Urdu/Hindi

  • @MrJoy-dd5ts
    @MrJoy-dd5ts 4 роки тому +1

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

  • @shakiraafshan6544
    @shakiraafshan6544 3 роки тому

    Nice explanation