## employees

employee_id | first_name | last_name | position | hire_date | branch_id
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ branches.branch_id)
1 | John | Doe | Branch Manager | 2021-01-01 00:00:00 | 1
2 | Jane | Doe | Teller | 2021-02-01 00:00:00 | 1
3 | Alice | Doe | Head Teller | 2021-03-01 00:00:00 | 2
4 | Charlie | Doe | Customer Service Representative | 2021-04-01 00:00:00 | 3
5 | David | Doe | Teller | 2021-05-01 00:00:00 | 4

## branches

branch_id | branch_manager | Location | number_of_branches
--- | --- | --- | ---
1 | John Smith | 1st Ave | 1
2 | Jane Doe | Broadway | 2
3 | Alice Brown | Madison Ave | 3
4 | Charlie White | Central Park West | 4
5 | David Black | Washington Blvd | 5
6 | None | None | 6