Project Details
For this project, we were allowed to chose whatever we wanted to do. We focused on doing a stock trading platform. In our platform companies will list their stocks with a trading index and clients would then create their portfolios buy purchasing stocks form the ones available. We used static data provided by the Capital IQ Database. We created two different profiles in our database, Managers and Clients. Clients have accounts containing information like their names, address, birth date, email and other banking information like bank account number. There are many clients but not every client needs to have a portfolio, this was just part of our design decision. This means they can simply have an account with no portfolio. A portfolio consists of a collection of stocks from those available (one of the indexes) and is held by a client. A manager can have many different client portfolios under its command and is allowed to perform transactions on those portolios. Client only directly controls its account information and has access to its own portfolio.
Here you can see how a user can register, login, update its information, buy stocks, sell stocks, and see their portfolio holdings.
Moving on we have the same registration and login for the Manager, which is a different profile in the database
Furthermore here you can see our ER Diagram, which represents the relationships between entities we designed for our program.
Under this following link you will be able to visualize our applications final design which contains our Relational Model translation, functional dependencies, our normalized tables, and also the SQL DDL tables. This is the baseline for the project design.
Open Project Design