4.1. Decomposition (10 points).

Assume R = (A B C D E) and F ={ABCDE,CE,DB}

Where A, B, C, D, and E represent individual attributes. Decompose R into BCNF, lossless, dependency preserving. If this is not possible, decompose R into 3NF, lossless, dependency preserving. Show your decomposition and state whether is it BCNF or 3NF.

4.2. Decomposition (10 points).

Assume R = (A B C D E) and F = {A BCDE, C E, D B }.

Where A, B, C, D, and E represent individual attributes. Decompose R into BCNF, lossless, dependency preserving. If this is not possible, decompose R into 3NF, lossless, dependency preserving. Show your decomposition and state whether it is BCNF or 3NF.