Program Description

I am looking to design a tool which takes as an input the Entity Relationship Diagram(ERD) of a data base and the Entity Type Specification(ETS), it then generates the data base described by the ERD and ETS.

Going deeper

using some ajax techniques the service will be provided online through a web browser or it may be provided through a desktop application. This tool will provide the ability to draw both ERD and ETS, it then uses the suitable Data Base Connectivity to connect to the specified DBMS to generate the described data base.

How generation is done?

first the program will generate all the SQL commands needed to create the tables, then the SQL commands about the user will be sent to the DBMS which in turn executes the SQL Commands.
of course each user will has a private account specified by user name and password where these information will be used to access just his area only where he can manipulate his data base.

Benefits

First : making the data base creation faster and more generic, that is the user will be independent of the DBMS used to create his DB.
Second : a good DB documentation that will help for further changes in the future or for sharing it with others.
Third : for non technical users, they will not have to waste a lot of time learning SQL commands, just a simple guide to the ER shapes and an easy GUI will help them design their DBs very fast