NORMALIZATION

ER-DIAGRAM




Normalization process model data :

• Found the main entities in the model data
• Found the relationship between each entity
• Determine the attributes of each entity

Figure 1:
We must describe data in the ER-diagram into tables form



Figure2:
A table is in first normal form if all the key attributes have been defined and it contains no repeating groups.



Figure 3:
A table is in second normal form (2NF) if and only if it is in 1NF and every non key attribute is fully functionally dependent on the whole of the primary key (i.e. there are no partial dependencies).
As seen in the table of Pegawai, table of Pegawai has the transitive dependency between its entities.

Transitive dependencies:
NoPeg --> TglLah
TglLah --> Umur



Figure4:
A table is in third normal form (3NF) if and only if it is in 2NF and every non key attribute is non transitively dependent on the primary key (i.e. there are no transitive dependencies).