Formal_Bank_Table

IDNameAddressAssetsCredit
1ABC BankNew York City200000.010000.0
2XYZ BankLos Angeles300000.080000.0
3PQR BankChicago400000.060000.0
4LMN BankHouston500000.070000.0
5RST BankPhiladelphia600000.090000.0

Microfinance_Institution_Table

IDNameAddressNumber_of_ClientsTotal_LoansCredit
1Aid For AllWashington DC100050000.010000.0
2Financial EmpowermentDallas2000100000.080000.0
3Local LendingAtlanta3000150000.060000.0
4Global ImpactSan Francisco4000200000.070000.0
5Community DevelopmentMiami5000250000.090000.0

Customer_Table

IDFullNameAgeContactNumberAccountID
(→ Formal_Bank_Table.ID)
1John Doe30+1 555-123-45671
2Jane Smith28+1 555-987-65432
3Alice Johnson35+1 555-456-78903
4Bob Brown40+1 555-765-43214
5Carol White25+1 555-123-45675

Loan_Application_Table

ApplicationIdCustomerIdAmountInterestRateApprovedApplicationDate
(→ Customer_Table.ID)
115000.05.012024-03-13 18:24:30
226000.05.502024-03-13 18:24:30
337000.06.012024-03-13 18:24:30
448000.06.502024-03-13 18:24:30
559000.07.012024-03-13 18:24:30

Transaction_History_Table

TransactionIdAccountIdTypeAmountDateAndTime
(→ Customer_Table.AccountID)
11Deposit1000.02022-01-01 10:00:00
22Withdrawal500.02022-01-02 14:30:00
33Transfer2000.02022-01-03 08:15:00
44Payment3000.02022-01-04 12:00:00
55Fee-50.02022-01-05 16:45:00

Employee_Table

IdFirstnameLastnamePositionSalaryBranchId
(→ Formal_Bank_Table.ID)
1TomSmithManager70000.01
2AnnaJohnsonAssistant Manager60000.02
3MarkWilliamsTeller45000.03
4EmilyMartinezTeller45000.04
5DavidGarciaTeller45000.05