Normalization 1Decomposition. Assume R = (A B C D E) and F ={ABCDE,CE,DB} Where

Question

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.

Explanation / Answer

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

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.