Multiple choice

Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic values. F = {CH $\leftarrow$ G, A $\rightarrow$ BC, B $\rightarrow$ CFH, E $\rightarrow$ A, F $\rightarrow$ EG} is a set of functional dependencies (FDs) so that F+ is exactly the set of FDs that hold for R.

How many candidate keys does the relation R have?

  1. 3

  2. 4

  3. 5

  4. 6
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Candidate keys are AD, BD, ED and FD.

Keep practicing — related questions