Normalization Exercise

from the picture, we can see ERD and make the table from it.



then, make 1NF and 2NF table with functional dependencies



Pegawai

• Nopeg -> Napeg,Tgllah,Umur,Alamat,Kdpos
• Nopeg -> Nobag
• Nopeg -> Bestempl

Bagian

• Nobag -> Nabag,Lokasi
• Nobag -> Pimpbag

Proyek

• Nopro -> Napro,Lokapr
• Nopro -> Nobag

however, kerja table and tanggungan table don't have to decomposition, because its a table of relation and dependency with no primary key.

then, 3NF functional dependency would be




reference :
NURAH AGUS SANJAYA ER, S.KOM,M.KOM. Slide ppt ke-6 : NORMALIZATION.