## Investment_Funds

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

## Portfolios

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

## Customers

id | firstName | lastName | email
--- | --- | --- | ---
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

## Transactions

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

## Investment_Funds_Portfolios

id | investmentFundId | portfolioId
--- | --- | ---
| (→ Investment_Funds.id) | (→ Portfolios.id)
1 | 1 | 1
2 | 2 | 1
3 | 3 | 1
4 | 4 | 1
5 | 5 | 1