Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    7

    First and Second NF

    Hello

    i got a table with a single column primary key. It is in the first nf. Afaik is the condition for the second nf that all values that are not key-values have to depend on the _entire_ primary key. Because in the table pk is only on column this table is automaticlly in the second nf.

    Is my conclusion right ?
    Comments are welcome.

    d.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: First and Second NF

    Well, look at it this way: if your table has no non-key columns at all, then it clearly doesn't have any non-key columns that don't depend on the entire primary key! So yes, it is in 2NF and by similar arguments it is also in 3NF, 4NF, ...

Posting Permissions

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