Question 5-2.

Consider the following relation R and functional dependencies. Relation: R = (A, B, C, W)

FDs:

FD = {WA, BCW, ABCW}

(i) Find all candidate keys for relation R.

(ii) What is the highest normal form of relation R?

(iii) Decompose R (if required) into BCNF relations. For each decomposition you

make, identify the normal form of the original and resulting relations and specify the keys. Give a brief explanation of each normalization step.