Part B: Star Schema Design

File: createStarSchema.PractII.VarmaA.R

Purpose: Creates the empty database structure (tables) for our analytics warehouse.

Analogy: Building the skeleton of a house before adding furniture. We're creating the rooms (tables) before filling them with data.

🎯 What This File Does (Step-by-Step)

Step 1: Connect to MySQL

• Uses the connection function from Part A
• Connects to Aiven cloud database

Step 2: Clean Up Old Tables

• Drops existing tables if they exist (fresh start)
• Order matters: fact table first, then dimensions (due to foreign keys)

Step 3: Create Dimension Tables

• dim_date - Calendar information (year, month, week, day)
• dim_country - Country names (Deutschland, Österreich, etc.)
• dim_sport - Sport categories (Ice Hockey, Ski Jumping, Inline Hockey)

Step 4: Create Fact Table

• fact_streaming_summary - Main analytics table
• Stores aggregated daily statistics per country per sport

Step 5: Create Staging Table