Q36

MSQ2 marks

Consider the following relational schema along with all the functional dependencies that hold on them.

\begin{array}{l} R 1(A, B, C, D, E):\{D \rightarrow E, E A \rightarrow B, E B \rightarrow C\} \\ R 2(A, B, C, D):\{A \rightarrow D, A \rightarrow B, C \rightarrow A\} \end{array}

Which of the following statement(s) is/are TRUE?

(A)

$R 1$ is in $3$ NF

(B)

$R 2$ is in $3$ NF

(C)

$R 1$ is NOT in $3$ NF

(D)

$R 2$ is NOT in $3$ NF

Loading…