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 |