Consider a relation scheme R = (A, B, C, D, E, H) on which the following…

PYQ GATE 2005

Consider a relation scheme R = (A, B, C, D, E, H) on which the following functional dependencies hold: {A → B, BC → D, E → C, D → A}. What are the candidate keys of R?

  1. A.

    AE, BE

  2. B.

    AE, BE, DE

  3. C.

    AEH, BEH, BCH

  4. D.

    AEH, BEH, DEH

Attempted by 546 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…