MCQOPTIONS
Saved Bookmarks
| 1. |
Armstrong (1974) proposed systematic approach to derive functional dependencies. Match the following w.r.t. functional dependencies:a.Decomposition Rule (i) If X →Y and Z →W then {X, Z} → {Y, W}b. Union Rule (ii) If X →Y an {Y,W} → Z then {X, W} → Zc. Composition Rule (iii) If X →Y and X →Z then X → {Y, Z} d. Pseudo transitivity Rule (iv) If X →{Y,Z} and {Y,W} → Z then X → Y and X →Z |
| A. | (a)-(iii),(b)-(ii),(c)-(iv),(d)-(i) |
| B. | (a)-(i),(b)-(iii),(c)-(iv),(d)-(ii) |
| C. | (a)-(ii),(b)-(i),(c)-(iii),(d)-(iv) |
| D. | (a)-(iv),(b)-(iii),(c)-(i),(d)-(ii) |
| Answer» E. | |