Please answer the questions in details , with explanation 

 

HW51.Suppose we have relaton R (ABCDE) andR1(ABC), R2(BCD)and R3(ACE) be adecompositon of R.LeT F= {Aï‚®D, Bï‚®D, CDï‚®E}.a.Use The chase TesT To Tell wheTher This decompositon of R is lossless.b.Is This decompositon dependency preserving?c.Is Thisdecompositon in BCNF? If noT, indicaTe all BCNF violatons and Try Todecompose R inTo BCNF.2.LeT R(ABCDE) be a relaton and F={Aï‚®BC, Cï‚®D}.LeT R1(ABC), R2(ADE) beadecompositon of Ra.Is This decompositon lossless?b.Is This decompositon dependency preserving?c.Is This decompositon in BCNF?d.Can you decompose RinTo dependency preserving decompositon which is in BCNF?3.LeT R(ABCDE)be a relaton andF={Aï‚®B, BCï‚®E, and EDï‚®A}. Decompose R inTo BCNF.4.LeTR(ABCDEFGH) be a relaton and F= {ABï‚®E, Cï‚®D, Dï‚®E, FGï‚®A}. Decompose R in BCNF.Is your decompositon dependency preserving?

Attachments:

• 1494550227-HW5 3.docx