customers
| id | name | address | phone_number |
| 1 | John Doe | 123 Main St | 555-0100 |
| 2 | Jane Smith | 456 Elm St | 555-0200 |
pension_plans
| plan_id | customer_id | plan_name | rate_of_return |
| (→ customers.id) | | |
| 1 | 1 | Gold Plan | 5.0 |
| 2 | 2 | Silver Plan | 7.5 |
brokerage_accounts
| account_id | customer_id | balance | rate_of_return |
| (→ customers.id) | | |
| 1 | 1 | 10000.0 | 5.0 |
| 2 | 2 | 8000.0 | 7.5 |
savings_accounts
| account_id | customer_id | balance | interest_rate |
| (→ customers.id) | | |
| 1 | 1 | 9000.0 | 5.0 |
| 2 | 2 | 6000.0 | 7.5 |
loan_applications
| app_id | customer_id | employee_id | amount | interest_rate | status |
| (→ customers.id) | (→ employees.emp_id) | | | |
| 1 | 1 | 1 | 15000.0 | 6.0 | Approved |
| 2 | 2 | 2 | 20000.0 | 6.5 | Rejected |
| 3 | 1 | 3 | 25000.0 | 7.0 | Pending |
| 4 | 2 | 4 | 30000.0 | 7.5 | Pending |
employees
| emp_id | first_name | last_name | position |
| 1 | Alice | Banks | Manager |
| 2 | Bob | Smith | Assistant Manager |