Desktop operations application
A desktop solution built around the day-to-day needs of a real parking facility in Pereira, centralizing vehicles, occupancy, entries, exits, and fee calculation.
Project details
Overview, challenge, solution, contributions, technologies, and results.
This applied academic project was developed from a real operating scenario for a parking facility in Pereira, Colombia. The goal was to translate its daily workflow into a functional desktop application rather than limit the exercise to a theoretical case. The system brings vehicle records, parking-space availability, entry and exit control, hourly rates, payment calculation, reports, and user management into a single interface backed by a relational database.
Parking operations require accurate coordination between vehicles, available spaces, timestamps, and payments. Managing these records manually can create duplicate information, assignment errors, and inconsistencies when calculating the amount due. The technical challenge was to keep the interface simple for daily use while preserving data integrity across every stage of a vehicle's stay.
I built a Java desktop application connected to MySQL through JDBC. Its workflow registers vehicles, displays parking-space status, assigns an available space, records entry and exit times, and calculates the fee from the configured hourly rate. The relational model was designed and administered in MySQL Workbench, establishing clear relationships among vehicles, parking stays, spaces, users, and operational records. Input validation and CRUD operations keep the application and database synchronized.
I participated in the complete process of turning the parking facility's workflow into a working software solution.
The result is a functional prototype grounded in a real business context. It demonstrates an end-to-end parking workflow, from registering a vehicle and assigning a space to recording its exit and calculating the final charge. Beyond the interface, the project shows practical experience connecting Java business logic to a persistent MySQL data model and designing software around concrete operational needs.
