Minggu, 03 Mei 2009

Normalization: An Exercise

ERD to make easier:






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





second normal form, table of pegawai increased to 2 table:





Same as in the second normal form, the changes only on the table pegawai only.