Challenge Overview
Welcome to the CloudHub Database Replacement Implementation Contest. As part of this contest, you will change the existing MongoDB database to PostgreSQL using the ERD and schema created using a previous Architecture contest.
To encourage quality submissions, we will give out a bonus of $400 to the participants who score more than 93. This is limited to the first two participants after the participants have been ranked.
Project Overview
Cloud Hub is trying to help their client solve the problem of knowing what software applications they are spending the most money on over time. Cloud Hub will take in data from credit cards and other sources and attempt to show what software the client has and who is using the applications the most.
Contest Overview
Our client wishes to convert their existing MongoDB database to PostgreSQL. In this regard, we recently concluded an Architecture contest where we asked the community to come up with a schema for the new tables and scripts to create the tables in PostgreSQL.
We fine tuned this submission and we would like you to use the ERD diagram and the database scripts from this previous contest and remove any mention of mongodb in the existing application and replace the database with postgresql as part of this contest. In the process, the expectations are as follows:
1. You need to ensure that the APIs continue to work with the new database
2. You need to ensure that the tests do not fail. Since the database changes, you may need to adjust the test cases and enhance them with additional scenarios.
3. You need to use MassiveJS
4. Also ensure that there are no lint errors after the exercise is completed.