Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
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
Field/Button |
Action |
See also |
|---|---|---|
|
Add Model(s) to Package |
Displays the name of the selected root Package. |
|
|
Technology |
Click on 'Database'. |
|
|
Name |
If necessary, expand the Database Engineering group of Patterns. Click on the checkbox against each Database Management System you are covering in the model. |
|
|
All |
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. |
|
|
None |
Click on this button to clear all selected checkboxes so that you can re-select certain checkboxes individually. |
|
|
OK |
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
Notes
- 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
