2St Normal Form - 2nf builds on the first normal form (1nf). Let us see an example − example. Web the second normal form eliminates partial dependencies on primary keys. Web second normal form (2nf) is the second step in normalizing a database. Web the second normal form applies to relations with composite keys, that is, relations with a primary key composed.
Web the second normal form applies to relations with composite keys, that is, relations with a primary key composed. 2nf builds on the first normal form (1nf). Web the second normal form eliminates partial dependencies on primary keys. Web second normal form (2nf) is the second step in normalizing a database. Let us see an example − example.