Banks

idnamelocationCeoManagement_Team
1Bank ANew YorkJohn DoeJane Smith, Mike Johnson
2Bank BLos AngelesEmma JonesDavid Brown, Sarah Lee
3Bank CChicagoTom ClarkLisa Miller, Kevin Wright
4Bank DMiamiRachel TaylorPaul King, Susan White
5Bank EDallasSteve MartinKathy Davis, Mark Johnson

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