You are viewing a single comment's thread. Return to all comments →
3 5 2
Product-ID* Price 1 15.0 2 18.0
Product-ID* Colors 1 Red, 1 Green 2 Blue 3 Yellow 3 Pink
3 rows 1st table and 5 rows 2nd table (3 columns both table )
Seems like cookies are disabled on this browser, please enable them to open this website
Database Normalization #1 - 1NF
You are viewing a single comment's thread. Return to all comments →
3 5 2
Spliting 1 NF (two table formation )
Product-ID* Price 1 15.0 2 18.0
3 2.5
Product-ID* Colors
1 Red,
1 Green
2 Blue
3 Yellow
3 Pink
3 rows 1st table and 5 rows 2nd table (3 columns both table )