Select a cardinality notation: IDEF1X, Relational, or Crow's feet

In this article

Select a cardinality notation: IDEF1X, Relational, or Crow's feet

About IDEF1X, Relational, and Crow's feet notation

Select a cardinality notation: IDEF1X, Relational, or Crow's feet

  1. On the Database menu, point to Options and then click Document.

  2. For IDEF1X or Relational:

    • On the General tab, under Symbol set click IDEF1X or Relational.

  3. For Crow's feet:

    • On the Relationship tab, under Show select the Crow's feet check box.

  4. Click OK.

Top of Page

About IDEF1X, Relational, and Crow's feet notation

There are many different ways to display cardinality (like one-to-many). The Database Model Diagram template offers shapes for the two most popular methods: IDEF1X and Relational. Relational notation is selected by default when you open a new database model diagram. Both of these show the properties of relationships by changing the format of the table shapes and the relationship lines.

In addition to those styles you can choose to use the Crow's feet notation with either of them. Crow's feet notation changes only the ends of the relationship lines.

IDEF1X notation

In IDEF1X notation a solid circle indicates the foreign key side of the relationship (child table). If the child isn't required to have a parent there is an empty diamond at the parent side of the relationship.

Non-identifying relationships are drawn with a dashed line; identifying ones with a solid line.

The cardinality is shown as:

(Blank)

One to zero or more

P

One to one or more

Z

One to zero or one

1

One to exactly one

Two numbers separated by a dash

a range

Relational notation

In Relational notation a solid arrow indicates the parent table.

Identifying relationships are indicated by the foreign key being placed in the top row with both the PK and FK designations.

The cardinality is shown as:

*

One to zero or more

1..*

One to one or more

0..1

One to zero or one

1

Exactly one

Two numbers separated by a dash

a range

Crow's feet notation

Crow's feet notation indicates the parent table and optionality by using a standard set of marks that can be on either side of the relationship.

Empty circle and crow's foot

Zero or more

Single hatch mark and crow's foot

One or more

Single hatch mark and empty circle

Zero or one

Double hatch mark

Exactly one

Top of Page

Applies To: Visio 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language