## InvestmentTypes

ID | TypeName
--- | ---
1 | Equity
2 | Real Estate
3 | Fixed Income
4 | Commodities
5 | Alternative Investments

## Customers

CustomerID | FirstName | LastName
--- | --- | ---
1 | John | Doe
2 | Jane | Smith
3 | Robert | Williams
4 | Emily | Johnson
5 | David | Martin

## Months

Year | Month
--- | ---
(→ Calendar.Year) | (→ Calendar.Month)
2019 | December
2018 | November
2020 | April
2019 | September
2020 | October

## OpenEndFunds

ID | Name | MoneyMarketFund | BondFund | OtherValue
--- | --- | --- | --- | ---
|  |  |  | (→ InvestmentTypes.TypeName)
1 | ABC Money Market Fund | 1 | 0 | Money Market Fund
2 | XYZ Fixed Income Fund | 0 | 1 | Bond Fund
3 | PQR Growth Fund | 0 | 0 | Growth Fund
4 | RST Equity Fund | 0 | 0 | Equity Fund
5 | EFG Real Estate Fund | 0 | 0 | Real Estate Fund

## Investments

InvestmentId | CustomerID | OpenEndFundID | MonthID | Amount
--- | --- | --- | --- | ---
| (→ Customers.CustomerID) | (→ OpenEndFunds.ID) | (→ Months.ID) |
1 | 1 | 1 | 3 | 10000.0
2 | 2 | 2 | 1 | 7000.0
3 | 3 | 1 | 2 | 8000.0
4 | 4 | 2 | 3 | 6000.0
5 | 5 | 3 | 1 | 5000.0