DB2 Logical to Physical Design Transition
 

This 1 day course:

is intended for all personnel involved in the Logical to Physical design implementation of Relational Database systems. The course reviews the Database Design Life Cycle as it pertains to any RDBMs and incorporates specifics as to the physical implementation of your design in DB2.

Topics Covered:

• DB2 and the z/OS and OS/390 Environment
• Database Structures
• Logical Database Structures
• Physical Database Structures
• Data Integrity & Object Relational Extensions

Duration: 1-day

Delivery: Class lecture

Audience: 

All personnel involved with DB2.

Prerequisites: none

Outline:

1. DB2 Environment

     RDBMS Overview
     DB2 Structural Overview
     Data Structure Management
     Database Design Life Cycle Review
     The Logical to Physical Transition Process
     ER Model
     Process Model
     Table/Process Matrix
     Normalization vs. De-normalization

2. Database Structures - Logical Objects

     Databases
     Table Design
     Column Design
     Row Design

3. Database Structures - Physical Objects

     Tablespaces
     Indexes
     Access Design

4. Data Integrity & Object Relational Extensions
     Data Integrity
     Referential Integrity
     Constraint Rules
     UDTs & UDFs
     Using Views
     Triggers