## Customers

CustomerID | FirstName | LastName | EmailAddress | PhoneNumber
--- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | 123-456-7890
2 | Jane | Smith | jane.smith@example.com | 098-765-4321

## Accounts

AccountID | CustomerID | Type | Balance
--- | --- | --- | ---
| (→ Customers.CustomerID) |  |
1 | 1 | Checking | 1000.0
2 | 2 | Savings | 500.0

## Pensions

PensionID | AccountID | PlanName | RateOfReturn
--- | --- | --- | ---
| (→ Accounts.AccountID) |  |
1 | 1 | Golden Years | 5%
2 | 2 | Silver Years | 4%

## Brokerages

BrokerageID | AccountID | InvestmentAmount
--- | --- | ---
| (→ Accounts.AccountID) |
1 | 1 | 2000.0
2 | 2 | 3000.0

## Rates

RateID | Name | Value | Description
--- | --- | --- | ---
1 | High Yield | 5.5 | A high yield rate of return.
2 | Low Yield | 3.5 | A low yield rate of return.

## PensionPlans

PensionPlanID | PensionID | RateID
--- | --- | ---
| (→ Pensions.PensionID) | (→ Rates.RateID)
1 | 1 | 1
2 | 2 | 2