Phase I could include implementation at one client site using a group of consultants in close proximity to that site. Phase II could include implementation at a different site with a potentially different set of consultants. Both of these phases are considered separate projects, even though they are governed by the same contract. To further complicate matters, if such a contract specifies a maximum number of hours for overall implementation, the project managers of each project will have to agree how to split up the cap amounts between the two projects and maintain appropriate data about the split. The number of hours worked for each employee on each project must be recorded on a daily basis. Employees currently log their time using an Excel worksheet. An example of this worksheet is presented below. Notice that the employee‘ s supervisor is listed on the worksheet. This supervisor may or may not be the same person as the project manager. Each employee is assigned to one supervisor, and each supervisor manages one or more employees. The concepts of supervisor and project manager have completely different meanings at CMS. A supervisor manages an employee with respect to evaluations, vacation requests, raises, etc. A project manager manages a project, allocating the time of employees assigned to the project. A project manager is not required to sign off on an employee‘ s timesheet. A supervisor, however, is required to approve his / her employees‘ timesheets by placing his / her initials beside his / her name.
Part A: Deliverable For this phase, you are required to create an ER Diagram that will facilitate the development of CMS‘ s company-wide database. It must be created using ER Assistant and include entities and attributes, relationships, and accompanying notes. You must take a screenshot of your ERD while it is displayed in ER Assistant and paste the screenshot into a Word document. Make sure that the ERD fits on a single sheet and