Normalization 1Decomposition Assume R A B C D E and F ABCDE

Normalization

1Decomposition.

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.

2. Decomposition.

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.

Solution

A->CE D->B this is in the form BCNF

for the 2nd one it is already in the form BCNF as there are no partial dependencies hence it is in BCNF.We cannot further simplify it