Suppose a relation has attributes A, B, C, D, E, F, G, H with the following functional
Fantastic news! We've Found the answer you've been seeking!
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) 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.
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date: