Using Armstrong's axioms of functional dependency, derive the following rule: {x -> y, wy -> z} |= xw -> z (Note: x -> y denotes y is functionally dependent on x; z subset_of y denotes z is subset of y; and |= means derives).

GATE 1988 · Databases · Database Normalization · medium

Answer: xw -> z is derived using Augmentation on x->y (to get xw->yw) followed by Transitivity with wy->z.

  1. Augment x -> y with w: By Augmentation axiom, adding w to both sides of x -> y gives xw -> yw.
  2. Apply Transitivity: We now have xw -> wy (from step 1) and wy -> z (given). By Transitivity, xw -> z.