Creating_ERD_in_MS_Visio_2010

Creating_ERD_in_MS_Visio_2010 - Creating Entity...

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

View Full Document Right Arrow Icon
Creating Entity Relationship Diagrams in MS Visio
Background image of page 1

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

View Full DocumentRight Arrow Icon
Creating Entity Relationship Diagrams in MS Visio © 2011 DeVry Educational Development Corporation 4/19/2011 Page 2 of 18 Contents 1. Introduction . ....................................................................................................................................................... 3 2. Starting MS Visio In Citrix . ................................................................................................................................. 3 3. Once Visio is Started . ........................................................................................................................................ 3 4. Completing the Entity Relationship Diagram . ................................................................................................. 12 5. Modifying an Existing Relationship . ................................................................................................................ 14 6. Submitting Your Work . .................................................................................................................................... 17 Table of Figures Figure 1: Selecting the Software Database Template . ............................................................................................... 3 Figure 2: Selecting the Database Model . ................................................................................................................... 4 Figure 3: Document Options: General . ...................................................................................................................... 5 Figure 4: Document Options: Table . .......................................................................................................................... 5 Figure 5: Document Options: Relationships . .............................................................................................................. 6 Figure 6: Creating Entities . ........................................................................................................................................ 7 Figure 7: Database Properties: Entity Definition . ..................................................................................................... 8 Figure 8: Database Properties: Columns . ................................................................................................................. 9 Figure 9: Creating Relationships . ........................................................................................................................... 10 Figure 10: Creating Relationships (con't) . .............................................................................................................. 11 Figure 11: Database Document Options: Relationships . ....................................................................................... 12 Figure 12: Entity Relationships . ............................................................................................................................... 13 Figure 13: Modifying Existing Relationships . .......................................................................................................... 14 Figure 14: Modifying Existing Relations (con't) . ..................................................................................................... 15 Figure 15: Reading a Relationship . ......................................................................................................................... 16 Figure 16: Copying a Diagram . ............................................................................................................................... 17 Figure 17: Pasting ERD into MS Word . .................................................................................................................. 18
Background image of page 2
Creating Entity Relationship Diagrams in MS Visio © 2011 DeVry Educational Development Corporation 4/19/2011 Page 3 of 18 1. Introduction This tutorial demonstrates the process of setting up Microsoft Visio to create both a Relational Diagram (RD) and an Entity Relationship Diagram (ERD) with Crow's Foot notation and relationship naming. You can either use MS Visio on Citrix or use a copy installed on your computer. You can get a free copy of MS Visio from the Student Software Store (see the Course Home for the link). This tutorial is not an all-inclusive tutorial, but instructions here that are demonstrated with a simple Entity Relationship Diagram are sufficient for you to complete the first couple of lab assignments. As you progress in the course, you will learn about more advanced and finer details of creating Entity Relationship Diagrams and how to display the advanced features in an MS Visio Entity Relationship Diagram. 2. Starting MS Visio in Citrix 1. If you are using Citrix, after you have logged into a Citrix session select Microsoft Office 2010 applications. 2. Open the MS Office folder. 3. Select and double click Microsoft Visio 2010 to start the application. 3. Once Visio is Started Under the Template Categories, select Software and Database. Figure 1: Selecting the Software Database Template
Background image of page 3

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

View Full DocumentRight Arrow Icon
Creating Entity Relationship Diagrams in MS Visio © 2011 DeVry Educational Development Corporation 4/19/2011 Page 4 of 18 1. When the Software and Database templates are displayed, select and click on the Database Model Diagram template.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/31/2011 for the course CIS 321 taught by Professor Comptonw during the Spring '10 term at DeVry Chicago.

Page1 / 18

Creating_ERD_in_MS_Visio_2010 - Creating Entity...

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

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