employees

employee_idfirst_namelast_namepositionhire_datebranch_id
(→ branches.branch_id)
1JohnDoeBranch Manager2021-01-01 00:00:001
2JaneDoeTeller2021-02-01 00:00:001
3AliceDoeHead Teller2021-03-01 00:00:002
4CharlieDoeCustomer Service Representative2021-04-01 00:00:003
5DavidDoeTeller2021-05-01 00:00:004

branches

branch_idbranch_managerLocationnumber_of_branches
1John Smith1st Ave1
2Jane DoeBroadway2
3Alice BrownMadison Ave3
4Charlie WhiteCentral Park West4
5David BlackWashington Blvd5
6NoneNone6