Question: Suppose a relation has attributes A, B, C, D, E, F, G, H with the following functional dependencies: AF->C B->EG CD->GH BC->AF DEH->AF DE->G a)
Suppose a relation has attributes A, B, C, D, E, F, G, H with the following functional dependencies:
AF->C B->EG CD->GH BC->AF DEH->AF DE->G
a) Extract an example of a transitive functional dependency
b) Find the closure of {ABF}, that is {ABF}+
c) Does the functional dependency AB->F follow?
d) Does the functional dependency BCGF follow?
e) Come up with your own functional dependency (not a trivial one!) that follows from the functional dependencies above.
Step by Step Solution
There are 3 Steps involved in it
a To find an example of a transitive functional dependency you can use the given functional dependen... View full answer
Get step-by-step solutions from verified subject matter experts
