Using Model Driven Architecture (MDA) for generating ER and .NET code models from an input PSM based on UML

Abstract

In this thesis, we demonstrate how developers can make use of the model driven architecture (MDA) techniques to make the software development process more reliable, robust and less costly. We will focus on discussing a set of transformation techniques that together, transform a PSM (Platform Specific Model) into a code model written in Visual Basic.NET and an ER (Entity Relationship) model developed using SQL (Structured query Language) and targeting the Microsoft SQL Server relational database management system. The source model is assumed to be represented using UML (Unified Modeling Language). A set of standards for defining transformation rules will be developed and these standards can act as guidelines for any developer wishing to produce a transformation tool to map between any two models. The work in concluded by the development of a transformation tool with a visual interface that accepts as input a UML class diagram and provides as output a .VB file containing all the Visual basic.NET code as well as a text file containing the necessary DDL (Data Definition Language) statements required to create the database tables as well as the relationships among them.