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
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".