Current Proceedings on Technology
Yazarlar: Mohd Zainuri Saringat, Rosziati Ibrahim, Noraini Ibrahim, A.M. Adeshina
Konular:-
Anahtar Kelimeler: Schema tables,Class diagram,Rules,Object oriented.
Özet: 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.