Vehicle Rental

A university project simulating a real-world vehicle rental company that managed its fleet, customer records, and reservations manually. The goal was to build a system to digitalise and streamline these operations.

A desktop application enabling staff to manage the vehicle fleet (add, update, retire vehicles), register customers, create reservations with date-range validation to prevent double-booking, and generate rental receipts.

Desktop application built in Java (Swing for the UI) backed by a MySQL relational database. JDBC used for database connectivity. MVC pattern applied to separate the UI, business logic, and data access layers.

Manual test cases covering the core workflows: vehicle CRUD, customer registration, reservation creation with conflict scenarios, and receipt generation. Boundary testing on date inputs and rental duration calculations.

Packaged as a runnable JAR file with a bundled MySQL schema script for easy local setup. Designed for deployment on a local network within a single office environment.

This project built a solid foundation in relational database design and SQL. Understanding how to model real-world entities (vehicles, customers, reservations) as tables with proper foreign key relationships was a core learning outcome.