Customers

CustomerIDFirstNameLastNameAddressCityStateZipCode
1JohnSmith123 Main StNew YorkNY10001
2JaneDoe456 Elm StLos AngelesCA90001
3AliceWonderland789 Oak StChicagoIL60601
4BobRobertson321 Pine StHoustonTX77001
5CarolWilliams987 Maple AvePhoenixAZ85001

Loans

LoanIDCustomerIDLoanTypeAmountInterestRateStartDateEndDatePrice
(→ Customers.CustomerID)
11Auto150000.052022-01-012025-01-012500.0
22Personal50000.072022-02-012024-02-011000.0
33Home3000000.032022-03-012032-03-012000.0
44Business1000000.062022-04-012027-04-013000.0
55Student250000.082022-05-012026-05-014000.0

CollateralizedDebtObligations

ObligationIDLoanIDDescriptionValue
(→ Loans.LoanID)
11CDO11000
22CDO21500
33CDO32000
44CDO42500
55CDO53000

CollateralizedMortgageObligations

ObligationIDLoanIDPropertyAddressMarketValue
(→ Loans.LoanID)
11123 Beach Blvd1000
22456 Mountain Rd1500
33789 Hill Drive2000
44321 Forest Lane2500
55987 River Street3000

Employees

EmployeeIDFirstNameLastNameHireDatePositionSalary
1DavidJackson2022-01-01Branch Manager70000
2LisaSmith2022-02-01Teller45000
3TomJohnson2022-03-01IT Specialist65000
4KarenJones2022-04-01HR Coordinator55000
5SteveMartin2022-05-01Security Guard40000

Branches

BranchIDBranchNameLocationNumberOfEmployeesManagerId
(→ Employees.EmployeeID)
1Main Office100 Central Avenue251
2Eastside Branch200 East Road102
3Westside Branch300 West Boulevard153
4Southside Branch400 South Drive104
5Northside Branch500 North Court205