alleryStart learning →A relation is in 2NF if it is in 1NF AND
Ano attribute is transitively dependent on the primary key
Bevery determinant is a candidate key
Cno attribute is multi-valued
Devery non-primary-key attribute is fully dependent on the PK
Answer & Solution
Correct answer: D. every non-primary-key attribute is fully dependent on the PK
2NF's defining condition is full functional dependency of non-key attributes on the primary key (no partial dependencies).
'No transitive dependency' is 3NF
'every determinant is a candidate key' is BCNF
'no multi-valued' is 1NF.
Each normal form adds a distinct rule on top.
Keep practising Database Management Systems
Browse all Database Management Systems questions for GATE CSE, or explore more Computer Science topics.