The First Normal Form - 1NF

To transform a table in a first normal form - 1NF, we must remove all repeating groups of fields.

Thus, the intersection of one row and one column of the table corresponds to a simple value (atomic data). To do this we must eliminate the repetition of information and create separate tables for related data. Transforming the initial Departments table of our example as we described earlier we created the new table with the 1NF structure as follows. Another approach to 1NF is to create a new table removing from the initial table the fields that cause problems. The new table Dept_Locations will contain the field deptLacation with the primary key of the table Departments. Thus, in 1NF our data model will be transformed in two tables as follows. Departments                     Dept_Locations As you can see the tables above are in 1NF, as well as its fields have only simple values. But, there are still repeating data in these tables. That means during their content management problems will arise with the insertion, modification and deletion operations. To fix this situation we transform the table from 1NF to 2NF.