Home » Course Catalog » Online Training Course Objectives and Outline
Visio 2002 Series: Creating Database Models
Product Code: vis210 Time: 4.0 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:

  • 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


Topics:

  • 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

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.



Return To Top

Training Courses | e-Learning Edge | Training Course Certifications | Training Course Sign-up
Student Center | Learning Resources | Free Courses | Privacy Policy | Contact e-Learning Center

Hot Topics
IT Courses
MS Certs
Web Design
MS Office
Programming
Business
Networking
VS .NET
Personal
Full Catalog

Christian Website

Member of the Better Business Bureau Better Business Bureau
Member since 2002
Subscribe today as a member to our I.T. department and capitalize on free courses and 20% discount on our laptop computers.

Combo Packs... »

Save even more when you sign up for a combination package. Our BEST values EVER!

Read More

© 1599-2009 SK Max. All rights reserved.

General IT Web Design Microsoft Certs


Desktop Computing Business Skills Personal Skills


Combo Packages Business Videos

Articles

Features

Benefits

FAQs

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeStudent Centere-ResourcesCorporate Information