Visio 2002: Creating Database Models

Products

Resources

Specials

Summary:

This training course explains how to create database models that provide a visual representation of a database schema. This training course describes the stencils and templates users can use to draw database models and provides a detailed explanation of the process of drawing a database model. It also explains how to use wizards that can extract a database model from an existing database and update that model when the database changes.

Objectives:

After completing this training course , students will be able to:

Identify the templates available in the database solution
Create a database model using the Database Model Diagram template
Create a Database Model Diagram based on an existing database
Update a Database Model Diagram to reflect changes to an existing database
Explain how you can generate a physical database from a Database Model diagram

Outline:

Understanding the Database Model Diagram Template
Using the Express-G Template
Using the Object Role Modeling Template
Reverse-Engineering a Database Model
Defining Tables
Defining Columns
Defining Foreign Key Relationships
Defining Data Types
Creating Indexes
Creating Views
Adding Local Code
Adding Global Code
Updating a Database Model

Features:

Exercises that allow users to practice the application
A file containing the text of the exercises
Activities that allow users to apply training course concepts in an interactive questioning environment
Simulations that allow users to practice training course skills, even if they don't have access to the application
A glossary
A Skill Assessment

Applicability:

This training course is for users who have some familiarity with Windows applications, as well as database modeling and database modeling notation, and who want to get the most out of Visio 2002.

Prerequisites:

Visio 2002: Using Tools, Commands, Custom Toolbars, and MenusVisio 2002: Working with Objects and HyperlinksVisio 2002: Using the Shape MenuVisio 2002: Working with ShapesVisio 2002: Defining and Using Styles, Custom Properties and TemplatesVisio 2002: Working with Pages, Layers, and StencilsVisio 2002: Working with DataVisio 2002: Understanding ShapeSheetsVisio 2002: Working with Flowcharts

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

Visio 2002® is a registered trademark of Microsoft Corporation

Terms of Use:

None