Data Management AND System Analysis and Project Management

Consider the following use case used by a project manager to prepare project cost report for various projects he/she is managing

Use Case for PrepareProjectCostReport

Trigger: End of each month

Normal Flow of Events

For each project in the project data file,

Do the following

Retrieve project data from the project data file

Set TotalProjectCost = 0

For each employee who worked in the project,

Do the following

Retrieve project data from the project data file

Set TotalProjectCost = 0

For each employee who worked in the project,

DO the following

TotalProjectCost = TotalProjectCost + HourlyRate*HoursWorked

END DO

Print Project#, Name, TotalProjectCost

END DO

Data Dictionary

Project data = Project# + Name + BeginDate + EndDate + {Emp# + HourlyRate + HoursWorked}

As you can see from the above models, the cost of a project is tracked at individual employee levels. For better cost control, the project manager wants the project cost to be tracked at individual activities also. A project typically has many activities, and in a project, an employee can typically work on many different activities. For instance, in a systems development project, an analyst can work on analysis activity and design activity. In such cases, the project manager wants to track the cost incurred for every activity in a project. For example, if the project requires two activities, design and programming, then the costs for the design activity and the programming activity are also required. Thus, the project manager wants a cost report that not only shows the total cost as is done by the current system, but also the breakdown of costs across various activities.

question 1: Suggest a layout for the report. The layout should indicate what data will be shown in the report.

question 2: Show the revised Use case description and data dictionary to generate the new cost report.

Make any additional assumptions required.