(3) (20%) Consider the following relation R(A,B,C,D,E) {A->B, BC->D, D- (a) Show all candidate keys (b) What is the highest normal form (up to BCNF)? Why? (c) If it is not in BCNF, can you losslessly decompose R into component relations in BCNF while preserving functional dependencies? If yes, how. If no, why? Show transcribed image text (3) (20%) Consider the following relation R(A,B,C,D,E) {A->B, BC->D, D- (a) Show all candidate keys (b) What is the
OR
OR