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