Last answered:

27 May 2022

Posted on:

06 Apr 2022

0

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

1 answers ( 0 marked as helpful)
Instructor
Posted on:

27 May 2022

0

Hi Vladimir!
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.
Best,
Tsvetelin

Submit an answer