Database Normalization #9 – HackerRank Solution

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

Task

Consider the following relation and determinants. The key(s) are bolded.
R(a, b ,c,d,e)

Which of these determinants is a NON-CANDIDATE key? In the text box, only enter the index number (1-3) of the dependency which you have identified as non-key.

1. a,c -> b,d,e
2. a,d -> b
3. a,c,e -> b,d

Solution – Database Normalization #9 – HackerRank Solution

2

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