VolcanoTravel

We implemented a system using Java and SQL that is responsible for making hotel reservations, booking flights, and renting cars. The implementation also included a graphical interface that was implemented with the Java Library javax.swing.JFrame. The system had users with different roles: caller, company manager, and database manager. The user would login to the system with their credentials and they would see only the functionality that was appropriate to their role.

Roles in the system & their functionality

The database manager could only import information to the database with a file .data. They could export and delete the database as well.
The caller could create a customer object on the database, search hotels, islands, customers etc. They could create/change/delete bookings as well according to the demands of the customer. They could also get reports about the empty rooms of a hotel at a given period or a customer booking etc.
The company manager could do the same as a caller but they could also: create/change/delete information of employees working at the VolcanoTravel agency. They could also calculate the payroll of employees and print more reports as for example all the reservations that were booked that day or the names of a passenger on a flight etc.

This system was implemented under a course I had in my bachelor's degree and we had used the infrastructure that the university had provided to us during my studies. Unfortunately, we do not have access to the databases anymore.