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   October17, 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


         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   October17, 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



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: <>. Found 9 September 2008.