Define a relationship in a Database Model diagram

Create a relationship in a database model diagram

1. Make sure both tables are visible in the diagram. If you reverse engineered the model from an existing database, you may need to drag one or both tables from the Tables and Views window onto the drawing page.

2. Double-click the table you want for the primary key side of the relationship.

3. In the Database Properties window, under Categories, click Columns.

4. In the grid, click the column you want to use to uniquely identify each row in the table and select the PK check box to set it as the primary key.

5. From the Object Relational or Entity Relationship stencil drag a Relationship shape and drop it onto a blank space on the page.

6. Connect the higher end to the table with the parent table.

7. Connect the other end to the child table.

   If the second table doesn't already contain a column with the same name as the primary key, the modeler adds it to the second table as a foreign key.

Remove a relationship from a database model

1. Click the relationship in your model and press delete.

2. In the Delete Object dialog box do one of the following:

   • Click Yes to remove the relationship from both the drawing and the underlying model.

   • Click No to remove only the line on the drawing.

     Note: If you click No and later decide to add the line back into the drawing, select one of the tables in the relationship and, on the Database menu, click Show Related Tables.

Define a relationship as one-to-one or as one-to-many

The cardinality of a relationship describes how many rows in one table can relate to how many rows in another table. For example, one department can have many employees, but an employee can belong to only one department. Cardinality is usually expressed as one-to-one, one-to-many, and many-to-many.

1. Double-click the relationship.

2. In the Database Properties window, under Categories, click Miscellaneous.

3. Under Cardinality choose the cardinality that fits the relationship best. For one-to-many relationships that would be either Zero or more or One or more. For one-to-one relationships that would be either Zero or one or Exactly one.

Can't find the database modeling features?

It is most likely that your edition of Visio doesn't include the features you are looking for. To find out which edition of Visio you have, click About Microsoft Office Visio on the Help menu. The name of the edition is in the top line of text in the dialog box.

Visio Standard does not include the Database Model Diagram template.

Visio Professional and Premium editions support the reverse engineering features for the Database Model Diagram template (that is, using an existing database to create a model in Visio) but it does not support forward engineering (that is, using a Visio database model to generate SQL code).

If you are using Visio Plan 2 and want to learn about how to engineer an existing database into a database model, see the topic, Reverse engineer an existing database.