Customers

CustomerIDFirstNameLastNameDateOfBirth
1JohnDoe2000-01-01
2JaneSmith1985-06-30
3MichaelJohnson1992-07-15
4EmmaWilliams1997-08-20
5DavidMartin1990-09-25

Accounts

AccountIDCustomerIDProductBalance
(→ Customers.CustomerID)
11Checking1000.0
22Savings500.0
33Money Market2500.0
44Premium Checking5000.0
55Certificates of Deposit10000.0

Transactions

TransactionIDAccountIDAmountTypeTransactionDate
(→ Accounts.AccountID)
11500.0Deposit2024-03-13 20:52:19
22-100.0Withdrawal2024-03-13 20:52:19
33200.0Deposit2024-03-13 20:52:19
44-300.0Withdrawal2024-03-13 20:52:19
552500.0Deposit2024-03-13 20:52:19

Fees

FeeIDAccountIDCardFeeMonthlyFee
(→ Accounts.AccountID)
115.010.0
223.05.0
3310.020.0
4420.030.0
5515.040.0

InterestRates

RateIDAccountIDMonthlyInterestRate
(→ Accounts.AccountID)
110.01
220.02
330.03
440.04
550.05

Products

ProductIDNameDescriptionMonthlyInterestRateCardFee
1Premium Credit CardA high interest credit card.0.025.0
2Regular Credit CardA standard credit card.0.013.0
3Business LoanFor business use only.0.0310.0
4Personal LoanLow interest personal loan.0.0420.0
5Student LoanFor students only.0.0515.0