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 X→YX \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 Y⊆XY \subseteq X then X→YX \to Y.
  2. Augmentation: if X→YX \to Y then for any ZZ, XZ→YZXZ \to YZ.
  3. Transitivity: if X→YX \to Y and Y→WY \to W then X→WX \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,Z⊆UX, 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: Y⊆X⇒X→YY \subseteq X \Rightarrow X \to Y
  • Augmentation: X→Y⇒XZ→YZX \to Y \Rightarrow XZ \to YZ
  • Transitivity: (X→Y)∧(Y→W)⇒X→W(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 Y⊆XY \subseteq X, you can immediately infer X→YX \to Y.

  3. 3
    Step 3

    From X→YX \to Y, infer XZ→YZXZ \to YZ for any attribute set ZZ.

  4. 4
    Step 4

    If you have X→YX \to Y and Y→WY \to W, then infer X→WX \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 X→YX \to Y and X→ZX \to Z, then X→YZX \to YZ.

Decomposition rule
If X→YZX \to YZ, then X→YX \to Y and X→ZX \to Z.

Pseudotransitivity
If X→YX \to Y and WY→ZWY \to Z, then XW→ZXW \to Z.

Quick derivation idea for Union (sketch)

Using augmentation and transitivity, you can combine X→YX \to Y and X→ZX \to Z into X→YZX \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 (XZ→YZXZ \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: Y⊆X⇒X→YY \subseteq X \Rightarrow X \to Y Augmentation: X→Y⇒XZ→YZX \to Y \Rightarrow XZ \to YZ Transitivity: (X→Y)∧(Y→W)⇒X→W(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 Y⊆XY \subseteq X, then X→YX \to Y.

Knowledge Check

Question 1 of 4
Q1Single choice

Which rule states that if Y⊆XY \subseteq X then X→YX \to Y?