Before creating an access route, you need to understand the relationship between the Department (iiiDepartments) and the Employee (iiiEmployees) tables that you have already created. The company structure is a hierarchy of departments and employees:
|
|
Departments have employees. An employee cannot exist without the department. Stated another way, the department is the parent or owner of its employees.
Relationships work in both directions. From the perspective of the Employee table, it is the child of the Department. An employee belongs to just one Department.
