First Normal Form (1NF)

A table is normalized in a First Normal Form (1NF) if doesn’t contain any multi-valued attributes. I.e., every attribute in the table must be atomic.

For example, consider the Members table shown in the upper part of Figure 11.2.

		The table contains a multi-valued attribute Phone_No.
		Thus, the table is not in 1NF.
		To normalize the table into 1NF, a separate row needs to be created for each value in the multi-valued attribute as shown in lower part of Figure 11.2.

First Normal Form (1NF)