Posted by: dwixmilanisti on: May 3, 2009
ERD initial image:

ERD of the image above is less clear about the relationship between the entity the entity to the project, and I assume the relationship is 1 to N, where one section has many projects, and one project only owned one part only. Besides, from the ERD will be creating a new table is the table work. The table was because the relationship between the employee entity to which the project entitiy M to N, so create a new table.
a. 1NF normalization form of ERD from above:

Form above is a form of Normaslisasi 1NF. These fields obtained from the above attributes in the entity except KONTROLPEG field. Field is obtained from the relation of 1:1 entity employees and employees of entities to entities PART. Where a lot of employees to control personnel 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. FD is a functional attribute of Dependency where the arrow means that the attribute designated by the arrows, depending on the value of the attribute that points, for example, the attribute that points FD1 is NOPEG so that all attribute values are dependent upon the NOPEG.
b. 2NF normalization form:
1NF form from above and with Functional Dependency happens then obtained a second 2NF normalization form as follows

c. 3NF normalization form:
2NF form from above and with Functional Dependency happens then obtained a second form of 3NF normalization as follows
