Below is an ER diagram that we normalization.
1NF
The Next Form above is a form of Normalization 1NF. These fields obtained from the above entities except in the attribute field KONTROLPEG and PEMIMPIN. Where a lot of employees to control personal and an officer of the only controlled by an officer of the course. An employee can lead the section and led by only one employee only. as an example is the attribute that points FD1 is NOPEG so that all attribute values are dependent upon the NOPEG.
2NF
At this stage, the table may have been separated with Functional Dependency has happened in 1NF. So that the image can be as follows:
3NF
All attributes in the table depend only on one attribute on the table. This is in accordance with the form of 3NF in the table all the attributes one must depend on the one attribute that serves as a primary key. We take the example in the BAGIAN table, that primary key is NOBAG and other attributes in the table depending on the BAGIAN NOBAG (NOBAG à (NABAG, LOKASI, PIMPINAN)). Table KERJA form relationships because of M: N between entity personnel and entities PROJECT.
