Part (e)

Problem 8 Consider a relation R (A, B, c, D, E, F, G, H) together with the functional dependencies AB E CD onsider RI (A, B, C, D) with the above functional dependencies. What would be a candidate key for R1? a) C (5 points) b) Is RI (A, B, C, D) in second normal form? If not, justify why. (3 points) (5 points) (3 points) 5 points) (A, B, E) a lossless join decomposition of R' (A, B, C, D, E)? Explain why or why not. d) Is R1 (A, B, C, D), R2 (A, B, E), R3 (F, G, H) and R4 (B, F) a dependency preserving decomposition of R? Explain why or why not. Using the following set of functional dependencies, find a Minimal Basis of these functional dependencies: e) AB E CD FG GH