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

Combo Packs... »

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

Read More

Monthly Specials - Big, Big Savings!! »

We always offer several special offers with savings from $50-$100 & more! Check out this month's special offers...

Read More

© 1999-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

HTML

A+

Windows 2000

Excel 2000

Office 2000

More Courses

e-Learning Links

Student Feedback

Certification Info

Other Resources

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