Name		Name	Last commit message	Last commit date
templates		templates
README.md		README.md
app.py		app.py
dashboard1.png		dashboard1.png
requirements.txt		requirements.txt
schema.sql		schema.sql

Repository files navigation

Public Transportation Optimization System

A web-based dashboard for managing urban transit.

Tech Stack

Frontend: HTML5, Bootstrap 5
Backend: Python (Flask)
Database: MySQL (Triggers, Stored Procedures, Views)

How to Setup

Import schema.sql into your MySQL Workbench.
Install dependencies: pip install -r requirements.txt.
Update app.py with your MySQL password.
Run the app: python app.py.

About

A smart Public Transportation Management System built with Flask and MySQL. Features real-time booking validation via SQL Triggers and Stored Procedures.

dbms-project-with-frontend-backend flask mysql python sdg-11 sql-triggers

0 stars

0 watching

Report repository

Releases

Packages

Contributors

Languages