Customers

CustomerIDFirstNameLastNameEmailPhoneNumber
1JohnDoejohn.doe@example.com123-456-7890
2JaneSmithjane.smith@example.com098-765-4321

Interest_Rates

RateIDPercentage
11%
22%

Savings_Accounts

AccountIDCustomerIDAccountBalanceAnnualInterestRate
(→ Customers.CustomerID)(→ Interest_Rates.RateID)
111000.01
215000.02

Checking_Accounts

AccountIDCustomerIDAccountBalanceMonthlyServiceFee
(→ Customers.CustomerID)
111500.010.0
213000.020.0

Loans

LoanIDPrincipalAmountYearlyInterestRateStartDateEndDateCustomerID
(→ Customers.CustomerID)
15000.04.02023-01-012025-01-011
210000.05.02023-01-012026-01-011

Transactions

TransactionIDAmountTypeAccountIDLoanIDDate
(→ Savings_Accounts.AccountID)(→ Loans.LoanID)
1100Deposit1None2023-01-01
250Withdrawal1None2023-01-15