Hedge_Funds

idfundNamemanagerNameAUMMarket_Share
(→ Clients.clientId)
1Alpha FundJohn Doe8000000.02%
2Beta FundJane Smith9000000.03%
3Gamma FundMichael Johnson7000000.04%
4Delta FundEmily Davis6000000.01%
5Epsilon FundDavid Brown5000000.05%

Mutual_Funds

idfundNamemanagerNameAUMMarket_Share
(→ Clients.clientId)
1Fund1ManagerA1000000.02%
2Fund2ManagerB1200000.03%
3Fund3ManagerC1100000.04%
4Fund4ManagerD900000.01%
5Fund5ManagerE800000.05%

Clients

clientIdfirstNamelastNameemail
1AliceSmithalice@example.com
2BobJonesbob@example.com
3CharlieWilliamscharlie@example.com
4DianaJohnsondiana@example.com
5EdwardMartinezedward@example.com

Transactions

transactionIdclientIdamounttransactionDate
(→ Clients.clientId)
112000.02024-03-13 18:44:29
221500.02024-03-13 18:44:29
332500.02024-03-13 18:44:29
443000.02024-03-13 18:44:29
553500.02024-03-13 18:44:29

Deposits

depositIdaccountNumberamountdepositDate
(→ Accounts.accountNumber)
110015000.02024-03-13 18:44:29
210023000.02024-03-13 18:44:29
310034000.02024-03-13 18:44:29
410042000.02024-03-13 18:44:29
510052500.02024-03-13 18:44:29

Withdrawals

withdrawalIdaccountNumberamountwithdrawalDate
(→ Accounts.accountNumber)
110011000.02024-03-13 18:44:29
210022000.02024-03-13 18:44:29
310033000.02024-03-13 18:44:29
410041500.02024-03-13 18:44:29
510052500.02024-03-13 18:44:29