Draw an entity diagram for this information. Each department in an organization consists of a manager and several departmental staff. Each manager is in charge of only one department, and departmental staff are assigned to a single department. Attached to each department are several projects. All departmental staff are assigned to projects, with some staff being assigned to several projects, not necessarily in the same department. Each project is run by a management group consisting of the manager of the department together with a selection of staff working on the project. No departmental staff member is ever required to sit on more than one management group. (a) Draw an entity diagram for this information. (b) Draw a functional diagram for the function: determine which departmental staff working on a given project are not attached to the department responsible for that project.

Expert Help With This Assignment — On Your Terms