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 |