Customers

customerIdfirstNamelastNamedobphoneNumberemailAddressbankID
(→ Banks.id)
1AliceSmith1980-07-23555-1234alice@example.com1
2BobJohnson1985-11-10555-5678bob@example.com1
3CarolWilliams1990-03-15555-9012carol@example.com2
4DanielDavis1988-06-27555-1357daniel@example.com3
5EvaMartin1992-10-12555-2468eva@example.com4

Accounts

accountNumberbalanceinterestRatecustomerId
(→ Customers.customerId)
11000.00.021
25000.00.032
38000.00.013
42000.00.044
53000.00.055

Transactions

transactionIdamountdatedescriptionsourceAccountNumberdestinationAccountNumber
(→ Accounts.accountNumber)(→ Accounts.accountNumber)
1-200.0NoneTransfer to friend12
2150.0NoneOnline shopping34
350.0NoneATM withdrawal55
4300.0NoneSalary credit66
5200.0NoneBill payment77

Loans

loanIdprincipalAmountinterestRatetermMonthsmonthlyPaymentcustomerId
(→ Customers.customerId)
120000.00.0536650.01
215000.00.0436500.02
330000.00.0648800.03
440000.00.0560850.04
525000.00.0448550.05

Banks

idnamelocationLeadership
1Bank ANew YorkJohn Doe
2Bank BLos AngelesEmma Jones
3Bank CChicagoTom Clark
4Bank DMiamiRachel Taylor
5Bank EDallasSteve Martin