Question discussion

The set of functional dependencies F = {A → BC, B → C, A → B, AB → C} is given. How many functional dependencies does a canonical (minimal)…

1360Medium DSSSB TGT Computer Science 0 replies 1 views
0

The set of functional dependencies F = {A → BC, B → C, A → B, AB → C} is given. How many functional dependencies does a canonical (minimal) cover of F contain?

  • A3
  • B2
  • C4
  • D5
Correct answer: B

Explanation

Splitting A → BC and removing the duplicate gives A → B, A → C, B → C and AB → C; A is extraneous in AB → C, and A → C is implied by A → B and B → C, leaving the minimal cover {A → B, B → C}.

Discussion 0

Nobody has replied yet. Start the discussion!