Previous: Business Process Modeling and SimulationNext: Requirements Management

Information and Data Modeling

Sparx Systems

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.

Built-in data modeling profile

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:

  • Create a Data Model diagram to visualize your database schema
  • Create tables and views
  • Create columns, primary keys, foreign keys
  • Create stored procedures
  • Create indexes, sequences, functions and triggers
  • Generate DDL for a table or an entire package
  • Convert datatypes for a table, package or entire DBMS
  • Import a database schema from an ODBC data source.
Information and Data Modeling within Enterprise Architect
Click to enlarge

Database engineering support for major DBMS products

Enterprise Architect models and generates database schemas for numerous DBMS products:

  • DB2
  • Firebird
  • MS Access
  • MySQL
  • MS SQL Server
  • Oracle
  • PostgreSQL