Customers
customerID | firstName | lastName | address | phoneNumber |
1 | John | Doe | 123 Main St | 555-1234 |
2 | Jane | Smith | 456 Elm St | 555-5678 |
Accounts
accountID | customerID | balance |
| (→ Customers.customerID) | |
1 | 1 | 1000.0 |
2 | 2 | 5000.0 |
Transactions
transactionID | accountID | amount | date |
| (→ Accounts.accountID) | | |
1 | 1 | 200.0 | 2022-01-01 10:00:00 |
2 | 2 | -300.0 | 2022-01-02 15:00:00 |
HedgeFund
hedgeFundID | name | performanceRatio |
1 | Fund A | 1.2 |
2 | Fund B | 1.15 |
MutualFund
mutualFundID | name | netAssetValue |
1 | Fund C | 100000.0 |
2 | Fund D | 90000.0 |
MarketShare
marketShareID | hedgeFundID | mutualFundID | sharePercentage |
| (→ HedgeFund.hedgeFundID) | (→ MutualFund.mutualFundID) | |
1 | 1 | 1 | 2% |
2 | 2 | 2 | 2% |
3 | 1 | 3 | 3% |
4 | 2 | 4 | 3% |