RideFlow DB

RideFlow DB is a full-stack SQL Server database project simulating a ride-hailing platform (like Uber/Careem). It covers the complete data lifecycle — from a normalized operational database (OLTP) to a full analytical data warehouse (OLAP), connected by an ETL pipeline.

Key components:

13-table OLTP schema in 3NF with EERD diagram

Supertype/subtype hierarchies (Rider, Admin, Full/Part-time Drivers)

Stored Procedures, Views, Indexes & ACID Transactions

Star-schema Data Warehouse (FactTrip + 4 Dimensions)

ETL pipeline loading operational data into the warehouse

Analytical queries with Window Functions (RANK, LEAD/LAG) for KPIs