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. Enterprise Architect provides a Pattern for each DBMS supported by the system, containing a number of settings specifically for Data Modeling such as connector notation and setting the DBMS at the Package level.
Access Project Browser | Right-click on root 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.
|
|
Notes
| · | For each Database Management System you are modeling, two child Packages are created under the selected Package in the Project Browser: Logical Model will be empty, and a Package that is automatically given the name of the DBMS will contain a child Package for each database object that the selected DBMS supports, such as Database Functions, Procedures, Tables and Views |
| · | Data modeling diagrams generated from a Model Pattern default to the notation IDEF1X; those created through the New Diagram dialog default to Information Engineering |
| · | At this point you can begin to develop your model in one of two ways: |
| · | Through the Project Browser and diagrams, working more freely across the model as you need to (topics within the Physical Data Model section) |
| · | Through the Database Builder, constructing the model using the structure and support of the Database Builder wizard (topics within the Database Builder section) |
Any structures you create through the Project Browser and diagrams will be automatically represented in the Database Builder; however, structures created in the Database Builder are not automatically added to your diagrams - you must place them in the appropriate diagram manually
Learn more
