Total Time: 4 hour(s)

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.

Ojectives: 
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

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; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.