Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For every direct holder , list the first and last name, the names of the companies this person owns, the number of shares currently held,

For every direct holder, list the first and last name, the names of the companies this person owns, the number of shares currently held, % this holder has of the shares outstanding, and % this holder has of the total authorized shares. Sort the output by direct holder last name, first name, and company name. Display the percentages to two decimal places.

image text in transcribed

Currency PK currency_id Shareholder Place PK shareholder id U1 name U2 symbol PK place id -H- city- country Current_Shareholder Shares shareholder_id type stock_id shares type Conversion PK,FK1 from currency id PK,FK2 to currency id Current_Stock Stats stock_id current_authorized total_outstanding exchange_rate Trade Direct_Holder PK trade id Stock_Exchange FK2 stock_id PK stock ex id transaction_time shares name HO--- OFK1 stock_ex_id symbol price_total FK2 currency_id FK4 buyer_id FK1 place_id FK5 seller_id FK3 buy_broker_id FK6 sell_broker_id Company PK,FK2 company id PK,FK1(direct holder id O-H U2 FK1 U1 first_name last_name name place_id stock_id starting_price currency_id Broker PK broker.id 18 first_name last_name Stock_Listing O PK,FK2 stock ex id PK,FK1 stock id Shares Authorized PK,FK1 stock id PK time start stock_symbol Broker Stock Ex time_end authorized PK,FK1 stock ex id PK,FK2 broker.id Stock_Price PK,FK1 stock ex id PK,FK2 stock id time start time_end price

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_2

Step: 3

blur-text-image_3

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

Datacasting How To Stream Databases Over The Internet

Authors: Jessica Keyes

1st Edition

007034678X, 978-0070346789

More Books

Students also viewed these Databases questions

Question

What is Aufbau's rule explain with example?

Answered: 1 week ago

Question

Write Hund's rule?

Answered: 1 week ago

Question

2. Compare the sales and service departments at Auto World.

Answered: 1 week ago