-
the answer to the question is the ERD should be a recursive relationship. There should only be two entities; Department and Manager/Employee(call the second entity what you may). Recursive nature of the table is the manager is also an employee and has employees reporting to Him/Her. I would be happy to demonstrate the data on a spreadsheet if you like. Simply reply to this thread and I will jump back on.
Good luck!
Jim(casinc815)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|