Enterprise Architect allows you to capture conceptual, logical and physical data models with one tool in the same model repository. You can import schemas from existing databases or automatically generate database scripts from your modeled schema, providing end-to-end traceability from concept to implementation.
Enterprise Architect's built-in Data Modeling profile extends the UML to provide an intuitive mapping from the database concepts of tables and relationships onto the UML concepts of classes and associations. These extensions model database keys, triggers, constraints, RI and other relational database features. Enterprise Architect also supports Entity-Relationship (ER) notation.
When designing or documenting databases, Enterprise Architect will help to: