ERD-NORMALIZATION

In the ADSI tasks given ERD similar to this, students are expected to be able to perform the following normalization of the ERD, and each table.


ERD is shown from above that the PEGAWAI entity,TANGGUNGAN and PROYEK, where they connected with the relations PUNYA. This is a little confusing where the cardinality is not specified to the PROYEK.
PROYEK I do not have a relationship with the TANGGUNGAN relationship can be removed. ERD is so similar to this one.



At first not allowed normalization of multivalued attributes and composite attributes.
In the ERD for the Employee entity there are composite attributes, therefore a decomposition similar to this



Entity to the other table still, no changes

On the relationship between the PEGAWAI-PROYEK, cardinality is many to many, so bring a new table that is KERJA

Here is a mapping

Mapping From this we can see in the PEGAWAI table appears PEGKONTROL attributes and NOBAG, this is obtained with the scale of relations where relations cardinality lower / lighter then primary key will be the foreign key in the table that cardinality more high / heavy. So also with the table-the table the other.

description:
1-N: the higher is N