[Project 02]
Designed Mock SQL Schema for BOLTS (Thailand)
Database SQL
Database Systems for BOLT Ride-Hailing App (Thailand)
[Project Overview]
An end-to-end development of a database for BOLT Application of Thailand using SQL, along with Extended Entity Relationship Diagram.
[Details]
As part of my Database Systems course(DSA-306) at Thai-Nichi International College, I led the design and implementation of a relational database system for Bolt Thailand—a ride-hailing platform similar to Grab. This project involved end-to-end development, from requirement analysis to SQL optimization, using Oracle Live SQL and LucidChart.
[Industry]
Database SQL
[My Role]
Primary Developer
[Platforms]
Oracle Live SQL
[Timeline]
Sep 2024 - Nov 2024
[My Contributions]
[01] Database Architecture
Designed an EER model with supertype-subtype relationships and normalized tables to 3NF for data integrity.
[02] SQL Implementation
Built 18+ tables in Oracle Live SQL, including:
Ride Management and Payment Processing
User Analytics
[03] Complex Queries
Real-time ride tracking (e.g., driver-passenger matching)
Fare calculation and promo code discounts (RidePromotions)
Passenger trip history and driver performance reports
[04] Team Coordination
Organized tasks and documentation (Google Docs) to align with project milestones.
[Key Learnings]
Database Design Principles
Learned to structure tables with clear relationalships and constraints
SQL Query Optimization
Gained experience writing efficient queries for real-world data use cases.
Simulating Real-World Systems
Understood how to tranlsate business logic inot functional databas model.