InvestmentTypes

IDTypeName
1Equity
2Real Estate
3Fixed Income
4Commodities
5Alternative Investments

Customers

CustomerIDFirstNameLastName
1JohnDoe
2JaneSmith
3RobertWilliams
4EmilyJohnson
5DavidMartin

Months

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

OpenEndFunds

IDNameMoneyMarketFundBondFundOtherValue
(→ InvestmentTypes.TypeName)
1ABC Money Market Fund10Money Market Fund
2XYZ Fixed Income Fund01Bond Fund
3PQR Growth Fund00Growth Fund
4RST Equity Fund00Equity Fund
5EFG Real Estate Fund00Real Estate Fund

Investments

InvestmentIdCustomerIDOpenEndFundIDMonthIDAmount
(→ Customers.CustomerID)(→ OpenEndFunds.ID)(→ Months.ID)
111310000.0
22217000.0
33128000.0
44236000.0
55315000.0