Q55

MCQ2 marks, −0.67

Relation $R$ has eight attributes $\text{ABCDEFGH}$ . Fields of $R$ contain only atomic values. $F = \{ CH$ $\rightarrow$ $G, A \rightarrow BC, B \rightarrow CFH, E \rightarrow A, F \rightarrow EG \}$ is a set of functional dependencies $(FDs)$ so that $F^+$ is exactly the set of $FDs$ that hold for $R$ . The relation $R$ is

(A)

in $\text{1NF}$ , but not in $\text{2NF}$ .

(B)

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

(C)

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

(D)

in $\text{BCNF}$ .

Loading…