Answer to Question #257610 in Databases | SQL | Oracle | MS Access for Tarurendra Kushwah

Question

Given relation R (A,B,C,D) and the following FD’s. Identify the candidate key for R and highest normal form

B->C, D->A

Answer 1

A+= A

B+=BC

C+=C

D+=DA

ABD+=ABDA

Since the closure of ABD contains all the attributes of R, it is a candidate key.

BCD=BCDA

Since the closure of BCD contains all the attributes of R, it is a candidate key.

Therefore the candidate key can be ABD or BCD.