Question

Write a scope statement based on the information below:

Analysis	Design	Implementation
Collect list of 20 projects	Gather detailed requirements for desired outputs from the database	Enter project data
Gather information on projects	Create fully attributed, normalized data model	Test database
Define draft requirements	Create list of edit rules for fields, determine default values, develop queries, and determine formats for reports	Make adjustments, as needed
Create entity relationship diagram for database	Develop list of queries required for database	Conduct user testing
Create sample entry screen	Review design information with customer	Make adjustments based on user testing
Create sample report	Make adjustments to design based on customer feedback	Create online Help, user manual, and other documentation
Develop simple prototype of database	Create full table structure in database prototype	Train users on the system
Review prototype with customer	Create data input screens
Make adjustments based on customer feedback	Write queries
	Create reports
	Create main screen
	Review new prototype with customer

The activities and tasks defined in the project plan must be undertaken within the scope of the project. For this reason, reiterate the scope of the project here as defined in the Project Charter.

Background Info:

Exercise A-4: Project Tracking Database

Expand the Project Tracking Database example. Assume that XYZ Company wants to create a history of project information, and the Project Tracking Database example is the best format for this type of history. The company wants to track information on 20 past and current projects and wants the database to be able to handle 100 projects total. The company wants to track the following project information:

Project name

Sponsor name

Sponsor department

Type of project

Project description

Project manager

Team members

Date project was proposed

Date project was approved or denied

Initial cost estimate

Initial time estimate

Dates of milestones (e.g., project approval, funding approval, project completion)

Actual cost

Actual time

Location of project files

Answer 1

Scope of the study:

The company wants to track information on 20 past and current projects and wants the database to be able to handle 100 projects total. The required fields to be captured and metrics to be monitored from each segment includes main responbile people ( projectmanger, sponsor information),timeline of project, cost associated with it ( actual budget, completion time cost),time involved in completion of project.The files of project has to be systematically placed in folders and proper markers has to be given.