## Customers

CustomerID | FirstName | LastName | Address | City | State | ZipCode
--- | --- | --- | --- | --- | --- | ---
1 | John | Smith | 123 Main St | New York | NY | 10001
2 | Jane | Doe | 456 Elm St | Los Angeles | CA | 90001
3 | Alice | Wonderland | 789 Oak St | Chicago | IL | 60601
4 | Bob | Robertson | 321 Pine St | Houston | TX | 77001
5 | Carol | Williams | 987 Maple Ave | Phoenix | AZ | 85001

## Loans

LoanID | CustomerID | LoanType | Amount | InterestRate | StartDate | EndDate | Price
--- | --- | --- | --- | --- | --- | --- | ---
| (→ Customers.CustomerID) |  |  |  |  |  |
1 | 1 | Auto | 15000 | 0.05 | 2022-01-01 | 2025-01-01 | 2500.0
2 | 2 | Personal | 5000 | 0.07 | 2022-02-01 | 2024-02-01 | 1000.0
3 | 3 | Home | 300000 | 0.03 | 2022-03-01 | 2032-03-01 | 2000.0
4 | 4 | Business | 100000 | 0.06 | 2022-04-01 | 2027-04-01 | 3000.0
5 | 5 | Student | 25000 | 0.08 | 2022-05-01 | 2026-05-01 | 4000.0

## CollateralizedDebtObligations

ObligationID | LoanID | Description | Value
--- | --- | --- | ---
| (→ Loans.LoanID) |  |
1 | 1 | CDO1 | 1000
2 | 2 | CDO2 | 1500
3 | 3 | CDO3 | 2000
4 | 4 | CDO4 | 2500
5 | 5 | CDO5 | 3000

## CollateralizedMortgageObligations

ObligationID | LoanID | PropertyAddress | MarketValue
--- | --- | --- | ---
| (→ Loans.LoanID) |  |
1 | 1 | 123 Beach Blvd | 1000
2 | 2 | 456 Mountain Rd | 1500
3 | 3 | 789 Hill Drive | 2000
4 | 4 | 321 Forest Lane | 2500
5 | 5 | 987 River Street | 3000

## Employees

EmployeeID | FirstName | LastName | HireDate | Position | Salary
--- | --- | --- | --- | --- | ---
1 | David | Jackson | 2022-01-01 | Branch Manager | 70000
2 | Lisa | Smith | 2022-02-01 | Teller | 45000
3 | Tom | Johnson | 2022-03-01 | IT Specialist | 65000
4 | Karen | Jones | 2022-04-01 | HR Coordinator | 55000
5 | Steve | Martin | 2022-05-01 | Security Guard | 40000

## Branches

BranchID | BranchName | Location | NumberOfEmployees | ManagerId
--- | --- | --- | --- | ---
|  |  |  | (→ Employees.EmployeeID)
1 | Main Office | 100 Central Avenue | 25 | 1
2 | Eastside Branch | 200 East Road | 10 | 2
3 | Westside Branch | 300 West Boulevard | 15 | 3
4 | Southside Branch | 400 South Drive | 10 | 4
5 | Northside Branch | 500 North Court | 20 | 5