Q16

MCQMarks unknown

For relation R = (L, M, N, O, P), the following dependencies hold: $M \rightarrow O,$ $NO \rightarrow P,$ $P \rightarrow L$ and $L \rightarrow MN$ R is decomposed into R1 = (L, M, N, P) and R2 = (M, O).

(A)

Is the above decomposition a lossless-join decomposition? Explain.

(B)

Is the above decomposition dependency-preserving? If not, list all the dependencies that are not preserved.

(C)

What is the highest normal form satisfied by the above decomposition?

Loading…