from the picture we can see 2 awkwardness that is:
1. no cardinality between PART and PROJECT
2. The ternary relationship between entity PEGAWAI, PROYEK, & TANGGUNGAN seems strange.
Here is the fixed ER diagram:
Now I want to TRY make the mapping of the ER-Diagram above:
Now from that mapping I want try to make Normalization.
First 1N F
1NF is relationship which each every intersection of line and column contain one and only one price.
Two 2NF
2 NF is relationship if fulfilling 1 NF and each every attribute is not key primary have depended functional fully key primary.
Tanggungan
For table Tanggungan not change.
Thre 3NF
3NF is relationship fulfilling 1 NF, 2NF and attribute which non key primary not have depended transitif key primary
