ERD quiz
Is given by the following ERD :
Settlement:
From the ERD, there are some explanations that are less about the cardinality relationship between the BAGIAN entity with PROYEK entity and between PROYEK entities to the ternary. So I assume that the relationship between the BAGIAN entity with PROYEK entity are 1 : N where one can have the many projects and one project is owned by only one part only. For PROJECT entities to ternary, I use cardinality N where an employee can have many projects and one project is owned by an employee only.
At the PEGAWAI entity, there is composite attribute that is address attribute. In the making of 1NF is each of the attributes may not be composite, So to write the ALAMAT attribute which is a fraction of the written that address attribute is ALM1 attribute and KDPOS attribute.
From ERD diagram above there is 2 error, that is:
Ø Between table BAGIAN and PROYEK No cardinality .
Ø To determine foreign key between table PEGAWAI and BAGIAN on relation PIMPIN.
Ø No relation from table PROYEK to ternary, because table PROYEK has have relation KERJA with table PEGAWAI.
So, I try to improve ERD as following:
ERD
• I give cardinality between table BAGIAN to table PROYEK with relation 1 to N (one to many).
• I give participation from table BAGIAN to table PEGAWAI the relation is total, in order to I can determine which one table that get foreign key from relation PIMPIN.
• I remove relation between table PROYEK to ternary, because table PROYEK has have relation KERJA with table PEGAWAI.
MAPPING
NORMALISASI
1NF and 2NF
For table TANGGUNGAN and KERJA don’t need to normalization, because that tables don’t have primary key.
For the 3NF normalization. First, determine attribute from above which have transitive dependency, that is:
