Auto Database Schema Generator

Abstract

Conceptual modeling is a very important phase in designing a successful database application. A database is defined as a collection of data which is accessed by more than one person and probably used for more than one purpose. The aim of this study is to Available software tools which take the database designer from the data analysis stage, through to physical database design and generate the database schema automatically by drawing entity relationship diagram.[4] To study the problem and test the proposed solution has been to apply the following steps: analysis requirement and determine the (Entity, Attributes, Relationships).Then drawing entity relationship and testing the three phases of structural databases: conceptual (Includes the important entities and the relationships among them.), logical (describes the data in as much detail as possible, without regard to how they will be physical implemented in the database) and physical (represents how the model will be built in the database.). Then generate the database schema automatically, the diagram will be saved in the database allocated to the program, which enable you to retrieve the diagram from the database to make any edits. Tests results in this study showed that the system ADBG (Auto Database Generator) works Effectively in drawing entity relationship diagram and saves this scheme accurately, the results of tests also showed that the program available software tools which take the database designer from the data analysis stage, through to physical database design and generate the database schema automatically by drawing entity relationship diagram and maintains the progress of the drawing process and the generation of error-free, and finally generates database schema an accurate.