[Solved]L 20 Points Consider Relation R B C D E Functional Dependencies Ab C Bc D Cd E De Ae B Pro Q37129949

l. (20 points) Consider relation R(A,B,C,D,E) with functional dependencies AB → C, BC → D, CD → E, DE → A, and AE → B. Project these FD’s onto the relation S(A,B,C). Identify each of the following FD’s that holds in the projected relation? Answer Yes or No and explain if your answer is No. (Explanation is required to receive points.) (1) CDB: (3) ACD -B: (4) AB-C: (5) B-»D (6) AC -»B (7) BC-» A: (8) AE-B: (9) ABD ->C: (10) BC- E: Show transcribed image text l. (20 points) Consider relation R(A,B,C,D,E) with functional dependencies AB → C, BC → D, CD → E, DE → A, and AE → B. Project these FD’s onto the relation S(A,B,C). Identify each of the following FD’s that holds in the projected relation? Answer Yes or No and explain if your answer is No. (Explanation is required to receive points.) (1) CDB: (3) ACD -B: (4) AB-C: (5) B-»D (6) AC -»B (7) BC-» A: (8) AE-B: (9) ABD ->C: (10) BC- E:

Expert Answer

---

Answer to l. (20 points) Consider relation R(A,B,C,D,E) with functional dependencies AB → C, BC → D, CD → E, DE → A, and A… . . .