Information System Analisis and Design

Normalization part2

Posted by: dwixmilanisti on: May 3, 2009

ERD initial image:
gambar-awal
ERD of the image above is less clear about the relationship between the entity the entity to the project, and I assume the relationship is 1 to N, where one section has many projects, and one project only owned one part only. Besides, from the ERD will be creating a new table is the table work. The table was because the relationship between the employee entity to which the project entitiy M to N, so create a new table.
a. 1NF normalization form of ERD from above:
gambar-fd1
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. FD is a functional attribute of Dependency where the arrow means that the attribute designated by the arrows, depending on the value of the attribute that points, for example, the attribute that points FD1 is NOPEG so that all attribute values are dependent upon the NOPEG.

b. 2NF normalization form:
1NF form from above and with Functional Dependency happens then obtained a second 2NF normalization form as follows
fd2

c. 3NF normalization form:
2NF form from above and with Functional Dependency happens then obtained a second form of 3NF normalization as follows
fd3

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.