the employee table holds all employees. every employee has an id, and there is also a column for the department id.
+----+-------+--------+--------------+
| id | name | salary | departmentid |
+-...
the employee table holds all employees. every employee has an id, a salary, and there is also a column for the department id.
+----+-------+--------+--------------+
| id | name | salary | departm...