Week 7

In this time, I have given a description of ERD in subjects ADSI. But I see some gaffe in ERD  . Here is the ERD :
from the picture above, we can see 2  awkwardness that is:
1. no cardinality between PART and PROJECT
2. Ternary relation between TANGGUNGAN and PROJECT
On the ERD that can be changed according to the business process logic. I ERD can be improved as below:

I add 1-N cardinality in relationships and PROJECT and BAGIAN because:
– 1 BAGIAN can handle a lot of PROJECT and,
– Many PROJECT  can be handled by 1 BAGIAN

The goal of fix ERD is doing so at the  mapping tables from ERD, the results from the mapping table as much as possible into the form of 2NF or 3NF if the mapping is done correctly.

Therefore, it is then there are rules that I use during the mapping. Rules are:
1. If the relation 1-N in the primary key (1) move to (N) and vice versa applies.
2. If the relationship M-N will be created a new table with the primary key of each entity will be became the primary  key in the new table.
3. If the relationship 1-1 then choose  higher  cardinality to put primary key for a foreign key in relation table .
4. If the dependent relationships of the primary key table dependent primay key derived from the mother entity.

So from that rules, i struggle to mapping that ERD, here isi the tables :

pemetaanFro that mapping above, we can see that tables created from mapping have meet 3NF normalization.  Because the relation should not have a nonkey attribute functionally determined by another nonkey attribute ( or by a set of nonkey attributes). That is, there should be no transitive dependency of a non key primary key.

One Response to “Week 7”

  1. How I Lost Thirty Pounds in Thirty Days

    Hi, interesting post. I have been thinking about this issue,so thanks for posting. I’ll certainly be subscribing to your blog.

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s