Minggu, 03 Mei 2009

ERD quiz

ERD example :




Erd of the above relationship between the entities cardinality PART with entities and entity PROJECT PROJECT ternary to have an incomplete explanation. I think the relationship between the entities with the entity PROJECT PART is 1: N where one part can have many projects and one project is owned by only one part only.








NORMALISASI
1NF and 2NF


























For table TANGGUNGAN and KERJA have no primary key,,so I do not normalism that sesion.
For the 3NF normalization. First, determine attribute from above which have transitive dependency, that is: