IST352 - Lab 3 Data Modeling Using Visio 2010

IST352 - Lab 3 Data Modeling Using Visio 2010 - IST352...

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

View Full Document Right Arrow Icon
IST352 – Information Analysis of Organizational Systems Lab 3 Data Modeling Fall 2011 Building Data Models using Microsoft Visio Building the data model is arguably the most important aspect of good database design. The data model is used as a vehicle that allows the Systems Analyst to experiment with the database structure before the actual database is actually built. This process is known as data modeling. With database tools becoming relatively easy to use, this data modeling step is often skipped resulting in poorly designed databases; therefore, making databases that perform poorly, difficult to maintain and difficult to store and retrieve data. During the data modeling process, the Systems Analyst collects the appropriate attributes, determines their data names and datatypes, and then organizes them into logical entities. The analyst can then use data modeling tools, like Microsoft Visio, to create a data model and to display the model in a way that it can be communicated and understood by the end user. In this lab exercise, we will explore Visio’s basic features for building a data model using Entity- Relationship Diagrams or ERDs. Visio is a powerful modeling tool that allows the analyst the flexibility to build and revise database models using a variety of database notations, as well as, saving the model in order to build the SQL for creating the physical database tables. Materials needed to do this Lab Microsoft Visio Learning Objectives The student will learn to: Describe database terminology: data model, ERD, crow’s foot notation, cardinality, one- to-many relationship, many-to-many relationships, attributes and associative (or composite or bridge entities) Identify and interpret business rules Build data models Use the basic functions and features of a database modeling tool, Microsoft Visio Lab Setup – Establishing Visio Parameters Microsoft Visio has an extensive library of functions and features that initially seem overwhelming. This library contains a number of Shapes Palettes that make it easy for Information Technology professionals to create data models and represent them as Entity Relationship Diagrams. To make it easier to build your ERDs set your parameters as follows: 1. Launch Visio Select Visio by clicking on the blue and white Visio icon or selecting Visio from the Start Programs Microsoft Office Visio . Sometimes you may find Visio as a separate implementation and not part of Microsoft Office. 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
IST352 – Information Analysis of Organizational Systems Lab 3 Data Modeling Fall 2011 2. Open up a new Visio Document To create an Entity Relationship Diagram select: File New Software and Database Database Model Diagram . You can use either the Metrics or US units. Visio will create an Entity Relationship Shapes Palette on the left side, a work area in the upper middle and a Database Properties area in the lower portion of your screen. You should see a screen that looks like this: 2 Drag these ERD symbols onto your work area.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 9

IST352 - Lab 3 Data Modeling Using Visio 2010 - IST352...

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

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