Customers

CustomerIDFirstNameLastNameDateOfBirthEmail
1JohnDoe1980-06-17john.doe@gmail.com
2JaneSmith1985-03-19jane.smith@yahoo.com

Accounts

AccountNumberCustomerIDBalance
(→ Customers.CustomerID)
11500.0
221000.0

Loans

LoanIDCustomerIDAmountInterestRateTermYears
(→ Customers.CustomerID)
11200000.055
22150000.043

Insurance

InsuranceIDCustomerIDInsuranceTypePaymentFrequencyPremiumAmountStartDateEndDate
(→ Customers.CustomerID)
11Pet InsuranceMonthly15.02021-01-012021-12-31
21Pet InsuranceQuarterly45.02021-01-012021-12-31
32Disability InsuranceMonthly20.02021-01-012021-12-31
42Disability InsuranceAnnually200.02021-01-012022-12-31

Payments

PaymentIDAccountNumberPaymentDatePaymentAmountCheckNumber
(→ Accounts.AccountNumber)
112021-01-151000.012345
212021-02-151500.067890
322021-01-15500.0123456
422021-02-15500.067890