Write Short Notes on Armstrong's Axioms
In database theory, Functional Dependency (FD) is written as , where and 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:
- Reflexivity: if then .
- Augmentation: if then for any , .
- Transitivity: if and then .
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., .
- Closure: helps compute what follows from a set of FDs.
- Implied FD: written .
Armstrong's axioms are inference rules used to derive implied FDs:
- Reflexivity:
- Augmentation:
- Transitivity:
How to derive an FD using Armstrong's axioms (method)
- 1Step 1
Let be your set of known FDs. Your goal is to derive (i.e., follows from ).
- 2Step 2
If you can recognize that , you can immediately infer .
- 3Step 3
From , infer for any attribute set .
- 4Step 4
If you have and , then infer .
- 5Step 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 and , then .
Decomposition rule
If , then and .
Pseudotransitivity
If and , then .
Quick derivation idea for Union (sketch)
Using augmentation and transitivity, you can combine and into 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 (), not just to one side."
Armstrong's Axioms at a Glance
A compact comparison of the three core inference rules for FDs.
Reflexivity: Augmentation: Transitivity:
FAQ / Quick Checks
Armstrong's Axioms Quick Revision Deck
Knowledge Check
Which rule states that if then ?
Explore Related Topics
Write short notes on: I-Node
In Unix-like file systems an inode is the fixed‑size metadata record that uniquely identifies a file and stores its type, permissions, ownership, timestamps, link count, and block pointers, while the filename lives in directory entries.
- Direct pointers (0‑11) give bytes; indirect levels use pointers per block.
- With B, B, → capacities 48 KB, 4 MB, 4 GB, 4 TB, so max file size ≈ 4 TB.
- Renaming or moving a file inside the same filesystem leaves its inode number unchanged; only directory entries are updated.
- Inode exhaustion can occur even with free space because each file consumes an inode; monitor with
df -i.
Knowledge: Short Notes with a Clear Conceptual Framework
Post Correspondence Problem (PCP): Short Notes for Computation Theory