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.

Found something interesting ?

• On-time delivery guarantee
• PhD-level professional writers
• Free Plagiarism Report

• 100% money-back guarantee
• Absolute Privacy & Confidentiality
• High Quality custom-written papers

Grab your Discount!

25% Coupon Code: SAVE25
get 25% !!