Question: A small training college has decided to extend and replace its existing database system. The project has received board approval and the required functional changes

A small training college has decided to extend and replace its existing database system. The project has received board approval and the required functional changes and additional requirements have been agreed with the users. A project manager has been appointed and has been allocated a project team of three database analysts, three development programmers and one tester, with selected users being made available for acceptance testing. An outline project schedule for the development and implementation phases has been drawn up. It includes the following tasks and related staff allocations.

Task

Description

Duration

(weeks)

Staff

A

Define required new database functionality

4

Database Analyst DA1

B

Define new data entry and update requirements

3

Database Analyst DA2

C

Define new data analysis and report outputs

3

Database Analyst DA3

D

Define database transfer rules

2

Database Analyst DA3

E

Code and test extended database tables and schema

2

Programmer P4

F

Code and test new data entry and update routines

4

Programmer P5

G

Code and test data analysis and report routines

4

Programmer P6

H

Code and test database transfer

1

Programmer P6

I

Test and trial the data transfer routine

1

Tester T1 & Programmer P4

J

Integration testing

3

Tester T1 & programmers P4,P5 & P6

K

Accepting testing

3

Tester T1 and Users

Task A, B, C and D can all start at the same time although this will depend also upon staff availability. Task E is solely dependent on Task A Task F is dependent solely on Task B Task G is dependent solely on Task C Task H is dependent solely on Task D Task I is dependent solely on Task H Task J cannot start until Tasks E, F, G and I are completed Task K is dependent solely on Task J

  1. Draw a Gantt Chart showing all eleven tasks and their dependencies, allowing for the resource allocation as indicated above. Use this Gantt chart to identify the minimum duration for the project and to the list the float for each task. (12marks)
  2. Shortly before the start of the project, analysts DA2 and programmer P5 both resign from the company. No replacements are available. You must reallocate existing project staff to the tasks concerned in the most efficient way. Describe and justify the changes to the Gantt chart. State the new minimum duration for the project. (8marks)
  3. In all cases you can choose to accept a risk rather than take action. Describe any five situations where accepting a risk may be the best option. (10 marks)
  4. Discuss the difference in management roles for a project manager working with a professional project planning team compared with working with community project workers. (10 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!