Stock Market Database Clone, created as a part of the course Database Management Systems at NIT Warangal.
The database consists of 13 entities primarily centered around Stock: DBA, Customer, Broker, Portfolio, Stock, Common, Preferred, Technicals, Exchange, Listings, Company, Company Fundamentals, Sector.
There are various relationship among the entities ranging from 1:1 to M:N which connect the entities to form a logical view of the stock market.
Below are the Entity Relation Diagram and the corresponding Relation Schema to depict the same.
We have created the database using SQL(Creation.sql) and have performed common queries(Queries.sql) associated with the stock market with the same.
Entity Relationship Diagram:-
Relation Schema:-
Team Members:
Rashwin Musuku - https://github.com/RashwinMR
Pradhyumna Kasam - https://github.com/pradhyumnakasam