Clients

ClientIDFirstNameLastNameEmail
1JohnDoejohn@example.com
2JaneSmithjane@example.com
3AliceBrownalice@example.com
4BobWhitebob@example.com
5CarolBlackcarol@example.com

Accounts

AccountIDClientIDAccountTypeBalance
(→ Clients.ClientID)
11Checking2000.0
21Savings3000.0
32Checking5000.0
42Savings6000.0
53Checking7000.0
63Savings8000.0

Pensions

PensionIDClientIDRetirement_SavingsRate_of_returnContributionAmount
(→ Clients.ClientID)
11Pension Plan5%1000.0
22Pension Plan7%1200.0
33Brokerage Account5%900.0
44Brokerage Account8%1100.0

Investments

InvestmentIDAccountIDTickerSharesPricePerShareTotalInvestment
(→ Accounts.AccountID)
11AAPL50150.07500.0
21GOOG301200.036000.0
32AMZN401100.044000.0
42MSFT20200.04000.0
53TSLA30300.09000.0