On this page
Data Base design and SQL generation tool
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.
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.
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.
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
Help improve this page
You can:
- Log in, click Edit, and edit this page
- Log in, click Discuss, update the Page status value, and suggest an improvement
- Log in and create a Documentation issue with your suggestion