4nf normalization in database with example

Sdílet
Vložit
  • čas přidán 12. 03. 2018
  • 4nf in database with examples

Komentáře • 41

  • @rameshkumar-jp3vv
    @rameshkumar-jp3vv Před 2 lety +2

    Excellent madam my hole btech life was gained by you mam.... 😀

  • @vaishnavisherkhane745
    @vaishnavisherkhane745 Před rokem +1

    TQ soooooooooo much mam .,such a beautiful explanation in simple way 🤩...

  • @HarishArtworks
    @HarishArtworks Před 6 lety

    very nice,, mujhe sabse accha lagta hai, aap point accorongily bataate ho

  • @srinivasgubbala2726
    @srinivasgubbala2726 Před 5 lety +2

    Tanq madam for the explanation of all normal forms

  • @Ujjwalkumar-hj1hp
    @Ujjwalkumar-hj1hp Před 3 lety +1

    Thank you ma'am vey much❣️

  • @vikkydhdhdjdj
    @vikkydhdhdjdj Před 2 lety

    Thank you for everything 🥺

  • @Shiny_Services
    @Shiny_Services Před 5 lety +16

    you should just say in simple english that 4NF is at most 1 multivalue dependency, so from BCNF --> 4NF you go from many multi value dependency to 1 multivalue dependency. k thx bye

  • @snehakandekar3821
    @snehakandekar3821 Před 5 lety +1

    Thank you for all videos and full explanation of given topic..

  • @bandaruharsha2978
    @bandaruharsha2978 Před 2 lety +11

    primary key itself means no null values and no duplicates.
    But in your example there are duplicates in your keys and you say them as primary keys
    and again you say them that they violate 4nf
    how could it be possible

    • @fitengineer1716
      @fitengineer1716 Před 9 měsíci

      Yes, only student_id should be the primary key!

    • @A__GARV_SAXENA
      @A__GARV_SAXENA Před 8 měsíci

      all three columns toghter make primary key
      not single column

    • @no__one04
      @no__one04 Před 2 měsíci

      may be she referring candidate key here

  • @shivammahajan6141
    @shivammahajan6141 Před 5 lety +1

    Thankuuuuuuu mam

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

    Im from mechanical department and tomorrow is my exam thanks for your explanation mam 🙏🙏🙏

  • @triplea7071
    @triplea7071 Před 4 lety

    Marvelous

  • @AkashSingh-nh7wr
    @AkashSingh-nh7wr Před rokem

    how can possible same value in primary key

  • @nagarajannagu9750
    @nagarajannagu9750 Před 4 lety

    Thanks mam

  • @shaikhashahd2887
    @shaikhashahd2887 Před 5 lety +3

    pls include multivalued dependency video😕😕

  • @fikiremariammamo9436
    @fikiremariammamo9436 Před 5 lety

    thank you keep it up!!!!!!!!

  • @snehakandekar3821
    @snehakandekar3821 Před 5 lety +2

    Please create 5nf normalization video .

  • @ramureddys6571
    @ramureddys6571 Před 5 lety +3

    then what is diff b/w 1nf and 4nf plz rply ma'am

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

      1NF: the non-key attributes must provide information about the key or about part of the key
      2NF: a 1nf in which the secondary attributes must provide info about the whole key
      3NF: a 2nf in which the secondary attributes must provide information about nothing but the key (only about the whole key)
      4NF: this video is perfect if you don't know

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

    Ossamm

  • @ranjithrao4733
    @ranjithrao4733 Před rokem +1

    Mam can u please make a video on 5NF

  • @SandeshKarumuri
    @SandeshKarumuri Před 5 lety +2

    It's been like one to many
    Because one sid :100 is having many subjects

    • @noreddine
      @noreddine Před 4 lety

      actually, it's many subjects to one ID

  • @padmanabans9489
    @padmanabans9489 Před 6 lety +1

    Studentid is pk then how is it allows duplicate value

  • @cirahari4489
    @cirahari4489 Před 4 lety

    where is BCNF

  • @haideralijanjua8265
    @haideralijanjua8265 Před 8 měsíci

    But maam in this table stud id also same 100 100

  • @hafza.khalid8532
    @hafza.khalid8532 Před 6 měsíci

    plz make a video for BCNF and 4nf and 5nf plzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz

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

    經典:不能多於一個多值屬性。

  • @kiranhamayon737
    @kiranhamayon737 Před 2 lety

    Nail polish nice ha 😜🤮😱🖐

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

    Madam can u plss explain bcnf

  • @milanbhandari9933
    @milanbhandari9933 Před 7 měsíci

    Jpt no any good logic shown

  • @sriharshasangojh881
    @sriharshasangojh881 Před 3 lety

    The fake accent😬

    • @aryabhatt5833
      @aryabhatt5833 Před 2 měsíci

      That's not fake accent. That's natural accent. Ma'am must be a Bengali.