Database Design Question

SQL Apprentice Question
I'm fairly new to database design, having only really worked with
existing tables etc in the past.


Simple question this really...........


In a users table, is it wise to have a ManagerID column that is
effectively pointing to another user in the same table, with the
theory being that if that person is top dog, they will just have a
null entry in ManagerID.


I will check for circular references before entering the data.


Is there a better way of storing the data, or is this the only way?




Celko Answers
>> Is there a better way of storing the data, or is this the only way? <<


Get a copy of TREES & HIERARCHIES IN SQL for several different ways to
do an organizational chart. What you have is thd adjacency list
model; look up the nested sets model.



Original Source