Consider the relation R(A,B,C,D,E) and the set of functional dependencies F = {A-> B, BC ->...

Transcribed Image Text:

Consider the relation R(A,B,C,D,E) and the set of functional dependencies F = {A-> B, BC -> E, ED -> A} Why are certain functional dependencies called trivial functional dependencies? Give examples using the above. List all of the candidate keys for R. Is R in third normal form (3NF)? Write yes or no and give a brief reason. Is R in Boyce-Codd normal form (BCNF)? Write yes or no and give a brief reason. Consider the relation R(A,B,C,D,E) and the set of functional dependencies F = {A-> B, BC -> E, ED -> A} Why are certain functional dependencies called trivial functional dependencies? Give examples using the above. List all of the candidate keys for R. Is R in third normal form (3NF)? Write yes or no and give a brief reason. Is R in Boyce-Codd normal form (BCNF)? Write yes or no and give a brief reason.

Answer rating: 100% (QA)

Trivial functional dependencies are those where the righthand side of the dependency is a subset of ... View the full answer