Minggu, 03 Mei 2009

NORMALIZATION

There is example ER Diagram that normalization will be done :



Based on the above ERD, we can do process Mapping as follows:


For the normalization process, the need to do is remove the recurrence occurred on the table. Once we do this before the table is already in the form of 1NF.



In the second normal form, table of pegawai increased to 2 table.


A relationship is said to satisfy the third normal form relations, when the relation meet the second normal form and he attributes that are not key is not transitive dependent on the key itself. Same as in the second normal form, the changes only on the table pegawai only.