An Automated Generation of Business Application using Entity Relationship Diagram and Business Process Model

Abstract

Software development life cycle (SDLC) plays a signi cant role in building a good quality software. SDLC has six stages listed as follows: Requirement Analysis, Design, Development, Testing, and Maintenance. The success of any of SDLC stages, the success of building the software. The design stage mimics the user requirements to vision document using well known models such as UML Models. Recently, there has been a lot of attentions in the automatic code generation from models to codes. In this study, we use two models the Entity-Relationship (ER) diagram and the Business Process Model and Notations (BPMN). These models are used together because of the limitation of BPMN to represent data. We have proposed a business application framework that maps ER and BPMN models to the business application code and make a connection between them. We mapped ER to the SQL le, LINQ to SQL classes les, and windows form application. We have also mapped from BPMN to windows work ow (WF). Furthermore, we suggested a connection method between BPMN and ER. In addition, We implmented the mapping method using windows form environments by building business application automatically that can select, insert, update, and delete from the database. And we developed a mapping from BPMN to activity in WF as well as developing the connection between ER and BPMN.