Branches

BranchIDBranchName
1Main Street
2Market Square

Customers

CustomerIDCustomerNameContactNumberEmailAddressBranchID
(→ Branches.BranchID)
1John Doe1234567890john@example.com1
2Jane Smith9876543210jane@example.com2

Accounts

AccountIDAccountTypeBalanceInterestRateEffectiveDateMaturityDateFinanceInstrumentID
(→ FinanceInstruments.FinanceInstrumentID)
1Checking1000.00.012022-01-01None1
2Savings2000.00.022022-01-01None2
3CD3000.00.032022-01-012024-01-013
4Money Market4000.00.042022-01-01None4

Deposits

DepositIDAmountPaymentMethodAccountID
(→ Accounts.AccountID)
1500ACH1
2250Wire Transfer2
3100Check3
4750ACH4

Loans

LoanIDPrincipalInterestRateTermYearsMonthlyPaymentAccountID
(→ Accounts.AccountID)
150000.0551501
2100000.04101002
330000.0331003
475000.0671504

FinanceInstruments

FinanceInstrumentIDTypePercentageInterestRate
1Green Bonds5%0.05
2Green Bonds6%0.06
3Social Bonds5%0.05
4Social Bonds7%0.07
5Corporate Bonds4%0.04
6Government Bonds3%0.03
7Treasury Bills2%0.02