Results 1 to 2 of 2

Thread: is it correct ? 1NF example

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2008
    Posts
    382

    is it correct ? 1NF example

    I am trying to figure out 1nf in normalisation

    1nf says that
    1) no repeating groups
    2) every row must be unique

    i read some examples over net

    and one of them is this

    http://www.database-normalization.co...l-form-1nf.php

    at bottom he created 2 tables for achieveing 1 nf
    1)table_product_price (product_id,price)
    2) table_product_color (product_id,color)

    in second table (table_product_color) product_id is repeating in again and again and not following the 1nf second rules ie.. every row must be unique

    can any one tell me .. i m wrong or right

    thanks

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: is it correct ? 1NF example

    A row contains multiple columns.

    In order for a row/record to be unique, only one of the values needs to be different to another row.

    In that example, "1","red" is different to "1","green".

Posting Permissions

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



Click Here to Expand Forum to Full Width