| id | fundName | totalAssets |
|---|---|---|
| 1 | ABC Fund | 1000000.0 |
| 2 | XYZ Fund | 2000000.0 |
| 3 | PQR Fund | 3000000.0 |
| 4 | LMN Fund | 4000000.0 |
| 5 | IJK Fund | 5000000.0 |
| id | portfolioType | description |
|---|---|---|
| 1 | Mutual_Fund | A diversified mutual fund |
| 2 | Equity_Fund | An equity-focused fund |
| 3 | Bond_Fund | A bond-focused fund |
| 4 | Money_Market_Fund | A money market fund |
| 5 | Balanced_Fund | A balanced fund that invests in both stocks and bonds |
| id | firstName | lastName | |
|---|---|---|---|
| 1 | John | Doe | john.doe@example.com |
| 2 | Jane | Smith | jane.smith@example.com |
| 3 | Alice | Johnson | alice.johnson@example.com |
| 4 | Bob | Williams | bob.williams@example.com |
| 5 | Charlie | Brown | charlie.brown@example.com |
| transactionId | customerId | investmentFundId | amount | transactionDate |
|---|---|---|---|---|
| (→ Customers.id) | (→ Investment_Funds.id) | |||
| 1 | 1 | 1 | 5000.0 | 2024-01-30 19:11:46 |
| 2 | 1 | 2 | 7000.0 | 2024-01-30 19:11:46 |
| 3 | 2 | 3 | 8000.0 | 2024-01-30 19:11:46 |
| 4 | 3 | 4 | 9000.0 | 2024-01-30 19:11:46 |
| 5 | 4 | 5 | 10000.0 | 2024-01-30 19:11:46 |
| id | investmentFundId | portfolioId |
|---|---|---|
| (→ Investment_Funds.id) | (→ Portfolios.id) | |
| 1 | 1 | 1 |
| 2 | 2 | 1 |
| 3 | 3 | 1 |
| 4 | 4 | 1 |
| 5 | 5 | 1 |