7 thoughts on “Second Normal Form (2NF)

  1. Anonymous

    Thank you for your simple and clear examples. Studied this in college a long time ago, this is a good refresher.

    Reply
    1. admin Post author

      Thanks Swapna for your valuable feedback… Hoping for more feedback from you..

      Regards
      Vivek

      Reply
  2. Anonymous

    I have a doubt in 2NF it is said that "All attributes of an entity should be fully dependent on the whole primary key" . Then how come third table is said to be 2NF because it depends on composite key (combination of both empId + ProjectId) . Days allocated to a particular project need not depend fully on emp id it can also depend only on project id.can u please clarify by giving so more detailed explaination.I am newbie in SQL and now Iam still more confused

    Reply
    1. Arvind

      In third table, we have to add one column more to identify the row uniquely and this column should be primary key.

      Reply
  3. Anonymous

    I have a doubt in 2NF it is said that "All attributes of an entity should be fully dependent on the whole primary key" . Then how come third table is said to be 2NF because it depends on composite key (combination of both empId + ProjectId) . Days allocated to a particular project need not depend fully on emp id it can also depend only on project id.can u please clarify by giving so more detailed explaination.I am newbie in SQL and now Iam still more confused

    Reply

Leave a Reply