Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I want the ER diagram for this please: Stock Exchange Database. You are requested to create a database for a stock exchange online application. Stock
I want the ER diagram for this please:
Stock Exchange Database. You are requested to create a database for a stock exchange online application. Stock exchange is the process of trading shares of companies registered in a stock exchange market. - Several markets are propagated worldwide, such as NASDAQ, DOW Jones, S\&P and Beirut Stock Exchange market. A market has a unique ID, a name, opening and closing hours. Several companies are registered for each market. - A company registers for a market using a unique share ID. For example, Apple Inc. is registered to NASDAQ market using the share id APPL. In addition to the share ID, the company name, the volume of shares that it registered and its capital in us dollars are saved. For each company, and respectively its share, the current price is consolidated, likewise the highest and lowest share price in the past 52 weeks. - A daily trading session is opened for each market except for holidays. A session is identified by its date. - In each trading session, orders are set by shareholders willing to buy or sell shares of a particular company. An order has an id unique in its trading session. In addition, the shareholder who set the order is saved as well as the company of which he desires to buy or sell shares and the volume of shares. Also, it is important to identify if the order is a selling or buying order. - In each trading session, the trading transactions are conserved for each share. Each transaction has an id unique in its session, a buyer, a seller, the volume of shares traded, and the price of a single share. - Buyers and sellers are shareholders and each shareholder have an id, a name, and a phone number. If you see that the data in the case study is incomplete, you are expected to add necessary assumptionsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started