Customers

CustomerIDFirstNameLastName
1JohnDoe
2JaneSmith
3MichaelBrown
4EmilyWhite
5DavidBlack

Accounts

AccountNumberCustomerIDBalance
(→ Customers.CustomerID)
100011800.0
1000221000.0
100033900.0
100044700.0
100055600.0

Transactions

TransactionIDAccountNumberAmountTransactionDate
(→ Accounts.AccountNumber)
11000150.02024-02-19 15:07:58
21000240.02024-02-19 15:07:58
31000330.02024-02-19 15:07:58
41000420.02024-02-19 15:07:58
51000510.02024-02-19 15:07:58

Loans

LoanNumberCustomerIDPrincipalInterestRateMonthlyPayment
(→ Customers.CustomerID)
11100000.05200.0
2280000.06160.0
3390000.055190.0
4470000.055140.0
5560000.06120.0

SavingsAccounts

SavingsIDCustomerIDInterestRate
(→ Customers.CustomerID)
110.01
220.02
330.025
440.03
550.035

CheckingAccounts

CheckingIDMaximum_Deposit_AmountMonthly_CapChecking_AccountCustomerID
(→ Customers.CustomerID)
15000.0800.011
24000.01000.012
33000.0600.003
42000.0400.004
51000.0200.005