Q62

MCQ2 marks, −0.5

Let $R (A, B, C, D, E, P, G)$ be a relational schema in which the following functional dependencies are known to hold: $AB \to CD, DE \to P, C \to E, P \to C$ and $B \to G.$ The relational schema $R$ is

(A)

in $\text{BCNF}$

(B)

in $\text{3NF}$ , but not in $\text{BCNF}$

(C)

in $\text{2NF}$ , but not in $\text{3NF}$

(D)

not in $\text{2NF}$

Loading…