​

SWIFT RIDE HUB:

Ride sharing Management System​
​
​
​
​
​
​
​
​
​

Placer, Rainhoa Jean D.​

Sim, Karl Anthony B.
Pabro, Leah Mae C.

BSIT 2 - DAY
Fundamentals of Database​
Christine Marie Ordaneza

​
February 10, 2024
 TABLE OF CONTENTS

I.​ INTRODUCTION​ ​ ​ ​ ​ ​ ​ ​ 2
1.1 Objectives​​ ​ ​ ​ ​ ​ ​ ​ 3
1.2 Scope and limitations​ ​ ​ ​ ​ ​ ​ 3
II.​ REVIEW OF RELATED LITERATURE​ ​ ​ ​ ​ 4
III.​ SYSTEM DESIGN AND METHODOLOGY​ ​ ​ ​ 6
3.1 Entity-Relationship Diagram (ERD)​ ​ ​ ​ ​ 6
3.2 Database Schema​ ​ ​ ​ ​ ​ ​ 7
IV.​ IMPLEMENTATION PLAN​ ​ ​ ​ ​ ​ 9
4.1 Development Tools​ ​ ​ ​ ​ ​ ​ 9
4.2 Hardware Requirements​ ​ ​ ​ ​ ​ 9
4.3 Timeline​ ​ ​ ​ ​ ​ ​ ​ ​ 9
V.​ EXPECTED RESULTS​ ​ ​ ​ ​ ​ ​ 10
VI.​ REFERENCES​ ​ ​ ​ ​ ​ ​ ​ 11

1
 I. INTRODUCTION

1.1 Background of the Study

Commuting is an essential aspect of modern life, allowing individuals to travel to various
destinations for work, school, or other necessary activities. Public transit remains the primary mode of
transportation for many people, enabling access to locations that are not within walking distance. However,
public transportation systems often present a number of challenges, including long waiting times,
overcrowding, lack of available seating, and complicated payment systems. These challenges are particularly
evident during peak hours when demand for transportation services is high, leading to difficulties in finding
available vehicles and navigating the most efficient routes.

The emergence of ridesharing companies has sought to address some of these problems by offering
more flexible and convenient transportation alternatives. Swift Ride Hub is designed as a private hire car and
motor service platform that aims to streamline the ride-hailing process. By implementing a centralized
database system, Swift Ride Hub will efficiently manage bookings, driver information, and payment
transactions. This will enable real-time tracking of vehicles, allowing passengers to monitor their rides and
receive accurate fare estimates before booking.

The development of a database-driven system for Swift Ride Hub will significantly improve
operational efficiency and user experience. The system will optimize driver allocation, reduce passenger
wait times, and enhance data security for both customers and drivers. By integrating automated processes,
the platform ensures a seamless and reliable commuting experience, addressing the limitations of traditional
public transportation and taxi services.

2
1.2 Objectives
The aims of the proposed database system for Swift Ride Hub are:

●​ To develop and execute a database-driven platform that facilitates efficient real-time transportation
booking and scheduling.
●​ To enhance data precision and retrieval efficiency for all stakeholders.
●​ To enhance the efficacy of managing driver and customer information, hence ensuring seamless
operations.
●​ To create a database that consolidates booking, matching, and payment operations for customers and
drivers.
●​ Enhance client experience by optimizing travel requests and driver allocations, guaranteeing car
availability, and reducing wait times.
●​ To provide clear fare estimations and itemized breakdowns prior to booking confirmation.
●​ To enhance operational efficiency via enhanced ride routing and data analysis.
●​ To incorporate secure and adaptable payment alternatives for customers and drivers.

1.3 Scope and Limitations

The Swift Ride Hub system enhances ride-sharing through real-time booking, driver administration,
secure payments, and the optimization of ride-matching and route efficiency. It facilitates automated fare
computations, data analytics, and customer-driver interactions; nevertheless, it excludes vehicle
maintenance, offline bookings, and driver recruitment. Moreover, the integration of external services may be
restricted, and users bear legal or insurance liabilities. The platform is exclusively dedicated to improving
the ride-hailing experience within these limitations.

