Back

Back

Back

[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

VIew Project Report

VIew Project Report

VIew Project Report

[My Contributions]
[01] Database Architecture

Designed an EER model with supertype-subtype relationships and normalized tables to 3NF for data integrity.

[01] Database Architecture

Designed an EER model with supertype-subtype relationships and normalized tables to 3NF for data integrity.

[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

[02] SQL Implementation

Built 18+ tables in Oracle Live SQL, including:

Ride Management and Payment Processing

User Analytics

[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

[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

[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.

[04] Team Coordination

Organized tasks and documentation (Google Docs) to align with project milestones.

[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

Database Design Principles

Learned to structure tables with clear relationalships and constraints

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.

SQL Query Optimization

Gained experience writing efficient queries for real-world data use cases.

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.

Simulating Real-World Systems

Understood how to tranlsate business logic inot functional databas model.

Simulating Real-World Systems

Understood how to tranlsate business logic inot functional databas model.

Select this text to see the highlight effect

Create a free website with Framer, the website builder loved by startups, designers and agencies.