[Solved]3 20 Consider Following Relation R B C D E B Bc D D Show Candidate Keys B Highest Normal F Q37266227

this is design database class please help.

(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 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?

Expert Answer

---

Answer to (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 high… . . .