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