## 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