||Since the rise of object-oriented programming language, object-oriented system development get more and more attention. Consistency, completeness and correctness of the design class diagram will determine the system success or failure. Currently, entity relationship model and normalization technique for structured system design has developed clear principles and a process steps, but lack of complete discussion for object-oriented system design yet. This paper research object oreiented normalization theories through the object-oriented encapsulation, inheritance and polymorphism characteristics, proposed object-oriented principles of first to fourth normal form, and convert the principle into specific seven-step object-oriented design class diagram modeling process which will generate a normalized database, and provide a system operation architecture with object-oriented characteristics.|
To complete class normalization study, considering class operation normalization based on the normalized steps of strustured system design, eliminating complex operation to prevent from overlapping functions is proposed in first object normal form. Eliminating common operation to prevent from cross-object-access operation is proposed in second object normal form. Eliminating resemble operation to meet inheritance and polymorphism characteristics is proposed in third object normal form. Eliminating multi-dependent operation to prvent from multivalued dependencies is proposed in fourth object normal form. According to above-mentioned, a clear and concise system design class modeling method is proposed.
Based on the above, the contribution are eliminating multivalue attribute, complex attribute and complex opeartion in the first step, eliminating part dependency, transitive dependency and common operation in the second step, eliminating resemble operation to meet inheritance and polymorphism characteristics in the third step, establishing Class to meet encapsulation characteristics in the fourth and fifth step, eliminating multivalue dependent attribute and multi-dependent operation in the sixth and seventh step, making system design with object-oriented characteristics, achieve consistency, completeness and correctness.
Jim Arlow & Ila Neustadt, 2006，物件導向系統分析與設計，邱孝賢、康凱雄譯，學貫行銷，台北。
Margaret S. Wu & Shih-Yen Wu, 1994, Systems Analysis & Design, West Group.
Martin Fowler, et al, 2003，重搆 : 改善旣有程式的設計，侯捷、熊節譯，碁峄資訊，台北。
Ambler, S., 1996, About the Third Rule of Class Normalization, Computing Canada, Vol. 22.
Amir Hassan Bahmani, Mahmoud Naghibzadeh & Behnam Bahmani, 2008, Automatic database normalization& primary key generation, Electrical & Computer Engineering, CCECE 2008 Canadian Conference on.
Elisa Bertino, Giovanna Guerrini & Isabella Merlo, 2000, Trigger inheritance & overriding in an active object database system, IEEE Transactions on Knowledge & Data Engineering, Volume:12 , Issue: 4.
Fakhar Ladhi′ & Hassan Mehdi, 2003, Normalization of object-oriented design, Multi Topic Conference, INMIC 2003, 7th International.
Nuraini Abdulganiyyi & Noraini Ibrahim, 2014, Semantic Abstraction of Class Diagram Using Logical Approach, Information & Communication Technologies (WICT), 2014 Fourth World Congress on.
R. Godin & P. Valtchev, 2005, Formal concept analysis-based class hierarchy design in object-oriented software development, In Formal Concept Analysis, volume 3626 of Lecture Notes in Computer Science.
Yonghui′ Wu, et al, 2000, Implementation & Proof for Normalization Design of Object- Oriented Data Schemes. Technology of Object-Oriented Languages & Systems, TOOLS - Asia 2000. Proceedings. 36th International Co-
Zhongping Zhang & Zhixiao Liu, 2012, Fourth Normal Form & Free Redundancy for XML Document Based on Path Expression, 2012 2nd International Conference on Computer Science & Network Technology.