Course Outline
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
