Database management systems

Q7 Answer the following questions regarding schema refinement and normal forms. Make sure that you explain your answer. No explanation means no points. (a) for R(A,B,C) with FDs A- B, B->C, can I say that A->C also holds? Explain your answer (b) for R(A,B,C) with FDs, A->B, B->C, is the decomposition of R into R1(A,B) and lossless-join (non-additive) decomposition? Explain why R2(B,C) lossless-join (non-additive) decomposition? Explain why. (c) for R(A,B,C) with FDs, A- B, B->C, is AB a key for R? Explain your answer (d) [4pts] for R(A,B,C) with FDs, A->B, B->C, sR in BCNF? Explain your