Minggu, 03 Mei 2009

normalization assignment

This is the original diagram from the question :

Then we recreate the diagram to fix the problem on above diagram :
1. There’s no cardinality between entity BAGIAN and PROYEK. It should have been 1-N from BAGIAN to PROYEK. With logic : one BAGIAN may have many PROYEK, and one PROYEK may only have one BAGIAN.
2. The ternary relationship between entity PEGAWAI, PROYEK, & TANGGUNGAN seems strange.
It’s logical if the PEGAWAI has a relation with TANGGUNGAN (TANGGUNGAN be the weak entity because it’s dependant with the existence of the PEGAWAI). But if it’s also has a relation with PROYEK (be the ternary relationship), it may seems a little strange. It’s also supported with the existence of relation between PEGAWAI an PROYEK. Then why we must have a relation again with ternary relationship here? It seems irrational to me, so I delete the ternary relationship here, change them only with binary relationship (between entity PEGAWAI and TANGGUNGAN).
3. To determine the mapping later, we need to fix the relation PIMPIN between entity PEGAWAI and BAGIAN to gain the foreign key. So with the logic : one BAGIAN must be managed at least by one PEGAWAI, and one PEGAWAI must not managing one BAGIAN; we create the participation here partial-total from PEGAWAI to BAGIAN.
Then the fixed ER diagram is :

Then we create the mapping for this ER diagram :

After that, we then should make the normalization for 1NF first as follows :
For the 2NF normalization, the above normalization has also been the 2NF normalization. So we don’t have to normalize it again to 2NF normalization.
And then for the 3NF normalization, first we should determine which of the attribute from above has a transitive dependency. So then we may guess, the attribute which has the transitive dependency is :

Tidak ada komentar:

Posting Komentar