You are given the following set of functional dependencies for a relation…
You are given the following set of functional dependencies for a relation R(A,B,C,D,E,F),
F = {AB → C, DC → AE, E → F }.
i. Is this relation in BCNF?
ii. Is the decomposition (A,B,C,D) (B,C,D,E,F) a dependency preserving decomposition?
- A.
i: Yes, ii: Yes
- B.
i: Yes, ii: No
- C.
i: No, ii: No
- D.
i: No, ii: Yes
Attempted by 46 students.
Sign up free to check your answer
Sign up freeLoading lesson…

