what is Second Normal Form (2NF)?

Second normal form (2NF) is the second step in normalizing a database. 2NF builds on the first normal form (1NF).
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.

Comments