| 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 |
| 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 |