Create a Data Model from a Model Pattern

The easiest way to create a Data Modeling workspace is to use the predefined Database Model Patterns, available through the Model Wizard. Enterprise Architect provides a Pattern for each DBMS supported by the system.

Access Project Browser | Right-click on Package | Add a Model Using Wizard (Ctrl+Shift+M)

Create a Data Model



See also

Add Model(s) to Package

Displays the name of the selected root Package.


Click on 'Database'.


If necessary, expand the Database Engineering group of Patterns.

Click on the checkbox against each Database Management System you are covering in the model.


Click on this button to select the checkboxes for all Database Engineering model types and the Entity Relationship diagram, to include them all in the model.


Click on this button to clear all selected checkboxes so that you can re-select certain checkboxes individually.


Click on this button to add to the Project Browser the Packages and diagram for each Database Management System you are modeling.

What each Data Modeling Pattern provides

  • A summary diagram of the model
  • A Report Specification Artifact element (on the summary diagram) that can be used to quickly document the data model
  • A Package for each of the Logical and Physical models
  • Within the Physical Model Package, a predefined hierarchy of sub-Packages, one for each object type supported by the DBMS being modeled (such as Tables, Views, Procedures and Functions); these automatically organize the database objects as they are added
  • The DBMS type for the workspace
  • A default owner
  • A data modeling diagram in each Package with the connector notation set to IDEF1X


  • Once a data modeling workspace has been created, you can begin to develop your model in one of two ways:
         -  Through the Database Builder, which is a purpose-built view that supports database modelers
         -  Through the Project Browser and diagrams, which is the traditional method that might suit users who are experienced UML modelers

Learn more