Based upon the Chen Entity Relationship Diagram (ERD), Database Design Studio Lite adds features that make it the leader in Enhanced Entity Relationship Diagram modeling.

Database Design Studio Lite Feature List

• Enhanced Entity Relationship Diagram modeling allows you to design a fully relational database, complete with Cascading Referential Integrity Constraints, Indexes, Checks, Defaults and Unique constraints.

• Data Structure Diagram that is created automatically from the Enhanced Entity Relationship Diagram shows the complete table structure.

• Data Definition Language (DDL) Scripts for creating, dropping and loading the database can be quickly and easily generated for all of the supported database servers.

• Supports All Major Databases including Oracle, DB2, SQL Server, Informix, Sybase, MySQL, PostgreSQL, Interbase, Access, SQLBase, Ingres, ANSI and MicroSQL.

• Template Language to define the Data Definition Language scripts allows you to create the scripts exactly as you want them.

• Project Manager for managing the files that are used and generated by the application. Full support for Windows Shell such as delete to the recycle bin, drag and drop, file renaming etc.

• Integrate Tools from the Database vendors to execute the Data Definition Language scripts directly within the application.

• Cross DBMS Target Compatibility allows you to design once and create for all. No need to concern yourself with vendor specific variations to SQL syntax. All is handled by the application.