If something is not clear in the description and you need to make assumptions to make a decision, document the assumptions you make. Please read it carefully The department of public works for a large city has decided to develop a Web-based pothole tracking and repair system (PHTRS). The department hired a new system analyst to analyse and design the web-based PHTRS. The analyst came up with the following description of their requirement: Citizens can log onto a website to view and make potholes report. The report contains the location and severity of potholes. As potholes are reported they are logged with a "public works department repair system" and are assigned with the given data. The recorded potholes consist of information as follows: an identifying number, stored with street address, size (on a scale of 1 to 10), location (middle, curb, etc.), district, and repair priority (determined from the size of the pothole). Further, a work order data is generated for each newly added pothole in the system. A work order is issued by an authorised PHTRS employee. A repair crew is allocated to repair the given pothole with the number of people in the crew. The pothole order list details the crew members with identifying number and equipment assigned. Also, working hours required to repair the work with the amount of filler material required is feed to the system. A tentative cost of repair based on the various metrics such as hours, number of people to work, material and equipment used is fed in the pothole order list. The data associated with each pothole order list includes information as follows: pothole location and size, repair crew identifying number, number of people on a crew, equipment assigned, hours applied to repair, hole status (work in progress, repaired, temporary repair, not repaired), amount of filler material used, and cost of repair (computed from hours applied, number of people, material, and equipment used). Public Works wants to be able store this information in a suitable database, and to later archive it into a data warehouse so as to be able to produce some meaningful analytics on the past data. In this way they may be able to predict where to direct future funding and were road maintenance is likely to be needed. Common occurrences in repeating locations may indicate heavy traffic utilizing roads that were not designed for heavy loads, and local traffic laws may need to be enforced, or traffic re-routed. Finally, a damage entry file is created by the PHTRS employee to hold information about reported damage due to the pothole and includes the citizen's name, address, phone number, type of damage, and dollar amount of damage. A crew of repair contractor is assigned to job to repair the pothole based on the collected information. PHTRS is a Web-based based online system; all queries are to be made interactively. For the development of the PHTRS, the department has set aside $260,000 for this project, and have allowed a time frame of 7 months. The publics works chief officer, Rachael Frabrizio, has indicated that she is keen to begin as soon as possible to implement the PHTRS systems so they can begin to provide a more responsive and faster service to the local city roads infrastructure.   Question 1                                                                                               What is the Systems view of project management and how does it help a project manager? Discuss this in detail. How does it help us when thinking the project in the case study? Question 2                                                                                                                                                                                                                                                                   Write the Business Objective section of the Business Case for the above case study. Question 3                                                                                                     Develop a detailed Work Breakdown Structure of the proposed system in the case study Question 4                                                                                                  Explain in detail how you would utilize Earned Value Management to control the costs of the project in the above case study and to monitor the progress of the development effort. Question 5                                                                                                Provide the requirements for the system in the case study, providing both functional and non-functional requirements Additionally, write a scope statement for the case study Question 6                                                                                                    Develop a Risk Management Plan for project in the case study.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

If something is not clear in the description and you need to make assumptions to make a decision, document the assumptions you make. Please read it carefully

The department of public works for a large city has decided to develop a Web-based pothole tracking and repair system (PHTRS). The department hired a new system analyst to analyse and design the web-based PHTRS. The analyst came up with the following description of their requirement:

Citizens can log onto a website to view and make potholes report. The report contains the location and severity of potholes. As potholes are reported they are logged with a "public works department repair system" and are assigned with the given data. The recorded potholes consist of information as follows:

  • an identifying number,
  • stored with street address,
  • size (on a scale of 1 to 10),
  • location (middle, curb, etc.),
  • district,
  • and repair priority (determined from the size of the pothole).

Further, a work order data is generated for each newly added pothole in the system. A work order is issued by an authorised PHTRS employee. A repair crew is allocated to repair the given pothole with the number of people in the crew. The pothole order list details the crew members with identifying number and equipment assigned. Also, working hours required to repair the work with the amount of filler material required is feed to the system. A tentative cost of repair based on the various metrics such as hours, number of people to work, material and equipment used is fed in the pothole order list. The data associated with each pothole order list includes information as follows:

  • pothole location and size,
  • repair crew identifying number,
  • number of people on a crew,
  • equipment assigned,
  • hours applied to repair,
  • hole status (work in progress, repaired, temporary repair, not repaired),
  • amount of filler material used,
  • and cost of repair (computed from hours applied, number of people, material, and equipment used).

Public Works wants to be able store this information in a suitable database, and to later archive it into a data warehouse so as to be able to produce some meaningful analytics on the past data. In this way they may be able to predict where to direct future funding and were road maintenance is likely to be needed. Common occurrences in repeating locations may indicate heavy traffic utilizing roads that were not designed for heavy loads, and local traffic laws may need to be enforced, or traffic re-routed.

Finally, a damage entry file is created by the PHTRS employee to hold information about reported damage due to the pothole and includes the citizen's name, address, phone number, type of damage, and dollar amount of damage. A crew of repair contractor is assigned to job to repair the pothole based on the collected information. PHTRS is a Web-based based online system; all queries are to be made interactively.

For the development of the PHTRS, the department has set aside $260,000 for this project, and have allowed a time frame of 7 months. The publics works chief officer, Rachael Frabrizio, has indicated that she is keen to begin as soon as possible to implement the PHTRS systems so they can begin to provide a more responsive and faster service to the local city roads infrastructure.

 

Question 1                                                                                              

What is the Systems view of project management and how does it help a project manager? Discuss this in detail. How does it help us when thinking the project in the case study?

Question 2                                                                                                                                                                                                                                                                  

Write the Business Objective section of the Business Case for the above case study.

Question 3                                                                                                    

Develop a detailed Work Breakdown Structure of the proposed system in the case study

Question 4                                                                                                 

Explain in detail how you would utilize Earned Value Management to control the costs of the project in the above case study and to monitor the progress of the development effort.

Question 5                                                                                               

Provide the requirements for the system in the case study, providing both functional and non-functional requirements Additionally, write a scope statement for the case study

Question 6                                                                                                   

Develop a Risk Management Plan for project in the case study.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education