Follow Us :

NRM Q.6

6Consider the following set of functional dependencies on the schema (A, B, C)
A --> BC,
B —> C,
A —> B,
AB —> C
The canonical cover for this set is
  • Option : A
  • Explanation : Sets of functional dependencies may have redundant dependencies that can be inferred from the other functional dependencies.
    A canonical cover of F is a “minimal” set of functional dependencies equivalent to F, having no redundant dependencies or redundant parts of dependencies.
    As we can infer all FD's from option A, so A is the right answer.
Cancel reply

Your email address will not be published. Required fields are marked *


Cancel reply

Your email address will not be published. Required fields are marked *