Gate CS-2005 Question Paper With Solutions

Q. 78 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?

(A) AE, BE

(B) AE, BE, DE

(C) AEH, BEH, BCH

(D) AEH, BEH, DEH

Answer: (D)

Explanation:

Gate CS-2005 Question Paper With Solutions

Learn More:   Gate EE-2008 Question Paper With Solutions

LEAVE A REPLY

Please enter your comment!
Please enter your name here