Please note : This help page is for an older version of Enteprise Archtiect. The latest help can be found here.

Topic
Prev Next

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 > 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 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