First Normal Form

The rules for First Normal Form are:

The table in Figure 6-1 violates First Normal Form, since the dept_no column contains a repeating group:

Figure 6-1: A table that violates first Normal Form

Normalization creates two tables and moves dept_no to the second table:

Figure 6-2: Correcting First Normal Form violations by creating two tables