Normalization & Functional Dependencies

Single correct

• A$R$ has a nontrivial functional dependency $X \to A$, where $X$ is not a superkey and $A$ is a prime attribute.
• B$R$ has a nontrivial functional dependency $X \to 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 \to A$, where $X$ is not a superkey and $A$ is a non-prime attribute and $X$ is a proper subset of some key.
• DA cell in $R$ holds a set instead of an atomic value.

Answer key coming soon