Consider a relational table $R$ that is in 3NF, but not in BCNF. Which one of the following statements is TRUE?
$R$ has a nontrivial functional dependency $X\to A$, where $X$ is not a superkey and $A$ is a prime attribute.
$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.
$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.
A cell in $R$ holds a set instead of an atomic value.
Correct answer: (A) $R$ has a nontrivial functional dependency $X\to A$, where $X$ is not a superkey and $A$ is a prime attribute.
Explanation
3NF requires that for every nontrivial FD $X\to A$, either $X$ is a superkey or $A$ is prime. Not being in BCNF means some FD has a non-superkey $X$, so $A$ must be prime.
More Integrity Constraints and Normal Forms questions
GATE 2019 CS Q42– Let the set of functional dependencies F=\QR S,\ R P,\ S Q\ hold on a relation schema…
GATE 2018 CS Q52– Consider the following four relational schemas. For each schema, all non-trivial…
GATE 2016 CS (CS1) Q31– Which of the following is NOT a superkey in a relational schema with attributes V, W, X,…
GATE 2016 CS (CS1) Q33– A database of research articles in a journal uses the following schema. (Volume, Number,…
GATE 2017 CS (CS1) Q26– The following functional dependencies hold true for the relational schema R\V, W, X, Y,…
GATE 2014 CS (CS1) Q31– Relation R=(E,F,G,H,I,J,K,L,M,N) has dependencies EF G, F IJ, EH KL, K M, L N. Find its…