Page 1 of 1
(d) Consider a schema (A, B, C, D) with the functional dependencies AB C, CA, and C → D. Two possible decompositions of
Posted: Thu May 26, 2022 9:26 am
by answerhappygod
- D Consider A Schema A B C D With The Functional Dependencies Ab C Ca And C D Two Possible Decompositions Of 1 (28.19 KiB) Viewed 27 times
(d) Consider a schema (A, B, C, D) with the functional dependencies AB C, CA, and C → D. Two possible decompositions of the schema are: • (A, B, C) and (C,D). (A, C, D) and (B,C). For each of the decompositions, state whether it is in Boyce-Codd normal form? Justify your answer. For each of the decompositions, state whether it is lossless? Justify your answer. [10 marks]