Answer to Question #267154 in Databases | SQL | Oracle | MS Access for Manish Yadav

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