Results 1 to 2 of 2

Thread: 2NF but not 3NF

  1. #1
    Join Date
    Aug 2003

    2NF but not 3NF

    Last edited by appoooh; 10-29-03 at 08:00.

  2. #2
    Join Date
    Oct 2002
    Baghdad, Iraq

    Re: 2NF but not 3NF

    It's not in 2NF because of the functional dependencies.

    Name is a function of StudId, that is, given the StudId, you always know what the Name is. So to get rid of that dependency, you'd project away (StudId, Name) to another table, and only have StudId in the original table.

    There are others there, so work those out before you try to understand 3NF.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts