|
-
Sep 15th, 2012, 04:56 AM
#1
Thread Starter
Hyperactive Member
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
-
Sep 15th, 2012, 06:17 AM
#2
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|