Visio 2002: Creating Database Models
Product Code: VIS210 Time: 4 Hour(s) CEUs: Available

Summary:

This course explains how to create database models that provide a visual representation of a database schema. This 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 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 course concepts in an interactive questioning environment
  • Simulations that allow users to practice course skills, even if they don't have access to the application
  • A glossary
  • A Skill Assessment

Applicability:

This 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 98 or higher. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher (5.5 or higher for MindLeaders Central) required. Macromedia Flash player 6.0 is recommended for full functionality, but not required to play the courses. Sound card, with speakers or headphones is recommended, but not required to play the courses. JavaScript must be enabled. Netscape and AOL browsers not supported.

Google

Copyright Information:


Terms of Use:

None

Copyright © 2004 MindLeaders. All rights reserved.