preview

Data Analysis and Data Modeling in Visio

Decent Essays
Open Document

Lab – Data Analysis and Data Modeling in Visio

Overview

In this lab, we will learn to draw with Microsoft Visio the ERD’s we created in class.

Learning Objectives

Upon completion of this learning unit you should be able to:

▪ Understand the concept of data modeling

▪ Develop business rules

▪ Develop and apply good data naming conventions

▪ Construct simple data models using Entity Relationship Diagrams (ERDs)

▪ Develop entity relationships and define various types of attributes

Lab Goals

Our lab goals are to:

1. Learn to build conceptual models in Microsoft Visio.

2. Create the 5 ERDs from class in Microsoft Visio.

You will accomplish this by drawing the 4 diagrams from …show more content…

Part 2: Microsoft Visio for Conceptual Modeling Walk-Thru

Overview

In this section, we will walk-through creating a conceptual data model with Microsoft Visio. We will use the vBay! (E-bay “like” website case study as an example for conceptual modeling.)

To Create an Entity:

Drag the [pic] icon onto the page and drop. Name the entity in the database properties window:
[pic]

YOU DO IT:

Now add these 4 Entities to your diagram:

[pic]

To Add Attributes to the entity:

To add attributes to your entity, simply click on the columns section of the database properties window, and enter in your column names. Be sure to include the appropriate attribute descriptors [rucdm] with the physical name. Ignore the data type Req’d and PK columns. Those are used in logical modeling.
[pic]

YOU DO IT:

Now add attributes to all 4 entities, like this:

[pic]

To Add Relationships among the entities:

To Add Relationships, simply drag the appropriate relationship cardinality (for example: [pic]) onto the page and connect the ends to each entity. To “snap” the line to the entity drag the line end onto the box until it turns red, like this. Red symbolizes the shapes are glued together:
[pic]

After to glue both ends of the line to an entity, you can double-click on the line to assign it a label. For example:

[pic]

YOU DO IT:

Now add

Get Access
Related
Get Access