Auto Convert ERD to SQL Code (SQL Generator)

Abstract

Conceptual modeling is the most important stage in designing a database application successfully. The database is defined as a set of data that is accessed by more than one person and may be used for multiple purposes. The goal of the study is providing online software tool one of them transforms ERD to SQL code. Automatic generation of the SQL code from ERD is important; SQL code consuming time from developers to write, and is difficult to write by non-developers which gives rise to the need of automatic generation the code from ERD; which is a high level conceptual data model, that can greatly save the developing time, the aim of this study.

The testing of this study showed that, the SQL Generator system (Auto Convert ERD to SQL Code) works more effectively in drawing the entity relationship diagram and keeping the chart accurately. Also, the results of the tests showed that the system provides the software tools that take the database designer from the analysis stage to generate the instruction SQL.