MP9002: Desktop Computing - Creating Database Models > Visio 2002

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. 

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

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

Duration:
4 Hours