Object-Oriented Analysis and Design: Transformation from Class Diagram to Relational Table and Application Template

Abstract

Modeling software with object-oriented technique (OOT) and unified modeling language have become the new paradigm of modem systems analysis and design. Many approaches and CASE tools have been introduced to facilitate the transformation from class diagram to object-relational database and application template and thereby enhance the efficiency of system development. Model Driven Architecture (MDA) and Rational Rose is such an approach and CASE tool, respectively.
This research presents a systematic methodology which integrated the MDA with OOT concepts to transform the class diagram into object-relational database and application template during the system development process. A real-world case using the integrated techniques is presented and the Rational Rose is used to illustrate the concepts, application, and the advantages of using the proposed methodology. With this approach, the system developer can transform class diagram into object-relational database and application template automatically and thereby enhance the efficiency of system development.