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 |