Customers

CustomerIDFirstNameLastNameAddressCityStateZipCode
1JohnDoe123 Main StAnytownCA90210
2JaneSmith456 Elm StSpringfieldIL62704

Products

ProductIDTypeInterestRate
1Savings Account1%
2Savings Account2%
3Checking Account1%
4Checking Account2%

AccountNumbers

AccountNumberCustomerIDProductIDOpenDate
(→ Customers.CustomerID)(→ Products.ProductID)
1112021-01-01
2222021-01-02
3332021-01-03
4442021-01-04

Transactions

TransactionIDAccountNumberAmountDate
(→ AccountNumbers.AccountNumber)
1110002024-03-13 14:14:05
2220002024-03-13 14:14:05
33-5002024-03-13 14:14:05
4430002024-03-13 14:14:05

Loans

LoanIDAccountNumberPrincipalAmountAnnualInterestRateStartDateEndDateMonthlyPayment
(→ AccountNumbers.AccountNumber)
11100003.52021-01-012025-01-01250
22150004.02021-01-022027-01-02300
33120003.02021-01-032026-01-03240
44180003.52021-01-042029-01-04325