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 |