In this post, we will solve Database Normalization #5 HackerRank Solution. This problem (Database Normalization #5) is a part of HackerRank Databases series.
Task
Consider the following relation and determinants.
R(a, b,c,d)
a,c -> b,d
a,d -> b
Also, a,b is a primary key for the above relation.The above relation is in x NF form where x may take the following values {1,2,3,3.5} corresponding to {1NF, 2NF, 3NF and BCNF} respectively.
What is the maximum possible value of x such that the above relation satisfies the *x*NF form?
Your answer should only be restricted to one of these numbers:1/2/3/3.5 Do not leave any leading or trailing spaces.
Solution – Database Normalization #5 – HackerRank Solution
3
Note: This problem (Database Normalization #5) is generated by HackerRank but the solution is provided by CodingBroz. This tutorial is only for Educational and Learning purpose.