QUIZ 8

NORMALIZATION


ERD:



Process the Database Device

Collect the requirement user / business, Develop the E-R Model pursuant to requirement user business and Convert the E-R Model to relationship gathering ( tables of) of relationship Normalization to eliminate the anomali Implementation to database by making table to each;every relationship normalization.



First Normal Form (1NF)
First normal form (1NF) sets the very basic rules for an organized database. 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.Form above is a form of Normaslisasi 1NF. These fields obtained from the above attributes in the entity except KONTROLPEG field. Field is obtained from the relation of 1:1 entity employees and employees of entities to entities PART. Where a lot of employees to control personnel and an officer of the only controlled by an officer of the course. An employee can lead the section and led by only one employee only.



Second Normal Form (2NF)

Second normal form (2NF) further addresses the concept of removing duplicative data:
- 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) .


Third Normal Form (3NF)

Third normal form (3NF) goes one large step further:
- Meet all the requirements of the second normal form.
- Remove columns that are not dependent upon the primary key.