CustomerInfo

customerIDnameaddressphoneNumberemail
1John Doe123 Main St555-1234john@example.com
2Jane Smith456 Elm St555-5678jane@example.com

SavingsAccounts

accountIDcustomerIDbalance
(→ CustomerInfo.customerID)
111000.0
222000.0

Loans

loanIDcustomerIDamountrate
(→ CustomerInfo.customerID)
11150000.05
22200000.04

Transactions

transactionIDaccountIDtypeamountdate
(→ SavingsAccounts.accountID)
11Deposit100.02024-03-07 23:55:31
21Withdrawal50.02024-03-07 23:55:31
32Deposit200.02024-03-07 23:55:31
42Withdrawal100.02024-03-07 23:55:31

InterestRates

idtermsmonthlyRateannualPercentageRateBank_AccountadditionalColumn
1Monthly Interest Rate0.0150.181834293214InterestRate1
2Monthly Interest Rate0.010.129876543210InterestRate2
3Annual Percentage Rate0.050.61834293214APR1
4Annual Percentage Rate0.040.489876543210APR2