Example Company Tables

Consider a company where every employee who is a manager, manages 1 or more employees, and every employee has only 1 manager.

This results in two tables:

EMPLOYEES

EMP_ID | FIRST_NAME | LAST_NAME | MGR_ID |
— | — | — | — |
E01 | Johnny | Appleseed | M02 |
E02 | Erin|Macklemore | M01 |
E03 | Colby | Paperwork | M03 |
E04 | Ron | Sonswan | M01 |

MANAGERS

MGR_ID | FIRST_NAME | LAST_NAME |
— | — | — |
M01 | Loud | McQueen |
M02 | Bossy | Pants |
M03 | Barrel | Jones |