We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- Databases
- Database Normalization
- Database Normalization #1 - 1NF
Database Normalization #1 - 1NF
Database Normalization #1 - 1NF
The following unnormalized table named PRODUCT is transformed to first normal form (1NF) by splitting it into two tables which have X and Y rows (such that X <Y) respectively. Both the tables have Z columns.
*Product-ID* *Colors* *Price*
1 Red,Green 15.0
2 Blue 18.0
3 Yellow,Pink 2.5
What are the values of X, Y, Z? Enter these integers, each on a new line, in the text-box below. Do not leave any leading or trailing spaces.