Why dept_manager table and dept_emp table is not logically adjacent
Why dept_manager table and dept_emp table is not logically adjacent. They both have relevant columns such as emp_no INT and dept_no CHAR
Thanks for reaching out.
The tables are not logically adjacent because actually they are indentical. The table dept_manager is only for the managers whereas the table dept_emp contains very similar information but for the employees. For example a manager works a period of some years and then he became an employee and it is represented by the table dept_emp.
Hope this helps.