Database Normalization #10 – HackerRank Solution

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

Task

The following table stores rows of information about pizza deliveries. The three columns correspond to the Restaurant name, Crust, Delivery Area. We convert this table into Fourth Normal Form and so we end up creating two tables, each with two columns and N rows. (Both the new tables have an equal number of rows)

Restaurant  Crust       Delivery Area
-------------------------------------------
X Pizza     Thick       Whitefield
X Pizza     Thick       Greenville
X Pizza     Thick       Capital
X Pizza     Stuffed     Whitefield
X Pizza     Stuffed     Greenville
X Pizza     Stuffed     Capital
Papa Pizza  Thin        Capital
Papa Pizza  Stuffed     Capital
F1 Pizza    Thick       Whitefield
F1 Pizza    Thick       Greenville
F1 Pizza    Thin        Whitefield
F1 Pizza    Thin        Greenville

In the text box below, enter the value of the integer N.

Solution – Database Normalization #10 – HackerRank Solution

6

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