Question 3 Given Relational Schema R B C D E Set Functional Dependencies F Ab Bc C Bc D R Q43817226
Question 3 Given is the relational schema R= (A, B, C, D, E) and the set of functional dependencies F = {AB → BC, C + A,BC → D}. Is R in 3NF? If not, give a lossless and dependency preserving decom- position which is in 3NF. Explain your answer carefully. Show transcribed image text Question 3 Given is the relational schema R= (A, B, C, D, E) and the set of functional dependencies F = {AB → BC, C + A,BC → D}. Is R in 3NF? If not, give a lossless and dependency preserving decom- position which is in 3NF. Explain your answer carefully.
Expert Answer
Answer to Question 3 Given is the relational schema R= (A, B, C, D, E) and the set of functional dependencies F = {AB → BC, C + …
OR