Correct answer: (A) A relation with only two attributes is always in BCNF.
Explanation
With two attributes, every nontrivial FD has a superkey as its determinant, so the relation is in BCNF. All-prime attributes only guarantee 3NF. A relation can have no non-prime attribute, and BCNF decomposition may lose FDs.
More Integrity Constraints and Normal Forms questions
GATE 2022 CS Q31– Consider a relation R(A,B,C,D,E) with the following three functional dependencies. AB C;…
GATE 2021 CS (CS1) Q43– Consider the relation R(P,Q,S,T,X,Y,Z,W) with the following functional dependencies. PQ…
GATE 2020 CS Q46– Consider a relational table R that is in 3NF, but not in BCNF. Which one of the following…
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,…