Suppose you are given a relation R=(A,B,C,D,E) given below with the following…

Suppose you are given a relation R=(A,B,C,D,E) given below with the following functional dependencies: BD → E, A → C .

If the above relation R is decomposed into R1=(A,B,C) and R2=(D,E). Which is/are the correct statement?

  1. A.

    Decomposition is incorrect

  2. B.

    The decomposition is lossless

  3. C.

    The decomposition is lossy

  4. D.

    Cannot join the two relations because of no common attribute

Attempted by 79 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…