• Building a logical data model of increasing complexity and accuracy
• Transforming a logical model into a physical model for a relational database
• Using object oriented and semantic modeling techniques to refine a model
• Identifying classic structures and patterns which may be reused among many different models.
• Learn about star schemas, snowflake schemas and data warehouse models
• Introduce the use of a data model diagramming tool and CASE tools
• Consider the physical objects of a relational database and how they implement a logical model.

ABOUT DATA MODELING & RELATIONAL DATABASE DESIGN
• WHAT IS DATA MODELING? • ABOUT SYSTEM DESIGN METHODOLOGIES • MORE ABOUT CASE TOOLS

BUILDING A SIMPLE DATA MODEL
• IDENTIFYING ENTITIES • IDENTIFYING ATTRIBUTES • A SIMPLE MODELING SCENARIO • IDENTIFYING RELATIONSHIPS • A SIMPLE DATA MODEL SOLUTION

ACHIEVING A MORE ACCURATE MODEL
• SUPPLEMENTING THE REQUIREMENTS SPECIFICATION • REFINING THE ATTRIBUTE DEFINITIONS • REFINING THE RELATIONSHIP DEFINITIONS

TRANSFORM DATA MODEL INTO APPLICATION DATABASE MODEL
• ABOUT APPLICATION DATABASE MODELS • TRANSFORMATION TO RELATIONAL MODEL

SEMANTIC & OBJECT ORIENTED MODELING
• DEFINING DOMAINS • DEFINING SUPERTYPES & SUBTYPES • DEFINING ARCS • DEFINING LATTICES

CLASSIC STRUCTURES & PATTERNS
• BASIC CLASSIC STRUCTURES • ADVANCED CLASSIC STRUCTURES

DATA MODEL IMPLEMENTATION USING RELATIONAL DATABASES
• RELATIONAL IMPLEMENTATION • SUPERTYPE & ARC TRANSFORMATION OPTIONS • MORE ABOUT A RELATIONAL DATABASE • RELATIONAL DATABASE OBJECTS • SQL DDL

DATA WAREHOUSE MODELS
• WHAT IS A DATA WAREHOUSE? • ABOUT WAREHOUSE MODELS & TERMINOLOGY • STAR SCHEMA MODEL • SNOWFLAKE SCHEMA MODEL• CONTRAST OLTP & WAREHOUSE DATABASES