Better Efficiency in Combination with Enterprise Architect Version 12 !
Combination of Enterprise Architect and DBMode
When performing database design in Enterprise Architect, the Data Model Diagram is mainly used. The Data Model Diagram is an extended UML class diagram and is used for structural modeling of relational databases. In addition to UML, IDEF1X and Information Engineering formats are also available for expression of relationships between tables.
DBMode offers support features for more efficient database design in EA. DBMode provides like a Properties Dialog specialized for table definition, Lists for collective table management, Domains for more improved management of column definitions, Logical data checks and Consistency checks for table definition.
Additionally, DBMode provides an editable CRUD Matrix (Create, Read, Update and Delete) that shows relationships between tables and UML Elements generated in Enterprise Architect such as Use Case, Activity, Class, Requirement and so on.
DBMode exports one Table definition information to one Excel Sheet and multiple Tables' definition information to one Excel Workbook collectively. DBMode can also export Table Lists.
Forward / Reverse Engineering
Enterprise Architect can analyze existing Database (SQLServer, Oracle, MySQL, MS-Access etc). When you connect to a working Database via ODBC and execute the analytic feature, Enterprise Architect can create Database Model describing the structure of Database.
You can generate DDL (Data Definition Language) from an existing Database Model. You can create Tables, Views etc. by executing generated DDL to an existing Database via ODBC using the Database Builder window (Database Engineering toolset) implemented in Enterprise Architect version 12 and later. And you can execute arbitrary SQL to existing Database.