I have givened an ER Diagram :
ERD in the above, there are 2 that confusion can lead to an error occurs, namely:
1. On the relationship between the BAGIAN and the PROYEK does not have a clear cardinality.
2. There is a ternary relationship have on the relationship.
So i repair the ER, and this my project.
Mapping of ER Diagram above :
1 NF and 2NF Normalization
- pegawai
this table decomposit to three table
- bagian
this tabel, decomposit to two table
- kerja
- proyek
- tanggungan
normalizatiom mapping
1. If the relation 1-N in the primary key (1) move to (N) and vice versa applies.
2. If the relationship M-N will be created a new table with the primary key of each entity will be became the primary key in the new table.
3. If the relationship 1-1 then choose higher cardinality to put primary key for a foreign key in relation table .
4. If the dependent relationships of the primary key table dependent primay key derived from the mother entity.
