For relation R = (L, M, N, O, P), the following dependencies hold: { M → O, NO…

For relation R = (L, M, N, O, P), the following dependencies hold: { M → O, NO → P, P → L, L → MN }. R is decomposed into R1 = (L, M, N, P) and R2 = (M, O). The decomposition is:

  1. A.

    Lossless decomposition and dependency preserving

  2. B.

    Lossless decomposition and not dependency preserving

  3. C.

    Lossy decomposition and dependency preserving

  4. D.

    Lossy decomposition and not dependency preserving

Attempted by 197 students.

Sign up free to check your answer

Sign up free

Explore the full course: Isro

Loading lesson…