Search all of Office.com
 
Support / Visio / Visio 2003 Help and How-to / Creating Drawings / Database Diagrams / ORM Diagrams
 
 

Create an ORM diagram

Applies to: Microsoft Office Visio 2003

 

Show me an example

On the File menu, point to New, point to Database, and then click ORM Diagram.

 Tip   Before creating an ORM diagram, organize your thoughts by writing down the information you want the database to include. Use simple sentences to describe the objects that exist, how they are identified, and what roles they play.

Add and name an object type (entity).

Drag an Entity shape (to symbolize an object type) from ORM Diagram onto the drawing page.While the shape is selected, type the entity type's name.Press ENTER, and then type the entity reference mode in brackets.

Add and name a value type.

Drag a Value shape from ORM Diagram onto the drawing page.While the shape is selected, type the value type's name.

Indicate a subtype.

Drag a Subtype Connector shape from ORM Diagram onto the drawing page. Glue the end point End point image, which is plus sign in a green square to a connection point Connection point image - blue X on the subtype entity shape.

The end point turns red, indicating that the connector is glued to the shape. You can move the glued shapes without breaking the connection.

Glue the begin point Begin point image - green square with X inside (the arrowhead end) to a connection point Connection point image - blue X on the other entity type.

Do one of the following:

ShowIndicate a relationship, role, or fact between object types

Drag a predicate shape (Unary, Binary, Vertical Binary, Ternary, or Quaternary) from ORM Diagram onto the drawing page.

Use a predicate shape that contains enough role boxes to relate all of the object types (entity shapes) involved in the relationship. For example, use a Ternary shape to indicate relationships among three entities.

