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 |
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 |