-
The following functional dependencies are given
AB → CD, AF → D, DE → F, C → G, F → E, G → A
Which one of the following options is false?
-
- {CF}+ = {ACDEFG}
- {BG}+ = {ACDG}
- {AF}+ = {ACDEFG}
- {AB}+ = {ACDFG}
- {CF}+ = {ACDEFG}
Correct Option: C
Consider a+
result = a
Also consider, a = a+
While do
for each functional dependency X → Z in f
do begin
if X C a (result), then
result = result YZ
end
compute {AF}+ = {AF} = {AFD} AF -> D
= {AFDE} F -> E
