During the IT-214 course, we had to make a database project under Professor PM JAT.
ER DIAGRAM:
RELATIONAL SCHEMA:
USE CASES: A user can add stocks, commodities or currency to his portfolio. Also, we have given an extra choice to the user for favouriting the stock so that he can watch the stock and add it to its portfolio if he wants to buy it. The database manages the current price, opening price and closing price of the stock. So any user who doesn't even make his portfolio can use the stock database to see the stock market. The same goes for currency and commodities.