This is the repository for the projects of the Database2 course held at Politecnico di Milano.
The project aims to develop an application that interfaces with the company's database. The first component is a consumer application, allowing the company's customers to purchase services upon registration. The second component is an employee application, allowing the company's workers to log in, create custom Service Packs, and introduce new optional products. Additionally, employees can access a sales report page, where crucial sales data is displayed.
A relational database supports both applications. Triggers are used to organize information, collected in specific tables for better viewing. The entire application is developed in Java, exploiting JPA framework, meanwhile for the database MySQL was used. The front end is a simple HTML page
In the repository are presented:
- 2 folders with all the code of the project [ProjectDB]
- A project Report in which all the phases of the project are described in detail
- A file with all the requirements of the project
- An installation guide to set up the environment to run the project
Note: The database dump is not provided for privacy reasons, but a schema of it is present in the report file
✔️ Final Evaluation: 15/16