i)2NF stands for Second Normal Form.
ii)It is a type of normal form used in database design to ensure that a database is free of certain types of redundancy and inconsistencies.
iii) A relation in 2NF must meet the requirements of 1NF and in addition, every non-prime attribute must be dependent on the primary key.
iv) A prime attribute is an attribute that is part of a candidate key, and a non-prime attribute is one that is not.
2NF deals with the elimination of partial dependencies in a table that has a composite primary key. For example, consider a table having a composite key and some non-key attributes depend only on part of the key; then that violates 2NF. We achieve 2NF and avoid redundancy by breaking up such tables into smaller ones where non-key attributes depend on the whole primary key.
2NF, or Second Normal Form, is the step in organizing databases that eliminates partial dependencies in a table. A table is said to be in 2NF if it is in 1NF and all the non-prime attributes depend on the whole primary key and not just on part of it. This will help keep data accurate and remove repetition due to partial dependencies.