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:
.jpg)