Consider the table R with attributes A, B and C. The functional dependencies…

Consider the table R with attributes A, B and C. The functional dependencies that hold on

R are : A → B, C → AB. Which of the following statements is/are True ?

I. The decomposition of R into R1(C, A) and R2(A, B) is lossless.

II. The decomposition of R into R1(A, B) and R2(B, C) is lossy.

  1. A.

    Only I

  2. B.

    Only II

  3. C.

    Both I and II

  4. D.

    Neither I nor II

Attempted by 363 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…