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