Team 3 Statement of
Work
Depot Repair
Enhancement Process “DREP” Update
Prepared for Tinker
Air Force Base
October 15, 2008
Organization
Description
The Oklahoma City Air Logistics Center (OC-ALC), based at Tinker Air Force Base, OK, is the largest of three ALCs in the Air Force Materiel Command and provides depot maintenance, product support, services and supply chain management, as well as information support for 31 weapon systems, 10 commands, 93 Air Force bases and 46 foreign nations. Tinker is the headquarters of the Air Force Materiel Command's Oklahoma City Air Logistics Center, which is the worldwide manager for a wide range of aircraft, engines, missiles, software and avionics and accessories components. Tinker AFB vision consists of Combat Support through People, War Fighter Support, and Continuous Improvement. [1]The Air Force bases these core competencies and distinctive capabilities on a shared commitment to three core values -- integrity first, service before self, and excellence in all we do.
The overall goal of this project is to achieve the modernization of an existing application, Depot Repair Enhancement Program (DREP), while helping to give us an understanding of the business of software development. The end would be a quality system delivered within the semester that would enhance Tinker’s business need for a new depot repair tracking system.
Problem Statement
Tinker’s IT department’s business goals for this project involve migrating the Access database to SQL Server. The Access database is used as a reporting tool to generate exception reports. This includes creating a web interface, using VB.NET on the front-end and SQL on the back-end. This update will make the program more viable, as well as more security focused across the network, and will create an Air Force compliant system. This improves the security of the data while adding improved transaction logs. As a result, the integrity of the data will become more efficient and effective in creating backups. This also improves the scalability and reliability of the system while addressing deployment issues found with the stand alone Access application.
Projected Work
·
Solution Approach: We will be revising Tinker’s current DREP
program to make it .NET on the front-end and SQL Server on the back-end. We
will also create a web interface to improve access for users.
·
Tasks: We will be using .NET and SQL Server
to create a secure web interface for Tinker.
·
Deliverables and Dates: The tentative dates for project activities
include:
o October 17, 2:00 pm New
interface with documentation
o October 20 Weekly Report
o October 27 Weekly Report
o October 31, 2:00 pm Present code
o November 3 Weekly Report
o November 10 Weekly Report
o November 14, 2:00 pm Demonstration of team’s
progress
o November 17 Weekly Report
o November 21, 2:00 pm Proposed Final Presentation
o December 3 Final Report and copy of code
for new system
Constraints
· System will be written in VB.NET 2008
· System will use SQL Server 2005
Resources Required
Our team will need a ready-only copy of the current Access database. This will help us better understand the relationships between the tables and how they are used. We will also need permission to interview users about the current system operations and to gather the requirements for the proposed system.
Project Milestone
Dates
The tentative milestone dates include:
o October 17, 2:00 pm Progress
Meeting
o October 31, 2:00 pm Progress Meeting
o November 14, 2:00 pm Progress Meeting
o November 21, 2:00 pm Proposed Final Presentation
o December 5 Back Up date for Final
Presentation
Course Milestone Dates
o October 3 Proposal Report Due
o October 29 Exam 2
Signatures
For Team 3
_____________________________________________________________________
Dr. Al Schwarzkopf, Manager Date
For Tinker AFB
_____________________________________________________________________
Mike Kennedy, Chief, Enterprise Management Division Date
[1] Tinker Air Force Base
Website. Web Source: <http://www.tinker.af.mil/main/welcome.asp>. Found 9
September 2008.