## Branches

BranchID | BranchName | Location
--- | --- | ---
1 | Main Street | Downtown
2 | Northside | Northern Suburb
3 | Eastside | Eastern Suburb
4 | Westside | Western Suburb
5 | Southside | Southern Suburb

## Employees

EmployeeID | FirstName | LastName | BirthDate | Email | PhoneNumber | HireDate | Salary | ManagerId | BranchId
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  |  |  | (→ Employees.EmployeeID) | (→ Branches.BranchID)
1 | John | Smith | 1970-01-01 | johnsmith@gmail.com | 1234567890 | 2020-01-10 | 50000 | None | 1
2 | Jane | Doe | 1980-01-01 | janedoe@gmail.com | 0987654321 | 2020-02-15 | 45000 | 1 | 1
3 | Alice | Brown | 1990-01-01 | alicebrown@gmail.com | 1112223334 | 2020-03-20 | 35000 | 2 | 2
4 | Tom | Black | 1985-01-01 | tomblack@gmail.com | 4445556667 | 2020-04-05 | 40000 | 3 | 3
5 | Mike | White | 1995-01-01 | mikewhite@gmail.com | 7778889990 | 2020-05-10 | 30000 | 4 | 4
6 | Lucy | Green | 1975-01-01 | lucygreen@gmail.com | 2223334445 | 2020-06-15 | 45000 | 5 | 5

## Jobs

JobID | JobTitle | MinSalary | MaxSalary | Description
--- | --- | --- | --- | ---
1 | Bank Teller | 30000 | 35000 | Assists customers at the teller window.
2 | Customer Service Representative | 35000 | 40000 | Handles customer inquiries over the phone.
3 | Loan Officer | 45000 | 55000 | Evaluates loan applications and makes recommendations.
4 | Financial Analyst | 55000 | 65000 | Analyzes financial data and provides reports to management.

## Positions

PositionID | PositionTitle
--- | ---
1 | Teller
2 | Customer Service Representative
3 | Loan Officer
4 | Financial Analyst
5 | IT Support

## Jobs_Positions

JobId | PositionId
--- | ---
(→ Jobs.JobID) | (→ Positions.PositionID)
1 | 1
2 | 2
3 | 3
4 | 4