- 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 35 times
(d) Consider a schema (A, B, C, D) with the functional dependencies AB C, CA, and C → D. Two possible decompositions of
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
(d) Consider a schema (A, B, C, D) with the functional dependencies AB C, CA, and C → D. Two possible decompositions of
(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]
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!