Q36

MCQ2 marks, −0.67

Consider a relational table $R$ that is in $3NF$ , but not in BCNF. Which one of the following statements is TRUE?

(A)

$R$ has a nontrivial functional dependency $X \rightarrow A$ , where $X$ is not a superkey and $A$ is a prime attribute.

(B)

$R$ has a nontrivial functional dependency $X \rightarrow A$ , where $X$ is not a superkey and $A$ is a non-prime attribute and $X$ is not a proper subset of any key.

(C)

$R$ has a nontrivial functional dependency $X \rightarrow A$ , where $X$ is not a superkey and $A$ is a non-prime attribute and $X$ is a proper subset of some key

(D)

A cell in $R$ holds a set instead of an atomic value.

Loading…