Database Normalization #2 – 1/2/3 NF – HackerRank Solution

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

Task

A particular database is normalized to satisfy a particular level of normalization (either 1NF or 2NF or 3NF). One of the tables contains, among other fields, a column for the City and a column for the Zip Code. Assuming that there is a many-to-one mapping between the set of Zip Code(s) and City, we may conclude that the database is definitely NOT in xNF form. What is the integer x (1, 2, or 3)? Fill your answer in the text box below.

Solution – Database Normalization #2 – 1/2/3 NF – HackerRank Solution

3

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

Leave a Comment

Your email address will not be published. Required fields are marked *