Drag a Role Connector shape from ORM Diagram onto the drawing page. Glue the begin point Begin point image - green square with X inside of the Role Connector shape to a connection point (connection point: A point on a shape where a connection point can be glued. You can create new connection points inside, outside, or on the perimeter of a shape using the Connection Point tool. Each of a shape's connection points is marked with a blue X.) Connection point image - blue X on an object type (entity shape) for which you want to define a relationship.

The begin point turns red, indicating that the connector is glued to the shape. You can move the glued shapes without breaking the connection.

Glue the end point End point image, which is plus sign in a green square of the Role Connector shape to the appropriate role box on the predicate shape (from step 1).Double-click the predicate shape. Place the insertion point between ellipses (or placeholders), and then type a name for the role an entity type plays.Repeat steps 2-5 for each entity for which you want to define a relationship.

ShowIndicate a relationship, role, or reference between an entity and a value

Drag the Role Connector shape from ORM Diagram onto the drawing page. Glue the begin point Begin point image - green square with X inside of the Role Connector shape to a connection point (connection point: A point on a shape where a connection point can be glued. You can create new connection points inside, outside, or on the perimeter of a shape using the Connection Point tool. Each of a shape's connection points is marked with a blue X.) Connection point image - blue X on an entity type (entity shape) for which you want to define a relationship.

The begin point turns red, indicating that the connector is glued to the shape. You can move the glued shapes without breaking the connection.

Drag a Binary or Vertical Binary shape from ORM Diagram onto the drawing page. Glue the end point End point image, which is plus sign in a green square of the Role Connector shape to the end of the Binary or Vertical Binary shape. Double-click the Binary shape to edit the text. Place the insertion point between ellipses or placeholders, and then type a name for the role an entity plays.

 Tip   To move the ellipses and names on a Vertical Binary shape to the other side of the shape, right-click the shape, point to Shape, and then click Flip Horizontal.

Show a nested object by creating an objectified predicate.

Click the Drawing Tools button Button image to display the Drawing Tools toolbar, and then click the Rectangle Button image tool. Draw a rectangle around the predicate shape (Unary, Binary, Vertical Binary, Ternary, or Quaternary) you want to identify as an objectified predicate. Right-click the rectangle, point to Shape, and click Send To Back. With the rectangle still selected, on the Format menu, click Corner Rounding, click the third option on the top row, and then click OK.

Do one of the following:

ShowIndicate a mandatory role constraint

Drag the Mand. Role Connector shape from ORM Diagram onto the drawing page. Glue the begin point with the black circle Begin point image - green square with X inside to a connection point (connection point: A point on a shape where a connection point can be glued. You can create new connection points inside, outside, or on the perimeter of a shape using the Connection Point tool. Each of a shape's connection points is marked with a blue X.) Connection point image - blue X on an object (entity shape).

The begin point turns red, indicating that the connector is glued to the shape. You can move the glued shapes without breaking the connection.

Glue the end point End point image, which is plus sign in a green square of the Mand. Role Connector shape to a predicate shape (Unary, Binary, Vertical Binary, Ternary, or Quaternary).

ShowIndicate a uniqueness constraint

Drag the Uniqueness Constraint shape from ORM Diagram onto the drawing page. Place the shape directly above or below the predicate shape (Unary, Binary, Vertical Binary, Ternary, or Quaternary) you want to constrain. Drag one of the endpoints (Begin point image - green square with X inside or End point image, which is plus sign in a green square ) so that the arrow stretches across the appropriate role box on the predicate shape.

ShowIndicate a frequency constraint

Drag the Frequency Constraint shape from ORM Diagram onto the drawing page. Place the shape near the predicate shape (Unary, Binary, Vertical Binary, Ternary, or Quaternary) you want to constrain.With the shape selected, type the frequency you want.

ShowIndicate a set comparison or equality constraint

Drag the Subset Constraint or Equality Constraint shape from ORM Diagram onto the drawing page. Place the shape between the predicate shapes (Unary, Binary, Vertical Binary, Ternary, or Quaternary) with roles you want to constrain. Glue the begin point Begin point image - green square with X inside of the Subset Constraint or Equality Constraint shape to a connection point (connection point: A point on a shape where a connection point can be glued. You can create new connection points inside, outside, or on the perimeter of a shape using the Connection Point tool. Each of a shape's connection points is marked with a blue X.) Connection point image - blue X on the appropriate role box on the predicate shape.

The begin point turns red, indicating that the connector is glued to the shape. You can move the glued shapes without breaking the connection.

Glue the end point End point image, which is plus sign in a green square of the Subset Constraint or Equality Constraint shape to the appropriate role box of the other predicate shape.

ShowIndicate a ring constraint

Drag the Ring Constraint shape from ORM Diagram onto the drawing page. Place the shape near the predicate shape (Unary, Binary, Vertical Binary, Ternary, or Quaternary) containing the two roles you want to constrain.Do one of the following:

If the two roles are part of a longer predicate, glue each endpoint (Begin point image - green square with X inside and End point image, which is plus sign in a green square ) of the Ring Constraint shape to one of the roles on the predicate shape. If the two roles are a binary predicate, select the Ring Constraint shape, and then on the Format menu, click Line, in the Pattern list, click None, and then click OK.

Right-click the Ring Constraint shape, and then click the type of ring constraint you want.

ShowIndicate an external constraint

Drag an external constraint shape (Ext. Freq. Constraint, Ext. P Constraint, Ext. Mand. Constraint, or Ext. Uniq. Constraint) from ORM Diagram onto the drawing page.Place the shape near the predicate shapes representing the roles you want to constrain. From ORM Diagram, drag a Constraint Connector shape onto the drawing page. Glue the begin point Begin point image - green square with X inside of the constraint connector shape to a connection point (connection point: A point on a shape where a connection point can be glued. You can create new connection points inside, outside, or on the perimeter of a shape using the Connection Point tool. Each of a shape's connection points is marked with a blue X.) Connection point image - blue X on the external constraint shape.

The begin point turns red, indicating that the connector is glued to the shape. You can move the glued shapes without breaking the connection.

Glue the end point End point image, which is plus sign in a green square of the constraint connector shape to the appropriate role box on the predicate shape (Unary, Binary, Vertical Binary, Ternary, or Quaternary). To change the frequency for the external constraint shape (Ext. Freq. Constraint, Ext. P Constraint, Ext. Mand. Constraint, or Ext. Uniq. Constraint), select the shape, and then type the frequency you want.

Save the diagram.