Creating a physical data model diagram

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:

  1. In the Data Project Explorer, expand the Data Design Project that contains the physical data model that you want to diagram.
  2. In the physical data model, expand the folder of the schema that you want to diagram by double-clicking Data Models > physical_data_model.dbm > database_name > schema_name. 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.
  3. 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.

Feedback