Suppose we have a relation R(A, B, C, D, E) and the set of FDs {A → DE, D → B,…

Suppose we have a relation R(A, B, C, D, E) and the set of FDs {A → DE, D → B, and E → C}. If we project R (and therefore its FDs) onto schema R1(A, B, C), what is true about the key(s) for R1?

  1. A.

    Only ABC is a key

  2. B.

    Only A is a key

  3. C.

    Only DE is a key

  4. D.

    A, B, and C are each keys.

Attempted by 498 students.

Sign up free to check your answer

Sign up free

Explore the full course: Isro

Loading lesson…