mAgGang!!!

its about less a month before magang,.dan aku tetep lum lese dengan proposal..
juga TA,.(walaupun TA yang kupikirin duluan)

i'm confused!!!
persiapan matang pun tak jua kelar!!

love,,isn't it?

hupss..

not from begining story..
gw malah cerita akhirnya "

.............................

sedih
.............................

"

gag tau kenapa
gw hanya mencoba menyukai dy, tapi malah pas gw uda seneng bisa deket, n kesel ma kelakuannya, dia udh jd milik yang lain. maybe, mank ga jodoh kali. but sometimes its hurt me for a second, why finding someone that i love so its too hard for me.

gw pernah gagal. dan gw akui belum spenuhnya gw sembuh. tapi apa karna itu cinta ga dateng lg dalam hidup gw?its shocking me!!!

whatever,,life must go even i have to through myself....
T_T

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.