Answer to Question #266426 in Databases | SQL | Oracle | MS Access for parth srivastva

Question

Consider the following relation with set of functional dependencies R(ABCDEF) ABC->D, ABD->E, CD->F, CDF->B, BF->D

a) Identify the candidate key(s) in the relation (with proper steps followed).

b) Identify which normal form this relation is in and reason for the answer.

Answer 1

Answer: a. The only key is {C, E}

b. The relation is in 1NF