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

Display the Model Wizard window using any of the methods outlined here.

In the Model Wizard window, select the 'Model Patterns' tab. In the 'Technology' panel, select 'Database'.

Ribbon	Design > Package > Insert > Insert using Model Wizard
Context Menu	Right-click on Package \| Add a Model Using Wizard
Keyboard Shortcuts	Ctrl+Shift+M
Other	Project Browser caption bar menu \| New Model from Pattern

Create a Data Model

Field/Button	Action	See also
Add 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 supporting 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