Technology Stack selected:
- Database: MySQL (stored in AWS) - MySQL is an open RDMS which is widely used as enterprise DB.
- REST: Spring BOOT(Maven project)
- Cloud: AWS
The Spring BOOT REST API application has been deployed to AWS and can be queried using the following links -
Revenue: http://transactionapi.us-east-2.elasticbeanstalk.com/revenue/ - shows the Total Revenue per year
Active User Count: http://transactionapi.us-east-2.elasticbeanstalk.com/activeusers/ - gives the number of active users in each year. (Active user is any user with at least 1 transaction in a given year)
New User Count: http://transactionapi.us-east-2.elasticbeanstalk.com/newusercount/ - Gives the count of users joined each year.
Average Revenue per Active User: http://transactionapi.us-east-2.elasticbeanstalk.com/arpau/ - Total revenue generated by each active user.