How do I make an entity relationship diagram in Visio?

  1. Open Microsoft Visio.
  2. Click the File menu, select New, then Database, and then Database Model Diagram.
  3. On the menu bar, click Database, then Options, and finally Document.
  4. In the new window, select the Relationship tab.
  5. Check the Crow’s Feet box under Show and click Ok.
  6. Drag and drop Shapes onto Drawing to create Diagram.

How do I create a crow’s foot ERD in Visio?

You can set Crow’s foot notation by using the Database tab (or menu, depending on your version) in Visio. Click the Database tab, and then click Display Options. On the Relationship tab, select the Crow’s feet check box, and then click OK.

Does Visio do ERD?

An entity relationship diagram (ERD) illustrates how different entities (such as customers and products) relate to each other in a database. Here are the the three primary parts of an ERD: Entities: The tables in your database.

How do I add a Database tab in Visio?

  1. Select File > New.
  2. Under Template Categories, select Software and Database, and then select Database Model Diagram.
  3. On the right side, select either Metric Units or US Units, and then select Create.
  4. On the Database tab of the ribbon, in the Manage group, select Display Options.

How do I make a table in Visio 2013?

Build a table with Visio shapes

  1. Drag the Grid shape from the Shapes window to the drawing page.
  2. In the Shape Data box that appears when you release the shape, enter how many rows and columns you want in your table.
  3. To make the table bigger or smaller, drag the sizing handles on the shape sides.

How do I show data types in Visio database diagram?

Display data types in a database model diagram

  1. Open the database model diagram.
  2. On the Database menu, point to Options, and then click Document.
  3. In the Database Document Options dialog box, click the Table tab, and then, under Data Types, click Show physical or Show portable.
  4. Click OK.