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 |
AccountID | CustomerID | Type | Balance |
---|---|---|---|
(→ Customers.CustomerID) | |||
1 | 1 | Checking | 1000.0 |
2 | 2 | Savings | 500.0 |
PensionID | AccountID | PlanName | RateOfReturn |
---|---|---|---|
(→ Accounts.AccountID) | |||
1 | 1 | Golden Years | 5% |
2 | 2 | Silver Years | 4% |
BrokerageID | AccountID | InvestmentAmount |
---|---|---|
(→ Accounts.AccountID) | ||
1 | 1 | 2000.0 |
2 | 2 | 3000.0 |
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. |
PensionPlanID | PensionID | RateID |
---|---|---|
(→ Pensions.PensionID) | (→ Rates.RateID) | |
1 | 1 | 1 |
2 | 2 | 2 |