Chapters

Introduction

• Introduction to Data Modeling

Design Steps

• Normalization

Schema Types

• Snowflake Schema
• Star Schema
• Data Vault 2.0

Table Types

• Slowly Changing Dimensions

Schema Designs

• Schema Design for Food Delivery App using Star Schema Approach
• Schema Design for Hotel Reservation System using Data Vault 2.0 Approach
• Schema Design for Consumer Banking using Star Schema with SCD-II
• Insurance Policy Center Schema

Sample Data Models

• Sample Data Models