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 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
