Minggu, 03 Mei 2009

TUGAS NORMALISASI

Image Problem :



Resolving of Problem :

Mapping of ERD image above:




NORMALIZATION OF MAPPING ABOVE :1NF/First Normal Form


An relationship told by first normal form, if and only if every monovalent attribute to each;every line. Every field only one congeniality, not such a word corps having two meaning, only one just meaning as well as is not fraction of words so that its other meaning. There no setting attribute which repeatedly or valuable attribute duplicate.





2NF/Second Normal Form


Normal Definition Form second (2 NF) is :
1). Fulfilling form 1 NF (first normal).
2). Attribute is not key shall hinge functionly at main key / key primery
So that to form normal both second every tables / file shall be determined by its attribute keys



3NF/Third Normal Form


Normal Definition Form Third ( 3 NF) is :
1). Fulfilling form 2 NF (normal second).
2). Attribute is not key do not have transitif dependensi to main key / key primery