1. Decomposition

Assume R = (S T U V W X Y Z) and F = {S TV , T U, W XY , SW Z}

Where S, T, U, V , W, X, Y and Z 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 = (S T U V W X Y Z) and F = {S TUV W, T UV , W XY , V Z }.

Where S T, U, V , W, X, Y and Z 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.