[Solved]-Q3 20 Points Consider Following Relation R B C D E Following Dependencies Ab C Cd E De B Q37281140

Q.3 (20 points) Consider the following relation R(A. B. C. D. E) with the following dependencies: AB → C, CD → E, DE→ B a) Is AB a candidate key of this relation? If not, is ABD? Explain your answer. b) Is this Ielai lon n BCNI ? IUKplam your answer. Îl noi, deco1 )()se й mio BCN relail( IIS c) Is this relation in 3NF? Explain your answer. If not, decompose it into 3NF relations. Show transcribed image text Q.3 (20 points) Consider the following relation R(A. B. C. D. E) with the following dependencies: AB → C, CD → E, DE→ B a) Is AB a candidate key of this relation? If not, is ABD? Explain your answer. b) Is this Ielai lon n BCNI ? IUKplam your answer. Îl noi, deco1 )()se й mio BCN relail( IIS c) Is this relation in 3NF? Explain your answer. If not, decompose it into 3NF relations.

Expert Answer

---

Answer to Q.3 (20 points) Consider the following relation R(A. B. C. D. E) with the following dependencies: AB → C, CD → E, DE… . . .