Example Company Tables
suggest changeConsider 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 |
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents