Sep 15th, 2012, 04:56 AM
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
at bottom he created 2 tables for achieveing 1 nf
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
Sep 15th, 2012, 06:17 AM
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".