You can create a diagram of a physical data model to visualize
or edit the model.
Before you begin
You must create or open a data design project and a physical
data model before you can create a physical data model diagram.
Physical
data model diagrams can use Information Engineering (IE) or Unified
Modeling Language (UML) notation. You can change the default notation
style for physical data model diagrams in the preferences. You cannot
change the notation style after you create the diagram.
Procedure
To create a physical data model diagram:
- In the Data Project Explorer, expand
the Data Design Project that contains the physical data model that
you want to diagram.
- In the physical data model, expand the folder of the schema
that you want to diagram by double-clicking . Where physical_data_model is
the name of the physical data model in the Data Design Project, database_name is
the name of the database in the physical data model, and schema_name is
the name of the schema in the database.
- Under the schema, right-click the Diagrams folder
and then choose to either create a blank diagram or automatically
include elements in the diagram:
- To create a diagram that automatically includes some or all
elements of the physical data model, click New Overview
Diagram. You can specify a name for the diagram and select
the elements that you want to include before you click OK.
- To create an empty diagram, click New Blank Diagram.
You can then use the palette to add elements, or you can click and
drag objects from the Data Project Explorer onto
the diagram.
Results
The new diagram opens in the diagram editor. The diagram is
also displayed in the
Diagrams folder under
which you created it, and also in the
Data Diagrams folder
for the project.