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 |