Customers

CustomerIDFirstNameLastNameEmail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com

Accounts

AccountIDCustomerIDBalance
(→ Customers.CustomerID)
111000.0
22500.0

Loans

LoanIDCustomerIDAmountInterestRateStartDateEndDate
(→ Customers.CustomerID)
11500003.52023-01-012026-12-31
227500032023-02-012028-01-31

Transactions

TransactionIDAccountIDDateTypeAmount
(→ Accounts.AccountID)
112024-02-19 15:10:48Deposit100.0
222024-02-19 15:10:48Withdrawal-50.0

Banks

BankIDNumber_of_BranchesCountries_servedBank
1100USA and CanadaABC Bank
2200EuropeXYZ Bank

Employees

EmployeeIDFirstNameLastNamePositionSalaryBankID
(→ Banks.BankID)
1AliceWrightManager50000.01
2BobHansonTeller35000.02