Database Normalization #1 – 1NF – HackerRank Solution

In this post, we will solve Database Normalization #1 – 1NF HackerRank Solution. This problem (Database Normalization #1 – 1NF) is a part of HackerRank Databases series.

Task

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.

Solution – Database Normalization #1 – 1NF – HackerRank Solution

3
5
2

Note: This problem (Database Normalization #1 – 1NF) is generated by HackerRank but the solution is provided by CodingBroz. This tutorial is only for Educational and Learning purpose.