Customers

CustomerIDFirstNameLastNameEmailAddressPhoneNumber
1JohnDoejohn.doe@example.com123-456-7890
2JaneSmithjane.smith@example.com098-765-4321

Accounts

AccountIDCustomerIDTypeBalance
(→ Customers.CustomerID)
11Checking1000.0
22Savings500.0

Pensions

PensionIDAccountIDPlanNameRateOfReturn
(→ Accounts.AccountID)
11Golden Years5%
22Silver Years4%

Brokerages

BrokerageIDAccountIDInvestmentAmount
(→ Accounts.AccountID)
112000.0
223000.0

Rates

RateIDNameValueDescription
1High Yield5.5A high yield rate of return.
2Low Yield3.5A low yield rate of return.

PensionPlans

PensionPlanIDPensionIDRateID
(→ Pensions.PensionID)(→ Rates.RateID)
111
222