Ticker

6/recent/ticker-posts

GATE|GATE-CS-2013|Question9

 

GATE|GATE-CS-2013 |Question9

Relation R has eight attributes ABCDEFGH. Field of R contain only atomic values.

F={CH->G,A->BC,B->CFH,E->A,F->EG} is a set of functional dependencies(FD) so that F+ is exactly the set of FD that hold for R

How many candidate keys does the relation R have?

(A) 3

(B) 4

(C) 5

(D) 6

Answer (B)

Candiate keys are AD,BD,ED,FD.

So answer is 4.

Post a Comment

0 Comments