Design And Implementation Of Database Graphical Design Tools

Traditional database design and development usually takes three steps to complete:firstly, hand-drawn ER diagram, and then manually to DDL (Data Definition Language) statement. Finally, execute the code in the database management system. Developer not only needs to provide ideas throughout the process, but also need to do a lot to deal with the end result of manual operation.How can reduce the nonessential manual operation, lets the development personnel concentrate as far as possible to the work for designing and development, and how can enable the beginner also to complete the design and the development work for the database, These are ER Translator's concept——the user only concerned with the work what needed attentting. With the help of ER translator, database design ideas can be quickly converted by the software ER diagram and then generate DDL code, and finally according to user-specified database information to create tables in the corresponding database. But also depending on the circumstances of the generated DDL code after the implementation, making the whole process simplify and flexible. The database design tool for graphical (DDTG) is a solution to simplify the database design and development in this context.In the process of ER Translator system development and practical application, displays the design thought of the user which focus on database in the system, so users can have an overall understanding. The system-generated DDL codes after ER design completed for visual display to the user or modify user-friendly learning. Finally just configurate the local database information and then can create tables. The whole process improves productivity for the users greatly.