## Customers

customerID | firstName | lastName | dateOfBirth | address
--- | --- | --- | --- | ---
1 | John | Doe | 1987-06-12 | New York
2 | Jane | Smith | 1990-05-15 | Los Angeles
3 | Tom | Nelson | 1975-08-18 | Chicago
4 | Alice | Williams | 1985-09-20 | Houston
5 | Bob | Jackson | 1992-11-22 | Seattle

## Accounts

accountID | customerID | balance
--- | --- | ---
| (→ Customers.customerID) |
1 | 1 | 1000.0
2 | 2 | -500.0
3 | 3 | 2000.0
4 | 4 | -300.0
5 | 5 | 500.0

## Mortgages

mortgageID | accountID | loanType | principalAmount | annualInterestRate | repaymentPeriod
--- | --- | --- | --- | --- | ---
| (→ Accounts.accountID) |  |  |  |
1 | 1 | Mortgage | 100000.0 | 0.05 | 30
2 | 2 | Mortgage | 200000.0 | 0.06 | 25
3 | 3 | Home Equity Loan | 50000.0 | 0.04 | 20
4 | 4 | Home Equity Loan | 30000.0 | 0.05 | 30
5 | 5 | Mortgage | 150000.0 | 0.07 | 15

## HomeEquityLoans

homeEquityID | mortgageID | additionalPrincipalAmount | monthlyPayment
--- | --- | --- | ---
| (→ Mortgages.mortgageID) |  |
1 | 1 | 5000.0 | 250.0
2 | 2 | 3000.0 | 275.0
3 | 3 | 4000.0 | 300.0
4 | 4 | 2000.0 | 225.0
5 | 5 | 1000.0 | 200.0

## SavingsAccounts

savingsID | accountID | interestRate
--- | --- | ---
| (→ Accounts.accountID) |
1 | 1 | 0.03
2 | 2 | 0.04
3 | 3 | 0.02
4 | 4 | 0.05
5 | 5 | 0.03