Train Database Management System

A Database designed to solve the problem of the data management in scheduling trains, selling tickets, managing trips, and trains supporting staff (personnel).

This database can be adopted for different use cases related to other modes of transportation with few changes but the most closest one is the bus management system.

Entity Relationship(ER) Diagram

Figma Diagram Link: https://www.figma.com/file/ZRRgenXlwvHCWJBwiLe5V0/Train-System---ER-Diagram-(Copy)?node-id=0%3A1&t=P0VamMKyzHIq5dwq-1

Relational Model

PgAdmin Diagram Link: https://drive.google.com/file/d/122r9TxerxlKNg0tmUsMI62lb2sSeRPTB/view?usp=sharing

Tech Stack

HTML, Python, JavaScript, Bootstrap 5, Django, and Azure PostgreSQL Server

Group Members

McLain Barrett, Ayush Budhwani, Guillermo Clara, Hoan Ngo, James Pham, Joshua Tang, Freddy Velasco

Setup Project

Prerequisites

• Git version >= 2.37.0
• Python version >= 3.10.8
• Pip version >= 22.3

Instructions

1. Clone the project using command git clone https://github.com/joshuahT/TrainSystem/
2. Change directory to navigate inside the trainsystem project: cd trainsystem/
3. Run command pip install -r requirements.txt to install all the libraries used by this project
4. Run development server by using command python manage.py runserver and you can type in the url http://localhost:8000 into your browser to view the website.