I am working on a personal finance management application, which also analyse the users financial statement and gives a good overview about their expenses and savings. More or less like a AI personal finance adviser.
What I am having trouble is choosing between SQL and NoSQL, as per the data it looks very straight forward when using relational database managing the transactions and the user data. when using non relational approach de-normalizing the data might be a problem because there are lot of referencing to transactions, category, modes and more.
what would be a good approach to this !!
*Note: We are planning to use MEAN Stack for the app