MonthlyInterestRates

idMonthly_Interest_RateBank_AccountDate
10.0518342932142024-03-13 18:39:22
20.0678945123612024-03-13 18:39:22

AnnualPercentageRates

idAnnual_Percentage_RateBank_AccountStartDateEndDate
14.51834293214NoneNone
23.757894512361NoneNone

Customers

idFirstNameLastNameAddressEmailPhoneNumber
1JohnDoe123 Main Stjohn.doe@example.com555-1234
2JaneSmith456 Elm Stjane.smith@example.com555-5678

Transactions

idAccount_IDTransaction_TypeAmountDate
(→ Customers.id)
11Deposit10002024-03-13 18:39:22
21Withdrawal5002024-03-13 18:39:22
32Deposit20002024-03-13 18:39:22
42Withdrawal10002024-03-13 18:39:22

SavingsAccounts

idCustomer_IDBalanceInterest_RateOpening_Date
(→ Customers.id)
1150000.052021-01-01
2230000.062021-01-01