Academic Project

TrakAm – Train Reservation Management System

TrakAm is a database-driven train reservation system developed as a team project at the City College of New York. The application allows users to search train routes, create reservations, manage bookings, and view reservation history through a centralized web interface.

The project focused on applying relational database concepts, entity relationship modeling, and database-backed web application development.

Impact Booking flow + database practice

Back to projects Open screenshot

Role Database Design & Frontend Developer

Duration Academic project

Project Type Reservation web application

Technologies

PHPMySQLHTMLCSSJavaScriptDatabase Design

Integrations

ReactHTMLCSSBootstrapMySQLphpMyAdminER Diagram DesignFlowchart Design

Key Outcomes

Created a functional reservation application concept

Practiced database design and form handling

Improved understanding of transactional web workflows

Challenge

Train reservations involve multiple interconnected entities including:

users
trains
routes
schedules
reservations
payments

The challenge was to design a system capable of managing these relationships while providing a simple booking workflow for users.

Solution

Developed a web-based reservation system allowing users to:

Search train routes
View available trains
Create reservations
Store passenger information
Track reservation history

The solution integrated frontend reservation workflows with a relational database structure and CRUD operations.a

What I Did

Frontend Development

Developed reservation interfaces using React, HTML, CSS, and Bootstrap
Built train search and booking workflows
Implemented reservation management pages
Created login and registration interfaces

Database Design

Contributed to database design and relationships
Worked with MySQL and phpMyAdmin
Supported CRUD operations for reservation management
Participated in ER diagram and system modeling

User Experience

Structured booking workflows
Organized reservation data presentation
Improved usability of search and reservation screens

Result

Created a functional reservation management system
Demonstrated frontend and database integration
Practiced relational database design and implementation
Applied ER modeling and workflow design concepts
Built a complete database-backed web application

Key Contributions

Developed reservation and booking interfaces
Built database-backed reservation features
Contributed to database design and data relationships
Implemented CRUD functionality for reservations
Structured train search and booking workflows

Visual Proof

Database Systems Course Project (Team Project)
TrakAm was developed as a collaborative academic project at the City College of New York. My primary contribution focused on database design, ER modeling, relational data structures, and database-backed application functionality, while also contributing to frontend implementation and testing.