Tech moves fast! Stay ahead of the curve with Techopedia!
Join nearly 200,000 subscribers who receive actionable tech insights from Techopedia.
Second normal form (2NF) is the second step in normalizing a database. 2NF builds on the first normal form (1NF).
Normalization is the process of organizing data in a database so that it meets two basic requirements:
A 1NF table is in 2NF form if and only if all of its non-prime attributes are functionally dependent on the whole of every candidate key.
After meeting the requirements of 1NF, 2NF requires the database designer to do the following:
A table for which there are no partial functional dependencies on the primary key might or might not be in 2NF. In addition to the primary key, the table may contain other candidate keys; it is necessary to establish that no non-prime attributes have part-key dependencies on any of these candidate keys.