Table design

A company has a number of departments, between departments are subordinate relationship, each department has a department manager, Department Manager to manage multiple coding staff, please design table

1, Through a department manager to find his superiors and subordinates

2, Design of efficient, as far as possible without recursion

Started by Jeremy at November 19, 2016 - 12:05 AM

Colleges and universities should use the redundant data

Table personnel
ID name superior to lower level I level I Department

The Department table
id name

Posted by Wesley at November 20, 2016 - 12:31 AM