Why dept_manager table and dept_emp table is not logically adjacent
in SQL / Introduction to JOINs
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)
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.
Submit an answer
Why did you not do not null, primary key and auto increment for customer id in the solution?
Resolved: foreign key : able to see foreign key in the table sales DDL tab , but the Foreign Keys tab is empty