Branches

BranchIDBranchNameLocation
1Main StreetDowntown
2NorthsideNorthern Suburb
3EastsideEastern Suburb
4WestsideWestern Suburb
5SouthsideSouthern Suburb

Employees

EmployeeIDFirstNameLastNameBirthDateEmailPhoneNumberHireDateSalaryManagerIdBranchId
(→ Employees.EmployeeID)(→ Branches.BranchID)
1JohnSmith1970-01-01johnsmith@gmail.com12345678902020-01-1050000None1
2JaneDoe1980-01-01janedoe@gmail.com09876543212020-02-154500011
3AliceBrown1990-01-01alicebrown@gmail.com11122233342020-03-203500022
4TomBlack1985-01-01tomblack@gmail.com44455566672020-04-054000033
5MikeWhite1995-01-01mikewhite@gmail.com77788899902020-05-103000044
6LucyGreen1975-01-01lucygreen@gmail.com22233344452020-06-154500055

Jobs

JobIDJobTitleMinSalaryMaxSalaryDescription
1Bank Teller3000035000Assists customers at the teller window.
2Customer Service Representative3500040000Handles customer inquiries over the phone.
3Loan Officer4500055000Evaluates loan applications and makes recommendations.
4Financial Analyst5500065000Analyzes financial data and provides reports to management.

Positions

PositionIDPositionTitle
1Teller
2Customer Service Representative
3Loan Officer
4Financial Analyst
5IT Support

Jobs_Positions

JobIdPositionId
(→ Jobs.JobID)(→ Positions.PositionID)
11
22
33
44