Normalization Exercise
ERD:
Settlement:
From the ERD, there are some explanations that are less about the cardinality relationship between the BAGIAN entity with PROYEK entity and between PROYEK entities to the ternary. So I assume that the relationship between the BAGIAN entity with PROYEK entity are 1 : N where one can have the many projects and one project is owned by only one part only. For PROJECT entities to ternary, I use cardinality N where an employee can have many projects and one project is owned by an employee only.
At the PEGAWAI entity, there is composite attribute that is address attribute. In the making of 1NF is each of the attributes may not be composite, So to write the ALAMAT attribute which is a fraction of the written that address attribute is ALM1 attribute and KDPOS attribute.
So the form of a normalization of ERD over as follows:
Form above is a form of Normalization 1NF. These fields obtained from the above attributes in the entity except KONTROLPEG field and PIMPINAN. This field obtained from the relation of 1:1 PEGAWAI entity and from PEGAWAI entity to BAGIAN entity. Where a lot of employees that controlled by an employee and an employee just controlled by an employee. An employee can lead the section and only led by an employee of the course. FD is functional Dependency from attribute where the arrow means that the attribute designated by the arrow, The value depend from the point of attribute, for example in FD1 the attribute which point is NOPEG so that all attribute values are dependent upon the NOPEG.
From the 1NF form above and with Functional Dependency happen, then obtained a second 2NF normalization form as follows:
In 2NF form table has been separated in accordance with the Functional Dependency happens.
From the 2NF form above, then obtained the form of 3NF normalization as follows:
From the form above can be seen that 3NF form is equal with 2NF form because when it is created to 2NF form, a whole of attribute in table just depend from the only one attribute in that table. This is in accordance with the requirements of 3NF form that is in a table all of attributes must depend in an attribute that function as a primary key.
