Hedge_Funds
id | fundName | managerName | AUM | Market_Share |
(→ Clients.clientId) | | | | |
1 | Alpha Fund | John Doe | 8000000.0 | 2% |
2 | Beta Fund | Jane Smith | 9000000.0 | 3% |
3 | Gamma Fund | Michael Johnson | 7000000.0 | 4% |
4 | Delta Fund | Emily Davis | 6000000.0 | 1% |
5 | Epsilon Fund | David Brown | 5000000.0 | 5% |
Mutual_Funds
id | fundName | managerName | AUM | Market_Share |
(→ Clients.clientId) | | | | |
1 | Fund1 | ManagerA | 1000000.0 | 2% |
2 | Fund2 | ManagerB | 1200000.0 | 3% |
3 | Fund3 | ManagerC | 1100000.0 | 4% |
4 | Fund4 | ManagerD | 900000.0 | 1% |
5 | Fund5 | ManagerE | 800000.0 | 5% |
Clients
clientId | firstName | lastName | email |
1 | Alice | Smith | alice@example.com |
2 | Bob | Jones | bob@example.com |
3 | Charlie | Williams | charlie@example.com |
4 | Diana | Johnson | diana@example.com |
5 | Edward | Martinez | edward@example.com |
Transactions
transactionId | clientId | amount | transactionDate |
| (→ Clients.clientId) | | |
1 | 1 | 2000.0 | 2024-03-13 18:44:29 |
2 | 2 | 1500.0 | 2024-03-13 18:44:29 |
3 | 3 | 2500.0 | 2024-03-13 18:44:29 |
4 | 4 | 3000.0 | 2024-03-13 18:44:29 |
5 | 5 | 3500.0 | 2024-03-13 18:44:29 |
Deposits
depositId | accountNumber | amount | depositDate |
| (→ Accounts.accountNumber) | | |
1 | 1001 | 5000.0 | 2024-03-13 18:44:29 |
2 | 1002 | 3000.0 | 2024-03-13 18:44:29 |
3 | 1003 | 4000.0 | 2024-03-13 18:44:29 |
4 | 1004 | 2000.0 | 2024-03-13 18:44:29 |
5 | 1005 | 2500.0 | 2024-03-13 18:44:29 |
Withdrawals
withdrawalId | accountNumber | amount | withdrawalDate |
| (→ Accounts.accountNumber) | | |
1 | 1001 | 1000.0 | 2024-03-13 18:44:29 |
2 | 1002 | 2000.0 | 2024-03-13 18:44:29 |
3 | 1003 | 3000.0 | 2024-03-13 18:44:29 |
4 | 1004 | 1500.0 | 2024-03-13 18:44:29 |
5 | 1005 | 2500.0 | 2024-03-13 18:44:29 |