Creating ER Diagrams - C reating ER Diagrams with Visio P...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Creating ER Diagrams with Visio Pro Mote’s Notes 1/31/2011 Microsoft Visio is a line of popular business drawing programs that can be used to quickly create a wide rage of diagrams: building blueprints, street maps, project timelines, program flowcharts, network diagrams, process flow diagrams, . .. This document will illustrate the creation of crow's foot ER diagrams with the Professional Edition of Visio 2007. This version is installed on all computers in the CBA labs. It can also be downloaded at no cost to your own Windows computer. Getting Started As soon as you start Visio you will either need to identify a new drawing type (category) or select an existing file. For this example, select a new drawing with the Software and Database category and the Database Model Diagram template. A template (stencil) is simply a set of common shapes and connectors used in the type of drawing specified. Some templates only have a couple of shapes while others have dozens. Visio lets you use multiple templates on the same drawing if necessary. Only one template will be necessary to draw our ER diagrams.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Visio will then give you a blank worksheet (like graph paper) and the template containing the basic shapes and connectors for the chosen drawing type. Most crow's foot ER diagrams can be created with just two of the seven basic database shapes and connectors: entity and relationship. If your initial worksheet appears in the portrait orientation (as in this example), then you might want to rotate it to landscape orientation to make more effective use of your rectangular screen. To do this, select the Page Setup option from the File drop-down menu. In addition to the worksheet orientation, Page Setup allows you to change the scaling, paper size, margins, etc.
Background image of page 2
3 Entities Begin creating your ER diagram by clicking the Entity (table) shape on the template. Drag the entity shape to the worksheet. You can reposition it on the worksheet at any time. You
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 14

Creating ER Diagrams - C reating ER Diagrams with Visio P...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online