3
 II. Review of Related Literature

REVIEW OF RELATED LITERATURE AND STUDIES

The role of technology in transforming transportation and shaping customer perceptions of

ride-hailing services is a significant area of research. Studies have examined the impact of mobile apps,
GPS, and other technologies on user experience and service delivery. (e.g., Shaheen, S., Cohen, A. P., &
Zhai, Z. (2017).
Angkas' emergence as a motorcycle taxi service is a direct response to the specific transportation
challenges of Metro Manila. Its focus on motorcycle transportation allows it to navigate congested roads
more easily than traditional vehicles. News articles and reports (cited as grey literature) can provide valuable
insights into Angkas' business model, its growth, and its impact on the local transportation market. For
example, articles might discuss Angkas' safety training programs and its partnerships with motorcycle
manufacturers. (Mercurio, (2016).
The "habal-habal" phenomenon exemplifies the importance of informal transportation systems in the
Philippines. These systems often operate outside of formal regulations but provide essential mobility for
many people. Research on informal transportation can explore its advantages and disadvantages, including
its role in filling gaps in public transport, its impact on safety and traffic management, and its relationship
with formal transportation systems. For example, studies might investigate the socio-economic profile of
habal-habal drivers and passengers. (Guillen & Ishida, (2004)
The article correctly distinguishes between taxi-hailing apps (GrabTaxi, EasyTaxi), which connect
riders with existing taxi fleets, and personal chauffeur services (Uber, GrabCar), which utilize private
vehicles. Research can delve into the specific advantages and disadvantages of each model, examining how
they cater to different segments of the commuter market. For instance, taxi-hailing apps might be more
appealing to price-sensitive riders, while personal chauffeur services might prioritize comfort and
convenience. (Ba Bahjin, R. N., Esteban, G. E. P., Pamintuan, M. J., & Perez, M. J. (2015).
The rise of ride-hailing applications has fundamentally altered urban transportation paradigms.
Factors contributing to this shift include the widespread adoption of smartphones, increasing urbanization,
evolving consumer preferences for on-demand services, and the desire for more flexible and convenient
transportation options.(Shivers, R., Rahman, M. A., Faruk, M. J. H., Shahriar, H., Cuzzocrea, A., & Clincy,
V. (2023).

4
 This study specifically focuses on RHPs due to their dominant position within the broader platform
economy and the transportation platform economy. The substantial valuations of companies like Uber and
Didi Chuxing along with the emergence of other significant players like Lyft, Grab, and numerous smaller
competitors underscore the importance of understanding the dynamics of this industry. (Xiaoqing et al.,
Schleifer, (2019),
The ride-hailing industry has experienced phenomenal growth, fundamentally changing how people
navigate urban environments. Driven by user-friendly smartphone applications, travelers can conveniently
book rides from privately owned vehicles, enjoying benefits such as pre-estimated fares, real-time tracking
of their ride, and simplified reservation management. This surge in popularity can be attributed to several
factors, including increased consumer spending power, a growing preference for on-demand services, and
the emphasis on convenience, affordability, and comfort in modern transportation (Muhamad Rizki & T.
Joewono, 2021).
The ride-hailing industry is an integral part of the broader Mobility as a Service (MaaS) paradigm.
MaaS envisions a future where various transportation modes are seamlessly integrated and streamlined
through a unified digital platform, ultimately enhancing urban mobility and promoting sustainability.
Ride-hailing services represent a crucial element of MaaS, providing on-demand and flexible transportation
solutions that complement other modes. The synergy between ride-hailing and MaaS aims to create a
comprehensive urban mobility ecosystem where users can easily access and utilize a range of transportation
options, from public transit and shared bikes to ride-hailing and car rentals, all within a single platform
(Datson, J, 2016).
Transportation has been a fundamental component of urbanization, facilitating trade and economic
development. The integration of Information Technology (IT) into transportation began in the 1980s, with
advancements like GPS, autonomous vehicles, and electronic systems. The advent of the internet and
subsequent technological advancements have significantly impacted the transportation industry, enhancing
the daily commuting experience and contributing to further urbanization. Digitalized transportation systems
have provided commuters with easy access to information regarding taxis and other transport options, along
with various facilities, both financial and non-financial. This digital transformation has made transportation
more accessible, efficient, and user-friendly. (Balustrade and Stead, (2004).
The expansion of the internet and real-time information sharing have created opportunities for
innovation in the transportation sector. Traditional call taxi services have been replaced by mobile
application-based services, driven by the increasing adoption of internet services and smart devices (Gupta,
Tomar, Thomas, & Rajeev, (2018).

5
 [Link] Design and Methodology

3.1 Entity-Relationship Diagram (ERD)

A diagram describing the relationships between entities in the Swift Ride Hub application.

Diagram 1. ER model

6
3.2 Database Schema
Simplified ER diagram for Swift Ride Hub:
CUSTOMER: Stores information about customers.
Customer_ID: Unique identifier for each customer (Primary Key)
Payment_ID: Foreign key for payment.
First_name: First name of the customer.
Last_name: Last name of the customer.
Email: Email address of the customer.
Phone_number: Phone number of the customer.
Address: Address of the customer.
DRIVER: Stores information about drivers.
Driver_ID: Unique identifier for each driver (Primary Key).
Vehicle_ID: Foreign key for Vehicle.
Payment_ID: Foreign key for payment.
First_name: First name of the driver.
Last_name: Last name of the driver.
Phone_number: Phone number of the driver.
License_number: Driver's license number.
VEHICLE: Stores information about vehicles.
Vehicle_ID: Unique identifier for each vehicle (Primary Key).
Vehicletype_ID: Foreign key for each vehicle.
Plate_number: Vehicle license plate number.
Vehicle_type: Type of vehicle.
Capacity: Passenger capacity of the vehicle.
Driver_ID: Foreign Key referencing the DRIVER table.
BOOKING: Stores information about customer bookings.
Booking_ID: Unique identifier for each booking (Primary Key).
Customer_ID: Foreign Key referencing the CUSTOMER table.
Vehicle_ID: Foreign Key referencing the VEHICLE table.
Payment_ID: Foreign key for payment.
Booking_time: Date and time of the booking.
Pickup_location: Pickup location for the booking.
Dropoff_location: Dropoff location for the booking.
Distance: Distance of the trip.
Fare per km: Fare for the trip.
Status: Current status of the booking.
7
VEHICLE TYPE: Stores information about types of vehicle for bookings.
Vehicletype_ID: Unique identifier for each vehicle (Primary Key).
Motorcycle: Type of vehicle.
Car: Type of vehicle
PAYMENT: Stores information about payments for bookings.
Payment_ID: Unique identifier for each payment (Primary Key).
Booking_ID: Foreign Key referencing the BOOKING table.
Transaction_id: Transaction ID for the payment.
Payment_status: Status of the payment.​
Credit/debit: Method of payment.
Cash: Method of payment.

Relationships:
CUSTOMER & BOOKING (1:N):
One customer can make multiple bookings.
VEHICLE & BOOKING (1:N):
One vehicle can be associated with multiple bookings over time.
VEHICLE & DRIVER (1:1):
One driver can be associated with one vehicle.
VEHICLE & VEHICLE TYPE (1:1):
One vehicle associated with one type.
BOOKING & PAYMENT (1:1):
One booking has one associated payment.
CUSTOMER & PAYMENT (1:1):
One customer can be associated with one payment.
PAYMENT & DRIVER (1:1):
One payment should be received by one driver.

8
 IV. Implementation Plan

4.1 Development Tools

The Swift Ride Hub system will be developed using Microsoft Access as the primary Database
Management System (DBMS) for storing and managing ride-sharing data. MS Access is chosen for its ease
of use, integration with other Microsoft applications, and suitability for small to medium-scale database
management.

4.2 Hardware Requirements

The following hardware components are recommended for the database system:

Desktop Computer: Windows 10 or later that is compatible with MS Access.

Internet Connection: Required for data synchronization and software updates.

These tools and hardware ensure the smooth operation of the Swift Ride Hub system, allowing
efficient data management and ride-sharing processes.

4.3 Timeline
A Gantt chart that represents the timeline for project completion from January to February.

Table 1. Timeline

9
 V. Expected Results
The following is the supposed outcomes of the database:

●​ Efficient Booking Management: The system will allow for the efficient storage and retrieval of
booking information, including booking time, pickup/drop off locations, assigned vehicle, and
booking status. This will enable real-time tracking of bookings and facilitate efficient dispatching.

●​ Real-time Data Updates: The database will support real-time updates of vehicle availability and
booking status, enabling dynamic dispatching and improved resource allocation. We expect to
achieve a sub-minute update frequency for key data elements.

●​ Secure Data Storage: The database will implement security measures to protect sensitive customer
and financial information, ensuring data confidentiality and compliance with relevant regulations.

●​ Data-Driven Decision Support: The reporting capabilities of the database will provide management
with the data needed to analyze trends, optimize pricing, and improve overall service efficiency.

10
 VI. References

e.g., Shaheen, S., Cohen, A. P., & Zhai, Z. (2017) [Link]

Mercurio,(2016)Guillen&Ishida,(2004)[Link]
41368933_Assessing_the_impacts_of_green_supply_chain_management_and_frugal_product_innov
ation_to_the_sustainability_of_social_enterprises_in_the_Gawad_Kalinga_Enchanted_Farm/links/5e
bcb09e92851c11a8677f46/Assessing-the-impacts-of-green-supply-chain-management-and-frugal-pro
duct-innovation-to-the-sustainability-of-social-enterprises-in-the-Gawad-Kalinga-Enchanted-Farm.p
df#page=51
Ba Bahjin, R. N., Esteban, G. E. P., Pamintuan, M. J., & Perez, M. J. (2015)
[Link]
_Filipino_Values_on_Metro_Manila_Traffic-[Link]?1472191347=&response-content-disposition=
inline%3B+filename%3DBusina_Current_State_Innovation_and_Emer.pdf&Expires=1739033988&
Signature=eLBTUPIycfpxgscrPUOqphCnA8AqlSIbxmvVeoZLzhLTnoDpncY-yNXZAVGP-31qMa
HMRr4vpbBA7-uuWWeN3XvChwNSaKWm1-bqb9Y~gQ1vfqQJryQjGaVn22s-8CJloKCgKgMXbt
QAVh8krsTETO13zb2~QIXYkb18Lls~WuqO-5zRL-dc-2kq~8J-5cYJQtDucmO0NP22Tif0FMQIgY
1wj9~s0wEfEnyD8XJM34tFlgHr9PDipbzdlDjCC~wVWjhfpVkFqqQ-eUHSKCNo0jES8D8FMtUS
Danpk7iDUN1vqnZ~HFFqmqrWI4QBg1TULi77O050JkjRi~RBoyuQKg__&Key-Pair-Id=APKAJL
OHF5GGSLRBV4ZA#page=31
Shivers, R., Rahman, M. A., Faruk, M. J. H., Shahriar, H., Cuzzocrea, A., & Clincy, V. (2023)
[Link]
Xiaoqing et al., Schleifer, (2019) Muhamad Rizki & T. Joewono,(2021) Datson, J,(2016)
[Link]
Balustrade and Stead,(2004). Gupta, Tomar, Thomas, & Rajeev, (2018)
[Link]
_-Key_factors_influencing_customers'_usage_behavior_from_data_analytics_perspective/links/6214
bb5508bee946f3961e08/Online-App-Based-Cabs-Key-factors-influencing-customers-usage-behavior
-[Link]

11