PICTURE OF ERD
Create the normalization of this ER-Diagram
First step before doing normalization, which must we do is to do un normalization of data that exist in ER-DIAGRAM. Form of un normalization table of this ER-DIAGRAM is :
After forming un normalization table, from this table we make its first normal form ( 1NF) table. Matter which need to be done is to dissociate data to correct attribute. Its First Normal Form is :
First Normal Form ( 1NF) Table :
Second Normal Form – 2NF
After first normal Form have fulfilled, hence we make Second normal form table by doing decomposition for relationship above to become some new relationship and look for primary key from every relationship and key attribute shall be unique. From this First Normal Form Table we earn to see that there is some candidate key which later can become to be primary key primary among others, they are :
(NOPRO,NOBAG, NOPEG), Here are the Second Normal form :
Fd1 (NOPRO, NAPRO, LOKAPR) -> Proyek table
Fd2 (NOPEG, NAPEG, TGLLAH, KDPOS, ALM1) -> Pegawai table
Fd3 (NOBAG, NABAG, LOKASI) -> Bagian table.
Fd4 (NOPRO, NOPEG, NAMA,JNKELT, HUBUNGAN) -> Tanggungan table.
Fd5 (NOPRO, NOPEG, JAM) -> Kerja table.
Third Normal Form – 3NF
After form 2NF have fulfilled, the next phase is create table which fulfill from 3NF. From some description that informed that 3NFnormal Form will fulfilled if form 2NF fulfilled, and otherwise there don’t non primary key attribute own depended to other non primary key attribute (depended transitive). While from tables above that fulfill to form 2NF there are some non primary key attribute which is dependence on other non primary key they are such as age attribute (“UMUR”) which is dependence on birthday attribute (” TGLLAH”) and address attribute (” ALM1″) which is dependence on postal code attribute (” KDPOS”) so that need to normalization again become third normal form (3NF)
Pegawai table (NOPEG, NAPEG, TGLLAH, KDPOS).
Alamat table(DPOS,ALM1)
UMUR table(TGLLAH,UMUR)
