PART VIII: ANALYSIS AND DESIGN OF INFORMATION SYSTEM

NORMALIZATION

Given by ER diagram (under) . Your task is do normalization to ER that diagram and each its table.

ER- DIAGRAM

After understand ER -Diagram image upon, hereafter we do to process mapping and normalization of ER diagram image upon. Following is Mapping ER – diagram:

Explanation of Mapping ER diagram is:

1. Tabel Pegawai (Employee table) have No. PEG as primary key. and NO. BAG as foreign key. from sectioned table (tabel bagian). On table this have cardinality relationship n to 1 which is; To one instance on entity first gets to have many relationship with instance on entity secondly.
2. Tabel Bagian (sectioned table) have NO. BAG as primary key
3. Tabel Proyek (Project table) have NO. PRO as primary key. and NO. BAG as foreign key. from table part, and NO. PEG as foreign key. of employee table (tabel pegawai).
4. Tabel Tanggungan (Responsibility table) just memilki NO. PEG as foreign key of employee table (tabel pegawai).
5. Tabel Kerja (Job table) just has NO. PEG and NO. PRO as foreign key, any one of employee table (tabel pegawai) and project table (tabel proyek ).

Normalization of mapping ER diagram upon:

1NF (First Normal Form)

A table is said exist on normal form I if it don't exist on form un normalized table, where is happening multiplexing a sort field and enabling available field that null (empty).

2NF (Second Normal Form)

2NF normal form is accomplished in one table if have accomplished 1NF form, and all attribute besides primary key, as whole to have Functional Dependency on primary key. One table not accomplishes 2NF, if there is attribute which its dependency (Functional Dependency) just gets partial character only (just depend to one part of primary key.) If anything attribute that have no dependency for primary key, therefore that attribute has at move or is removed.

Transitive dependency:
NOPEG --> TGLLAH
TGLLAH --> UMUR

3NF (Third Normal Fom)

3NF normal form is accomplished if have accomplished 2NF form, and if no attribute non primary key one that have dependency to attribute non primary key one that another( transitive dependency ).