Customers

customerIDfirstNamelastNameaddressphoneNumber
1JohnDoe123 Main St555-1234
2JaneSmith456 Elm St555-5678

Accounts

accountIDcustomerIDbalance
(→ Customers.customerID)
111000.0
225000.0

Transactions

transactionIDaccountIDamountdate
(→ Accounts.accountID)
11200.02022-01-01 10:00:00
22-300.02022-01-02 15:00:00

HedgeFund

hedgeFundIDnameperformanceRatio
1Fund A1.2
2Fund B1.15

MutualFund

mutualFundIDnamenetAssetValue
1Fund C100000.0
2Fund D90000.0

MarketShare

marketShareIDhedgeFundIDmutualFundIDsharePercentage
(→ HedgeFund.hedgeFundID)(→ MutualFund.mutualFundID)
1112%
2222%
3133%
4243%