3 votes 3 votes Armstrong $(1974)$ proposed systematic approach to derive functional dependencies. Match the following w.r.t functional dependencies: $\begin{array}{} & \textbf{List-I} && \textbf{List -II} \\ \text{a.} & \text{Decomposition Rule} & \text{i.} & \text{If $X \rightarrow Y$ and $Z \rightarrow W$ then $\{X,Z\} \rightarrow \{Y, W\}$} \\ \text{b.} & \text{Union rule} & \text{ii.} & \text{If $X \rightarrow Y$ and $\{Y, W\} \rightarrow Z$ then $\{X, W\} \rightarrow Z$} \\ \text{c.} & \text{Composition rule} & \text{iii.} & \text{If $X \rightarrow Y$ and $X \rightarrow Z$ then $X \rightarrow \{Y, Z\}$} \\ \text{d.} & \text{Psedudo transitivity rule} & \text{iv.} & \text{ If $X \rightarrow \{Y, Z\}$ then $X \rightarrow Y$ and $X \rightarrow Z$} \\ \end{array}$ Codes: $\text{a-iii, b-ii, c-iv, d-i}$ $\text{a-i, b-iii, c-iv, d-ii}$ $\text{a-ii, b-i, c-iii, d-iv}$ $\text{a-iv, b-iii, c-i, d-ii}$ Databases ugcnetcse-dec2013-paper3 databases database-normalization + – go_editor asked Jul 29, 2016 edited Jun 23, 2021 by Lakshman Bhaiya go_editor 1.7k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
Best answer 2 votes 2 votes D. a-iv, b-iii, c-i, d-ii Decomposition rule : If x->yz then x->y , x->z Union rule : If x->y , x->z then x->yz Composition rule: if x->y and z->w then xz-> yw Pseudo transitivity rule : If x-> y and yw->z then xw-> z [ y replace by x]. X→Zhen Prashant. answered Jul 29, 2016 selected Nov 20, 2016 by Resmi Arjun 1 Prashant. comment Share Follow See all 0 reply Please log in or register to add a comment.