What is 2NF?

2NF is the Second Normal Form. A table is said to be 2NF if it follows the following conditions:

  • The table is in 1NF, i.e., firstly it is necessary that the table should follow the rules of 1NF.
  • Every non-prime attribute is fully functionally dependent on the primary key, i.e., every non-key attribute should be dependent on the primary key in such a way that if any key element is deleted, then even the non_key element will still be saved in the database.