Exercise

ERD

From ERD diagram I found there are two error:
• There have no cardinality between entity BAGIAN and PROYEK.
• There have no relation from entity PROYEK to ternary, because table PROYEK has have relation KERJA with table PEGAWAI.

I draw ERD to make easier to listen:
ERD



MAPPING
NORMALISASI
1NF and 2NF



For table TANGGUNGAN and KERJA have no primary key,,so I do not normalism that sesion.
For the 3NF normalization. First, determine attribute from above which have transitive dependency, that is: