Defect Tracking System

Note: Please Scroll Down to See the Download Link.

ABSTRACT

This project is aimed at developing an online defect tracking system useful for applications developed in an organization. The Defect Tracking System (DTS) is a web based application that can be accessed throughout the organization. This system can be used for logging defects against an application/module, assigning defects to individuals and tracking the defects to resolution. There are features like email notifications, user maintenance, user access control, report generators etc in this system.

The project has been planned to be having the view of distributed architecture, with centralized storage of the database. The application for the storage of the data has been planned. Using the constructs of MS-SQL Server and all the user interfaces have been designed using the ASP.Net technologies. The database connectivity is planned using the “SQL Connection” methodology. The standards of security and data protective mechanism have been given a big choice for proper usage. The application takes care of different modules and their associated reports, which are produced as per the applicable strategies and standards that are put forwarded by the administrative staff.

The entire project has been developed keeping in view of the distributed client server computing technology, in mind. The specification has been normalized up to 3NF to eliminate all the anomalies that may arise due to the database transaction that are executed by the general users and the organizational administration. The user interfaces are browser specific to give distributed accessibility for the overall system. The internal database has been selected as MS-SQL server 200.The basic constructs of table spaces, clusters and indexes have been exploited to provide higher consistency and reliability for the data storage. The MS-SQL server 200 was a choice as it provides the constructs of high-level reliability and security. The total front end was dominated using the ASP.Net technologies. At all proper levels high care was taken to check that the system manages the data consistency with proper business rules or validations. The database connectivity was planned using the latest “SQL Connection” technology provided by Microsoft Corporation. The authentication and authorization was crosschecked at all the relevant stages. The user level accessibility has been restricted into two zones namely.

INTRODUCTION TO PROJECT

This project is aimed at developing an online defect tracking system useful for applications developed in an organization.  The Defect Tracking System (DTS) is a web based application that can be accessed throughout the organization.  This system can be used for logging defects against an application/module, assigning defects to individuals and tracking the defects to resolution.  There are features like email notifications, user maintenance, user access control, report generators etc in this system.

PURPOSE OF THE SYSTEM

This project is aimed at developing an online defect tracking system useful for applications developed in an organization. The Defect Tracking System (DTS) is a web based application that can be accessed throughout the organization. This system can be used for logging defects against an application/module, assigning defects to individuals and tracking the defects to resolution. There are features like email notifications, user maintenance, user access control, report generators etc in this system.

PROBLEMS IN THE EXISTING SYSTEM:

Defect Tracking System is a web-based application designed to help a workgroup keep track of Defects and tasks via a shared central resource. The system was designed specifically with the IT department in mind, where quick access to shared data and history is a requirement, both from an internal organizational perspective, as well as to fulfill the needs of the customers.

It provides one roof solution for all the Defects issues in the software development.  It doesn’t provide any kind of solution to any kind of problem. It only acts as a means to transmit the issues and their details to the concerned programmers with accuracy. It is a tool that helps in providing the solution in right time.

  • Defect Tracking System simply manages the Defects by…

  • User Maintenance

  • Component Maintenance

  • Defect Tracking

  • Report

In addition to all these, it also maintains the preferences, customized settings, colors, priorities, users, etc.

SOLUTION OF THESE PROBLEMS

The development of the new system contains the following activities, which try to automate the entire process keeping in view of the database integration approach.

  • User friendliness is provided in the application with various controls.
  • The system makes the overall project management much easier and flexible.
  • It can be accessed over the Internet.
  • Various classes have been used to provide file upload and mail features.
  • There is no risk of data mismanagement at any level while the project development is under process.
  • Report generation feature is provided using Crystal Reports to generate different kinds of reports like bar graphs, pie charts and table type charts etc.
  • It provides high level of security using different protocols like https etc.

ADVANTAGES

The project can be easily used in the process of decision making.  Different types of reports can be generated which help the management to take correct decision and reduce the time delay which automatically increases the company’s work standards as well as the economical state of the company.

NUMBER OF MODULES

The system after careful analysis has been identified to be presented with the following modules:

The modules involved are:          

A: Following tasks can be performed with the application:

·         User Maintenance

·         Component Maintenance

·         Defect Tracking

·         Report

The above all tasks should be performed by Admin only.

User Maintenance: Creating, Granting & Revoking access and deleting users from application.

Component Maintenance: Creating a component (application being developed/ enhanced), Granting & Revoking access on components to Users and Marking a component as “Active” or “Closed”.

Defect Tracking: Creating, Assigning defects to users, Modifying and Closing a defect. A defect screen should at least have following details and this defect report can be verified by concerned admin. After verify he can send the status to the users.

·         Defect Number and Title

·         Defect priority

·         Date created

·         Defect description

·         Defect diagnosis

·         Name of originator

·         Name of Assignee

·         Status

·         Resolution

Report: Generate reports on defects.

B: Following additional tasks also can be performed by this application:

·         Find User

·         Find component

·         Find defect

·         Send Defect Report

·         Check Defect Status

Find User: A search screen to find users and display results.

Find component: A search screen to find components and display results.

Find defect: A search screen to find defects and display results.

Send defect Report: After finding the defect user can send defect report to the concerned administration.

Check Defect Status: Once user send defect report he can able to check the status of the report.

PROJECT INSTRUCTIONS:

·         Based on the given requirements, conceptualize the Solution Architecture. Choose the domain of your interest otherwise develop the application for ultimatedotnet.com. Depict the various architectural components, show interactions and connectedness and show internal and external elements. Design the web services, web methods and database infrastructure needed both and client and server.

·         Provide an environment for upgradation of application for newer versions that are available in the same domain as web service target.

HARDWARE SPECIFICATIONS

HARDWARE REQUIREMENTS:

  • PIV 2.8 GHz Processor and Above
  • RAM 512MB and Above
  • HDD 20 GB Hard Disk Space and Above

SOFTWARE REQUIREMENTS:

  • WINDOWS OS (XP / 2000 / 200 Server / 2003 Server)
  • Visual Studio .Net 2005 Enterprise Edition
  • Internet Information Server 5.0 (IIS)
  • Visual Studio .Net Framework (Minimal for Deployment)                          
  • SQL Server 2000 Enterprise Edition

Click here to download Defect Tracking System source code