## Customers

CustomerID | FirstName | LastName | DateOfBirth | Email
--- | --- | --- | --- | ---
1 | John | Doe | 1980-06-17 | john.doe@gmail.com
2 | Jane | Smith | 1985-03-19 | jane.smith@yahoo.com

## Accounts

AccountNumber | CustomerID | Balance
--- | --- | ---
| (→ Customers.CustomerID) |
1 | 1 | 500.0
2 | 2 | 1000.0

## Loans

LoanID | CustomerID | Amount | InterestRate | TermYears
--- | --- | --- | --- | ---
| (→ Customers.CustomerID) |  |  |
1 | 1 | 20000 | 0.05 | 5
2 | 2 | 15000 | 0.04 | 3

## Insurance

InsuranceID | CustomerID | InsuranceType | PaymentFrequency | PremiumAmount | StartDate | EndDate
--- | --- | --- | --- | --- | --- | ---
| (→ Customers.CustomerID) |  |  |  |  |
1 | 1 | Pet Insurance | Monthly | 15.0 | 2021-01-01 | 2021-12-31
2 | 1 | Pet Insurance | Quarterly | 45.0 | 2021-01-01 | 2021-12-31
3 | 2 | Disability Insurance | Monthly | 20.0 | 2021-01-01 | 2021-12-31
4 | 2 | Disability Insurance | Annually | 200.0 | 2021-01-01 | 2022-12-31

## Payments

PaymentID | AccountNumber | PaymentDate | PaymentAmount | CheckNumber
--- | --- | --- | --- | ---
| (→ Accounts.AccountNumber) |  |  |
1 | 1 | 2021-01-15 | 1000.0 | 12345
2 | 1 | 2021-02-15 | 1500.0 | 67890
3 | 2 | 2021-01-15 | 500.0 | 123456
4 | 2 | 2021-02-15 | 500.0 | 67890