Answered step by step
Verified Expert Solution
Link Copied!

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:image text in transcribed

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 assumptions

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions