AWERProcedia Information Technology & Computer Science 1 (2012) 699-708 2 nd World Conference on Information Technology (WCIT-2011) Constructing schema tables from class diagram Mohd Zainuri Saringat a *, Rosziati Ibrahim a , Noraini Ibrahim a and A.M. Adeshina a a Faculty of Computer Science and Information Technology Universiti Tun Hussein Onn Malaysia Parit Raja, 86400 Batu Pahat. Johor, Malaysia Abstract System design is an important phase in the system development life cycle (SDLC). Object-oriented approach is convenient to facilitate real situation and works well in complicated system. The approach has a mature Unified Modelling Language (UML) with 13 diagrams in modelling of the system. Class Diagrams are the most diagrams created during analysis and design and are the only diagrams that have represented data semantic. In object-oriented technique, one class in class diagram will be transferred to one table in schema table. However, this technique has led to data redundancy when the schema tables are used in defining the database. Many researchers are doing research to find the best solution to defining database structure from class diagram. Since, the mature approach is not well defined; we propose to consider three main steps in creating schema table from class diagram. First step is based on the class information in class diagram. Second step is to consider the user interface. Last step is embedding of the data sanitization concept to remove unused attributes in schema tables. The result from this research will be congruent with the third normal form. The database structure is reflected to user view and it will accelerate accessing time accordingly. Furthermore, it will increase the usage of database storage with removing unnecessary data stored in it. Therefore, we have suggested a rule as a well form in designing the schema tables from class diagram. Keywords: Schema tables; Class diagram; Rules; Object oriented. Selection and peer review under responsibility of Prof. Dr. Hafize Keser. ©ϮϬϭ2 Academic World Education & Research Center. All rights reserved. 1. Introduction Computer is a well known machine that has become part of human life nowadays. Computer must consist of four parts; the hardware, software, data and the people. Data which is referred to as raw fact must be organized carefully to produce correct information [1]. The place to store data in computer system is called database. * ADDRESS FOR CORRESPONDENCE: Mohd Zainuri, Saringat, . Faculty of Computer Science and Information Technology Universiti Tun Hussein Onn Malaysia. E-mail address: zainuri@uthm.edu.my/ Tel.: +6-019-777-0636