First Normal Form

Topics: Database - Database Normalisation

---

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

1. Each attribute (column) is atomic. That is, it contains one and only one value for each tuple.
2. The values stored in a given attribute are of the same nature (same domain, same data type).
3. All the attributes have unique names