Question 2 Given Relational Schema R B C D E Set Functional Dependencies F Ab Bc C Abc D Q43817223
Question 2 Given is the relational schema R= (A, B, C, D, E) and the set of functional dependencies F = {AB → BC, C+ A, ABC → 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 2 Given is the relational schema R= (A, B, C, D, E) and the set of functional dependencies F = {AB → BC, C+ A, ABC → 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 2 Given is the relational schema R= (A, B, C, D, E) and the set of functional dependencies F = {AB → BC, C+ A…
OR