| BranchID | BranchName | Location |
|---|---|---|
| 1 | Main Street | Downtown |
| 2 | Northside | Northern Suburb |
| 3 | Eastside | Eastern Suburb |
| 4 | Westside | Western Suburb |
| 5 | Southside | Southern Suburb |
| EmployeeID | FirstName | LastName | BirthDate | 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 |
| 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. |
| PositionID | PositionTitle |
|---|---|
| 1 | Teller |
| 2 | Customer Service Representative |
| 3 | Loan Officer |
| 4 | Financial Analyst |
| 5 | IT Support |
| JobId | PositionId |
|---|---|
| (→ Jobs.JobID) | (→ Positions.PositionID) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |