Which of the following choice(s) is/are correct ?
Note – This question is multiple select questions (MSQ).
(A) If a table has only one candidate key then table can not be in 2 NF.
(B) A relation will be in 2NF if it is in 1NF and all non-key attributes are fully functional dependent on the primary key.
(C) First Normal Form (1NF) does not eliminate redundancy, but rather, it’s that it eliminates repeating groups.
(D) Relation should not have any attribute in Functional Dependency which is non-prime, the attribute that doesn’t occur in any candidate key.
Answer: (A) (B) (C)
Explanation: Only options (A), (B), and (C) are correct.
Option (D) is false.