customers

idnameaddressphone_number
1John Doe123 Main St555-0100
2Jane Smith456 Elm St555-0200

pension_plans

plan_idcustomer_idplan_namerate_of_return
(→ customers.id)
11Gold Plan5.0
22Silver Plan7.5

brokerage_accounts

account_idcustomer_idbalancerate_of_return
(→ customers.id)
1110000.05.0
228000.07.5

savings_accounts

account_idcustomer_idbalanceinterest_rate
(→ customers.id)
119000.05.0
226000.07.5

loan_applications

app_idcustomer_idemployee_idamountinterest_ratestatus
(→ customers.id)(→ employees.emp_id)
11115000.06.0Approved
22220000.06.5Rejected
31325000.07.0Pending
42430000.07.5Pending

employees

emp_idfirst_namelast_nameposition
1AliceBanksManager
2BobSmithAssistant Manager