Currency
PK currency_id
U1 name
U2 symbol
H
Conversion
PK,FK1 from_currency_id
PK,FK2 to_currency_id
exchange_rate
Place
PK place_id
city
country
Stock_Exchange
PK stock_ex_id
name
symbol
Trade
PK trade_id
FK2 stock_id
transaction_time
shares
price_total
Broker
PK broker_id
first_name
last_name
Shareholder
PK shareholder_id
type
Current_Shareholder_Shares
shareholder_id
type
stock_id
shares
Company
PK,FK2 company_id
name
place_id
stock_id
starting_price
currency_id
U1
U2
H
FK1 stock_ex_id
FK2 currency_id
FK4 buyer_id
FK5 seller_id
FK3 buy_broker_id
FK6 sell_broker_id
Stock_Listing
PK,FK2 stock_ex_id
PK,FK1 stock_id
stock_symbol
Stock_Price
PK,FK1 stock_ex_id
PK,FK2 stock_id
time_start
time_end
price
Current_Stock_Stats
stock_id
current_authorized
total_outstanding
Direct_Holder
PK,FK1 direct_holder_id
first_name
last_name
Shares_Authorized
PK,FK1 stock_id
time_start
time_end
authorized
Broker_Stock_Ex
PK,FK1 stock_ex_id
PK,FK2 broker_id