Question: what is 2nf in dbms?
Answer: Second normal form (2NF) is a normal form used in database normalization. ... A relation is in the second normal form if it fulfills the following two requirements: It is in first normal form. It does not have any non-prime attribute that is functionally dependent on any proper subset of any candidate key of the relation.