Machine-translated by Google. Questions are authored in English.
Top

Discussion

In the context of functional dependency, Armstrong inference rules refer to :

  • A.Reflexivity, Decomposition and Transitivity
  • B.Decomposition and Transitivity
  • C.Transitivity, Augmentation and Reflexivity
  • D.Decomposition and Reflexivity

Answer: C

Armstrong's inference rules are reflexivity, augmentation and transitivity.

  • Reflexivity: if Y is a subset of X, then X → Y.
  • Augmentation: if X → Y, then XZ → YZ.
  • Transitivity: if X → Y and Y → Z, then X → Z.

These three axioms are sound and complete for deriving every functional dependency in the closure. Decomposition (and union, pseudotransitivity) are additional rules derived from them, so options naming decomposition list a derived rule instead of augmentation.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.