First Normal Form
In the first normal forms, each field in a table contains different information or data

Task ID # Task Description Employee ID Due Date Last Name
1 Management meeting 02 02/17/2008 Gauss
2 Create Budget 02 01/01/2008 Gauss
3 Employee reviews 01 02/1/2008 Coulomb
4 Employee reviews 02 02/1/2008 Gauss



The first normal form shows all the entities that would be included in the database. All these fields are needed so that the 2nd and 3rd normal form can take place.


Second Formal Normal
In second normal form, each field in a table that is not a determiner of the contents of another field must itself be a function of the other fields in the tables. Here we have two tables, Task (Task_ID, Task_Description, Due_Date) and also Employee (Employee_Id, Last_Name)

Task_ID Task_Description Due_Date
1 Management meeting 02/17/2008
2 Creating Budget 01/01/2008
3 Employee Review 02/01/2008
4 Employee Review 02/01/2008



Employee_ID Last_Name
02 Gauss
01 Coulomb










The diagram above is showing you that one or more employee as one or more task to do.
The TASK is DEPENDENT UPON THE EMPLOYEE
TASK EMPLOYEE

Third Normal Formal

No Duplicate information is permitted. All transitive dependencies are removed. A transitive dependency is when a relation contains data that are not part of the entity.
Task ID Employee ID Date
1 02 02/17/2008
2 02 01/01/2008
3 01 02/01/2008
4 02 02/01/2008



In the third normal form the Task is DEPENDENT UPON the Employee and the Task_date is DEPENDENT TASK.


 
Conclusion

The process of Normalization is removing redundancy in any given table so that the table is easier to modify. A number of normal forms have been developed to remove redundancies that may be found. A normal form is a rule about allowable dependencies. Each normal form removes certain kinds of redundancies.
Normalization create data that are stored only once on a file. It provides ideal data storage for database systems.