2nd Normal Form(2NF)

A relation that is in first normal form and every non-primary key attribute is fully functionally dependent on the primary key is in second normal form.  A table is in 2nd normal form if It is in 1st normal form  It includes no partial dependencies that is no attribute is dependent only a portion of the primary key.

• Moving relation from 1NF to 2NF involves removing partial dependencies. 
• A relation that is on 1NF and has a single attribute primary key is automatically in 2NF.