Implementation of Normalization
ER DIAGRAM
then this is mapping for ERD above:
1 to N relationship, where one part has a lot of projects, and projects only a part of the property only. In addition, from the ERD will create a new table is a work table. The table is because the relationship between the employee entity where the project entitiy M to N, so create a new table.
1NF
-Eliminate duplicative columns from the same table.
-Create separate tables for each group of related data and identify each row with a unique column or set of columns (the primary key).
2NF
-Meet all the requirements of the first normal form.
-Remove subsets of data that apply to multiple rows of a table and place them in separate tables.
-Create relationships between these new tables and their predecessors through the use of foreign key( a field in a relational table that matches the primary key column of another table. The foreign key can be used to cross-reference tables) .
3NF
-Meet all the requirements of the second normal form.
-Remove columns that are not dependent upon the primary key.
refrensi:
http://databases.about.com/od/specificproducts/a/normalization.htm
ER Ngurah Agus Sanjaya. Slide Part 6 – NORMALISASI
