The program is a functioning implementation in Java Enterprise Edition, using EclipseLink JPA persistence and MySQL Database with triggers, of an online store for a telecommunication services company, where administrators can create and modify packages which are in turn purchasable by customers.
- Andrea Alesani (andrea.alesani@mail.polimi.it)
- Tommaso Brumani (tommaso.brumani@mail.polimi.it)
The project was carried out as part of the 2021/2022 'Data Bases II' course at Politecnico of Milano, where it was awarded a score of 16/16.
The project required the development of a web platform for the sale of service packages for a telecommunication company, composed by two client applications interacting with the same database.
The first application is a consumer application where customers can view available service packages and, upon logging in, can purchase a specific offering and view their active plans.
The second application is an employee application from which authorized users can create new service packages with associated products and perks, as well as view a sales report summarizing all essential data about sales and users.
The application was to be developed using JPA persistence, and certain features were explicitly required to be implemented through database triggers.
db2-JPA-2021: the code for the web application, as well as a database dump including the implemented triggersdocumentation: the project documentation specifying in greater detail several aspects of the implementationspecifications: specifications for the project