marketing-app - Data Bases 2 Project a.y. 2020/2021

The goal of the project is to implement a web app that deals with gamified consumer data collection.

User View: a user can access the homepage where the product of the day is published, and he can complete the related questionnaire. The application computes the gamification points of each user that can be checked in the leaderboard.
Admin View: an admin can access a reserved homepage where he is able to create a new questionnaire for the day of for a future date, inspect or delete a past questionnaire.

Technologies

The application has been realized in a JEE (Java Enterprise Edition) environment, particularly exploiting JPA, EJBs and Servlets.

Backend

TomEE JEE application server
JPA for object relational mapping and transaction management
EJB (stateless) for the business objects
Java servlet for the client components
MySQL DBMS
Triggers and constraints for database-level business constraints and rules.

Frontend

HTML5, CSS, JavaScript

Documentation

Here you can find the complete specifications of the project.

Below you can have a look at the ER Diagram of the project, all design choices are described in detail here.

Authors

Francesco Gonzales