Match the Armstrong's Axioms: List-1 List-2 I) Decomposition rule P) If α →…
2018
Match the Armstrong's Axioms:
List-1 | List-2 |
I) Decomposition rule | P) If α → βγ, |
II) Union rule | Q) If α → β, and γβ → δ, |
III) Pseudotransitivity rule | R) If α → β and α → γ, |
IV) Augmentation rule | S) If α → β, |
- A.
I-Q, II-P, III-R, IV-S
- B.
I-P, II-R, III-Q, IV-S
- C.
I-P, II-Q, III-R, IV-S
- D.
I-Q, II-P, III-S, IV-R
Attempted by 309 students.
Show answer & explanation
Correct answer: B
Armstrong's Axioms define functional dependencies in database normalization. Decomposition (I) matches P, splitting βγ into separate dependencies.
Union (II) matches R, combining α → β and α → γ into a single dependency. Pseudotransitivity (III) matches Q, chaining dependencies via intermediate attributes.
Augmentation (IV) matches S, adding attributes to both sides of a dependency. The correct sequence is I-P, II-R, III-Q, IV-S.