Write Short Notes on Armstrong's Axioms

Write Short Notes on Armstrong's Axioms

Verified Sources
Sep 14, 2026

In database theory, Functional Dependency (FD) is written as XYX \to Y, where XX and YY are attribute sets. To reason about which FDs logically follow from a given set, we use Armstrong's axioms—a small sound and complete set of inference rules for FDs.
The axioms are:

  1. Reflexivity: if YXY \subseteq X then XYX \to Y.
  2. Augmentation: if XYX \to Y then for any ZZ, XZYZXZ \to YZ.
  3. Transitivity: if XYX \to Y and YWY \to W then XWX \to W.

These three are the core inference mechanisms; many useful derived rules can be obtained from them.

Note: The “soundness” property means every FD derived using the axioms is logically implied by the original FDs; “completeness” means any logically implied FD can be derived from them.

Write-short-notes version (what to include)

A good short note typically lists (i) definitions, (ii) the axioms, and (iii) at least 1–2 derived rules used in exams.

Key objects you should mention:

  • Attribute set: e.g., X,Y,ZUX, Y, Z \subseteq U.
  • Closure: helps compute what follows from a set of FDs.
  • Implied FD: written Σf\Sigma \models f.

Armstrong's axioms are inference rules used to derive implied FDs:

  • Reflexivity: YXXYY \subseteq X \Rightarrow X \to Y
  • Augmentation: XYXZYZX \to Y \Rightarrow XZ \to YZ
  • Transitivity: (XY)(YW)XW(X \to Y) \wedge (Y \to W) \Rightarrow X \to W

How to derive an FD using Armstrong's axioms (method)

  1. 1
    Step 1

    Let Σ\Sigma be your set of known FDs. Your goal is to derive ff (i.e., ff follows from Σ\Sigma).

  2. 2
    Step 2

    If you can recognize that YXY \subseteq X, you can immediately infer XYX \to Y.

  3. 3
    Step 3

    From XYX \to Y, infer XZYZXZ \to YZ for any attribute set ZZ.

  4. 4
    Step 4

    If you have XYX \to Y and YWY \to W, then infer XWX \to W.

  5. 5
    Step 5

    Keep chaining using the three axioms (or derived rules proved from them) until you obtain the required FD.

Common derived rules (often expected in “short note” answers)

Derived rules are consequences of Armstrong’s axioms and are frequently used to simplify derivations:

Union rule
If XYX \to Y and XZX \to Z, then XYZX \to YZ.

Decomposition rule
If XYZX \to YZ, then XYX \to Y and XZX \to Z.

Pseudotransitivity
If XYX \to Y and WYZWY \to Z, then XWZXW \to Z.

Quick derivation idea for Union (sketch)

Using augmentation and transitivity, you can combine XYX \to Y and XZX \to Z into XYZX \to YZ by first augmenting one FD so that the RHS aligns with the other’s determined attributes, then chaining.

type="tip" title="Exam tip" content="When writing short notes, always present the three axioms explicitly (R, A, T). Then add 1 derived rule (Union/Decomposition) with a one-line statement."

type="warning" title="Common mistake" content="Be careful: augmentation adds the same attributes to both sides (XZYZXZ \to YZ), not just to one side."

Armstrong's Axioms at a Glance

A compact comparison of the three core inference rules for FDs.

Reflexivity: YXXYY \subseteq X \Rightarrow X \to Y Augmentation: XYXZYZX \to Y \Rightarrow XZ \to YZ Transitivity: (XY)(YW)XW(X \to Y) \wedge (Y \to W) \Rightarrow X \to W

FAQ / Quick Checks

Armstrong's Axioms Quick Revision Deck

1 / 5
Question · Term

What does Reflexivity say for functional dependencies?

Click to reveal
Answer · Definition

If YXY \subseteq X, then XYX \to Y.

Knowledge Check

Question 1 of 4
Q1Single choice

Which rule states that if YXY \subseteq X then XYX \to Y?