BusGo: The Future of Bus Ticketing

A Final Year Project by BSCS Students (Session 2022-2024)

Project Background & Motivation

**BusGo** platform was conceived as the Final Year Project (FYP) for the 8th Semester of BSCS. The primary motivation was to transform the existing inter-city bus booking mechanisms in Pakistan by introducing a robust digital solution, making travel easier, faster, and more reliable for the average commuter.

Technical Architecture Overview

The system is built on a standard three-tier web application architecture utilizing **PHP** for server-side logic and **MySQL (MariaDB)** for persistent data storage. **Tailwind CSS** ensures a fully responsive and modern user interface, facilitating smooth navigation on both desktop and mobile devices. Security is maintained through prepared statements for database interactions and secure password hashing (`$2y$10$`).

Detailed Database Structure (Schema)

The BusGo system is built around the following relational database tables:

Management & Infrastructure

  • **cities:** Stores city names (`Karachi`, `Lahore`, etc.).
  • **terminals:** Defines specific bus stations within cities.
  • **routes:** Core table defining links between `from_terminal_id` and `to_terminal_id`, storing base fares.
  • **seat_layouts:** Defines the physical arrangement and total capacity (`total_seats`, `layout_json`) of different bus models.
  • **vehicles:** Maps a vehicle to a `seat_layout_id` and tracks registration/model.

Operations & Transaction

  • **schedules:** Links a `vehicle_id`, `route_id`, and `driver_id` to a specific, recurring `departure_time`.
  • **drivers:** Stores driver credentials and contact info.
  • **bookings:** Tracks individual seat reservations (`seat_no`, `schedule_id`) for a specific **`trip_date`** (crucial for daily recurring schedules), passenger details, and `payment_status`.
  • **users & admins:** Separate tables for passenger authentication and administrative access control.
College Students Working on Project

The BusGo Team during the development phase of their Final Year Project.

Developed By

  • Aman Zonish
  • Tahira Emen
  • Sibgha Maryam

    • Academic Context:

    BSCS 8th Sem | Final Year Project

    Session: 2022-2024

    Contact the Team