First Normal Form (1NF)


First Normal Form is the first step of normalization.

It ensures that table columns contain atomic values.

Each field must store only one value.

In 1NF, repeating groups are not allowed.

Each record must be unique.

Tables should have a primary key.

If a column contains multiple values, the table is not in First Normal Form.

Such data must be separated.

The courses column contains multiple values.

This violates First Normal Form rules.

Each value must be stored separately.

First Normal Form improves data clarity.

It removes repeating groups.

1NF is the foundation of normalization.