Ok, this one has been stumping me for quite a while. I have most of my structure layed out but came across a roadblock and was wondering if anybody has done something similar. Here's my scenario (well, a similar one). Say that I have a table of projects (project ID, project name) and a table of departments (department id, department name, etc.) I create a join table to assign multiple departments to a project and multiple projects to a department.
I then have a table of people (person_id, person_name, dept_id) since they can only be in one department at a time. What I want to do is be able to assign a department (as a whole) to a project as well as an individual and be able to say "I want the planning department and Joe Blow from Financing working on this". What are some thoughts on the best way to handle this situation?
I'm probably just overworking myself on the database as a whole (which is becoming quite huge) and overlooking something extremely obvious.
