Second Normal Form

Topics: Database - Database Normalisation

---

When normalising a database, we say that a relation (table) is in the second normal form (2NF) if it satisfies the following two conditions:

1. It’s in the first normal form
2. It has no partial dependencies

In other words, a relation is in 2NF if it is in 1NF and additionally every non-prime attribute depends on the whole of every candidate key.