Week 7-ER Normalization

ER-Diagram

ERD in the above, there are 2 that confusion can lead to an error occurs, namely:

1. On the relationship between the entity and the project does not have a clear cardinality.

2. There is a ternary relationship have on the relationship.

Based on the above confusion, the ERD can be improved:

Mapping of ERD image above:

1 NF

First normal form (1NF or Minimal Form) is a normal form used in database normalization. A relational database table that adheres to 1NF is one that meets a certain minimum set of criteria. These criteria are basically concerned with ensuring that the table is a faithful representation of a relation and that it is free of repeating groups.

Second Normal form (NF 2) is:

1. Meets 1 of NF (normal first).
2. Non-key attributes must depend on the function key / primery key.

So that the second normal form for each table / file must be specified attribute keys.

3NF/Third Normal Form

Definition of Third Normal Form (NF 3) is:

1. Meet the 2 forms of NF (both normal).
2. Non-key attributes do not have a transitive dependency on the key / key primery.

Same as in the second normal form, the changes only on the table pegawai only.