Data Analysis and Data Modeling in Visio
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 the class exercise. You will have to hand in all 4 diagrams by FTPing them to your account space on the IST-S-STUDENTS server and then pasting the url to the diagram in the text boxes for this week’s learning unit assessment.
What you will need to begin
1. A copy of Microsoft Visio 2003 (or higher)
2. The Visio Conceptual Modeling Stencil conceptual modeling.vss (should be with the other files from this week’s lesson)
3. The class exercises from this week (should also be with the other files from week’s lesson.)
Part 1: Getting Ready for Using Microsoft Visio for Conceptual Modeling
Overview
This section will explain how to use Microsoft Visio to create conceptual Entity-Relationship data models. Microsoft Visio has built-in database tools for creating logical data models (those that apply the relational database theory to your entity-relationship diagrams), and not very good at conceptual modeling. As a result, using the MS Visio database tools to create the conceptual model diagrams can sometimes feel like trying to jam a round peg into a square hole.
Since not many people are into shoving round pegs into square holes, this guide will explain how you can maximize the Visio database tools for
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 the class exercise. You will have to hand in all 4 diagrams by FTPing them to your account space on the IST-S-STUDENTS server and then pasting the url to the diagram in the text boxes for this week’s learning unit assessment.
What you will need to begin
1. A copy of Microsoft Visio 2003 (or higher)
2. The Visio Conceptual Modeling Stencil conceptual modeling.vss (should be with the other files from this week’s lesson)
3. The class exercises from this week (should also be with the other files from week’s lesson.)
Part 1: Getting Ready for Using Microsoft Visio for Conceptual Modeling
Overview
This section will explain how to use Microsoft Visio to create conceptual Entity-Relationship data models. Microsoft Visio has built-in database tools for creating logical data models (those that apply the relational database theory to your entity-relationship diagrams), and not very good at conceptual modeling. As a result, using the MS Visio database tools to create the conceptual model diagrams can sometimes feel like trying to jam a round peg into a square hole.
Since not many people are into shoving round pegs into square holes, this guide will explain how you can maximize the Visio database tools for