Q2.7

MCQMarks unknown

Consider the schema $R=(S,T, U, V)$ and the dependencies $S \rightarrow T, T \rightarrow U, U \rightarrow V$ and $V \rightarrow S$ . Let $R = (R1\text{ and } R2)$ be a decomposition such that $R1 \cap R2 \neq \phi$ . The decomposition is

(A)

not in $\textsf{2NF}$

(B)

in $\textsf{2NF}$ but not $\textsf{3NF}$

(C)

in $\textsf{3NF}$ but not in $\textsf{2NF}$

(D)

in both $\textsf{2NF}$ and $\textsf{3NF}$

Loading…