Database Normalization - First Normal Form (1NF)

The first normal form means the data is in an entity format, which means the following conditions have been met:

  • Eliminate repeating groups in individual tables
  • Create separate table for each set of related data
  • Identify each set of related data with primary key

Do not use multiple fields in a single table to store similar data.