report

Project Report

On FILE TRACKING SYSTEM

& FREQUENTLY ASKED QUESTION’s

System (WEB BASED)

Training Coordinator Guided by

Dr. S.C. Gupta Shri Paresh JainNational Informatics Centre (Scientist –C)Jaipur National Informatics Centre

Jaipur (Rajasthan)

G o v e r n m e n t O f I n d i a

M I n I s t r y O f C o m m u n I c a t i o n s a n d I n f o r m a t i o n T e c h n o l o g y

D e p a r t m e n t o f I n f o r m a t i o n T e c h n o l o g y

Mohammed Hashim INFORMATION TECHNOLOGY Release 01/01/2009 Mohammed Hashim INFORMATION TECHNOLOGY Release 01/01/2009 Page 1 of of 136136 --

S.S. Jain Subodh P.G.

College

ASP.Net&

M.S.Sql

N a t i o n a l I n f o r m a t i c s C e n t r e

A

Project Report

On

FILE TRACKING SYSTEM & FREQUENTLY ASKED QUESTION

Project Submitted in partial fulfillment of the requirement of the award of the degreeOf

M.Sc. in Information Technology [M.Sc.(I.T.)]

From

University of Rajasthan, Jaipur (Raj.)(Accredited A+ University By UGC-NAAC)

Project Completed at:

NATIONAL INFORMATICS CENTRE

Vitta Bhawan, Janpath Road, Jaipur.

Submitted To : Submitted By :Mr. Ashish Chandra Swami Mohammed Hashim Head of Dept. (I.T. & MCA) M.Sc.(I.T.) 4th Sem.


A

Project Report

On

FILE TRACKING SYSTEM & FREQUENTLY ASKED QUESTION

Project Submitted in partial fulfillment of the requirement of the award of the degree of

M.Sc. in Information Technology [M.Sc.(I.T.)]

ATNATIONAL INFORMATICS CENTRE

Vitta Bhawan, Janpath Road, Jaipur

Under the guidance of : Undertaken By :Mr. Paresh Jain Mohammed Hashim(Scientist –C) M.Sc.(I.T.) 4th Sem.NIC, Vitta Bhawan, Jaipur


FILE TRACKING SYSTEM

&

FREQUENTLY ASKED

QUESTION

S. No. Particulars

1. INTRODUCTION ------------------------------------------------------------------------

1.1 Organization Profile ------------------------------------------------------------


1.2 Introduction of Project -----------------------------------------------------------1.3 Description of Existing System --------------------------------------------------------1.4 Scope of The Software ----------------------------------------------------------2. ANALYSIS -------------------------------------------------------------------------------

2.1 System requirement specification -----------------------------------------------------2.2 General characteristics --------------------------------------------------------

2.3 Specification Requirement ---------------------------------------------------3. DESIGN -----------------------------------------------------------------------------------

3.1 System Design Specification -------------------------------------------------

3.2 Decomposition Description ---------------------------------------------------3.3 Data Design --------------------------------------------------------------------

4. DESIGN IMPLEMENTATION--------------------------------------------------------

4.1 Methodology adopted ---------------------------------------------------------

4.2 Details of Hardware and Software ------------------------------------------4.3 Input and Output Screen Design ---------------------------------------------

5. TESTING ----------------------------------------------------------------------------------

5.1 Methodology used for Testing -----------------------------------------------5.2 Test Report ---------------------------------------------------------------------

6. MANUAL ---------------------------------------------------------------------------------

6.1 User/Operational Manual -----------------------------------------------------

6.2 System Maintenance ----------------------------------------------------------7. REFERENCES ---------------------------------------------------------------------------

7.1 Bibliography -------------------------------------------------------------------7.2 Website References -----------------------------------------------------------

INDEX (FILE TRACKING SYSTEM & FREQUENTLY ASKED QUESTION)


INTRODUCTION

ABOUT THE ORGANIZATION


NATIONAL INFORMATICS CENTRE

Organizational Structure of NIC


The organizational structure of NIC encompasses its Headquarters at Delhi, Regional Centers at Pune, Bhubaneswar and Hyderabad, State Units in all the State Capitals and Union Territory Headquarters and offices in over 440 Districts of the country.

At the NIC headquarters, a large number of Application Divisions have been created to provide informatics support to the Ministries and Departments of Central Government. All these divisions are headed by officers at various levels and comprise technical officers and staff at the level of Principal System analysts, Senior System Analysts, Programmers and Programmers Assistants .The Division Heads report to the Director General of National Informatics Centre.

There are large numbers of support groups at the NIC headquarters, which provide the required informatics infrastructural backbone for helping the Application Division deliver services to the users. The network communication group operates the satellite and terrestrial communication services over NICNET throughout the country.

NIC presently has strength over 3000 persons with 80% of them being technical personnel. Approximately, one third is located in NIC headquarters to provide informatics support to the Central Government as well as to provide central infrastructure support such as NICNET.

The principal role played by NIC , beside changing the work culture and making the administration more effective and efficient at all levels , is in the nature of demolishing barriers on information dissemination and in making the working of the Government more transparent to the public , as well as in making the working of the Government more transparent to the public , as well as in making the information more readily available from one Department to the another , from the State Government to the Central Government.

NICNET


NICNET has been operational since 1987. It links all the District Headquarters, State/ Union Territory Capital. The Architecture is summarized here. NICNET operates on a low speed using a network.

C –Band transponders in INSAT 1-D. With a Master Earth Station hub a 13 meter Antenna in the heart of Delhi More than 750 Micro Earth Station (Very Small Aperture Terminals,

VSATs) in many cities connected to Pentium Chip based computers.

NICNET ACCESS TECHNIQUE

NICNET access technique is based on

The Speed Spectrum Multiple Access (SSMA) Code Division Multiple Access (CDMA) technology operating in

the C-Band.

MICRO EARTH STATION

The C-200 Micro Earth Station transmits at 1200 bps (C-201) or at 9600 bps (C-205).

It consists of following modules: -

Antenna Controller

The controller is connected to the antenna with up to 100 meters of twin coaxial cables. The user terminal equipment is connected to the controller by means of Standard Rs. -232 or Rs. -422 cable .The controller module has 2 ports, which are connected to the user’s terminal equipment .The network follows CCITT recommended X.25 protocols. At Micro Earth Station mode , a built in Packet Assembler /Dissembler (PAD) facility is available to permit attachment of up to two asynchronous user terminals upon broadcast or single addressed designation .


MAJOR FUNCTIONS OF MASTER EARTH STATION

It provides: -

Data gram, permanent and switched virtual circuits. Protocol Interface to accept and deliver data from multiple-

user host-computer data links. Modulation of radio frequency (RF) carrier. Demodulation of the inbound data stream. Spread –Spectrum encoding of the outbound.

Features of NICNET

Flexible Network Structure. Broad Spectrum Integration. Compatibility Network Access Line Utilization Error free Transmission

NICNET facilitates horizontally and vertically, integrates the Indian Government at the Central and State level, as well as the District Administrations.

NICNET facilitates the following requirement of NIC in serving various Government departments and associated organizations throughout the country.

Monitoring of vital social – economic projects, On – Line retrieval from databases and updating , Optimum utilization of expensive computer resources, Emergency communication system, Sharing latest software tools, Dissemination of information, Exchange of messages and information between Central

Government, State Government and District Administration.


NIC NET SERVICES

NICNET, which presumably has more than 750 Micro Earth Stations in Operation, serving the Central Government and State Government and other Organizations, provides the following Services: -

Video conferencing facility International mail facility Interactive Access Remote Database Access File transfer facility Electronic mail facility Emergency Message Communication facility International Remote Access Electronic data Interchange (EDI) Internet Access

A number of support services are being offered for achieving maximum Network Security, which are described below:

Vulnerability Assessment Service

Vulnerability assessment tools are used for determining existing problems or unguarded entrances in systems also called security holes.

These holes may lead to potential problems. A substantial job is required to be done to find out, what kind of problems would arise if these holes were exploited.

These tools may allow diagnosis of systems configurations, which lead to potential problems.


Firewall Service

Enterprise firewalls are useful when internal systems are accessed from outside the organization. Firewalls are part to the security solution for an organization, and are used for restricting traffic according to certain parameters and policies.

Virus scanner has been installed for scanning and removing viruses from E-mail traffic entering NICNET.

Training Programs of NIC

At NIC, training is considered the most important single component for introducing technologies changes about cultural & attitudinal changes in the functioning of the Government. From awareness creation of the senior officials, to routine programming and operational training of the staff at the working level, training encompasses all kinds of courses for various levels of officials. In 15 years, NIC has trained over 50,000 persons at various levels. Training centers are located at NIC Headquarters, at the three Regional Centers and all the State centers. The training division’s keeps pace with the latest technological changes keeps on updating its training programs as well as methods of training. The training division also conducts state-of-the-art technology- based programs to upgrade knowledge and skills of in-house staff, in addition to offering computer appreciation programs simultaneously with man-machine ratio of 1:1 in the practice sessions. State-of-the-art systems include multimedia systems, with the exclusively designed, engineered and developed low cost multimedia workstations, AVI. Multimedia software platform integrates video and audio with existing DOS applications. Three lecture halls and two conference halls are equipped with modern computer based teaching aids. Video library is also available. Well-established labs provide man-machine ratio 1:1. The division can train 200 participants at a time by running parallel program.


FINANCE DEPARTMENT

INTRODUCTION

The Directorate of Treasuries and Accounts (Directorate) setup in the year 1960 under

Finance Department (FD) of Government of Rajasthan is the financial and technical

controller of all the district treasuries in Rajasthan. The directorate is responsible for

providing department wise monthly revenue and expenditure details received from

district treasuries to FD and Accountant General (AG) office etc. The Directorate

performs financial control through treasuries, independent sub treasuries, pension sub

treasuries, revenue sub treasuries and Assistant Pay and Accounts officer (APAQ) at

Delhi. State Government undertook Treasury Computerization in the year 1996-1997 to

overcome the weakness of the manual system and to readily make available financial

information from treasuries to the FD through the computerized system while reducing

the manual effects in preparation and compilation of information.

The National Informatics Center (NIC) was responsible for software development,

hardware procurement, training to the treasury personnel, and maintenance of the

software.


Objectives of Computerization:-

The DTA started planning of computerization of treasuries in 1995-96, which was to be

completed by 1999-2000. The Data Depository System (DDS) was taken up for

implementation in 2002-03. The main objectives of computerization were as under:

1) Treasury Computerization System: -As per the project report prepared and submitted by the NIC to the DTA, the main objective of computerization of treasuries was preparation and submission of computerized monthly account to the AG and FD.

2) Data Depository system: -The DDS was to be developed to achieve the objectives of (i) major reduction in paper work resulting in savings of manpower, stationary And time, (ii) faster processing of pay bills, (iii) easy maintenance of employees records, (iv) availability of data in electronic form for deduction and collection agencies like State Insurance and Provident Fund Department, LIC etc., (v) implementing data repository scheme related to employees for policy making, (vi) reduction in the number of DDOs, and (vii) timely issue of annual statements to employees.


INTRODUCTION OF PROJECT

Online File Tracking System and Frequently Asked Question Software is a fully featured web based application, which is used for the management of Office Documents such as Letters, Reports, Circulars, Cheques, Meetings Details and Software. The system allows uploading and downloading of Letters, Circulars, and Software’s developed by NIC.FAQ software maintain Queries such as some problem occur in Software etc. and allow the Solution of that Problem.

Key Features: -

Easy Navigation. Web Based Form Submission. Safe and Secure system for Owner. Maintenance of Master Data such as

Project Category Software etc.

Maintenance of Letters, Reports, Documents, Project and Software. Uploading and Downloading of scanned images of Letters, Reports, Circulars,

Cheques, Meetings Details. Uploading and Downloading of Software’s. Maintain Queries for Future Use


EXISTING SYSTEM


Description of Existing System

The existing system is a Window based application. It performs operations to maintain

Documents, letters, and maintain user query.

Various Features of Existing Project:

The existing system performs all the basic operations that a basic application Performs. Its features are categorized as follows:

Insertion of Record: Deletion of Record: Updating of Record:

Bottlenecks Identified in the Existing System

The Bottleneck identified in the existing system may be due to advancement in the

Technology.

The various bottleneck identified in existing system can be categorized as follows:

The existing system is not web based hence it does not provides advantages of web based system

Need of New System :

To remove the bottleneck in the system and to make system versatile for present as well as future we need to design a new system. The need of new System arises due to following reasons:

Web based application is needed so that system can be simultaneously used by many users at different locations.


By using the Server to store Database, data safety can be ensured.

To provide facility to upload and download Documents, Scanned images of documents and Software’s.

SCOPE OF SOFTWARE


Scope of the Software:

Scope of File Tracking System and Frequently Asked Question is to allow uploading and downloading of Letters, Documents, Project and Software’s developed by NIC.FAQ Software maintain all Queries and allow the Solution

Scope of Tracking System and Frequently Asked Question can be categorized in two points:

Present Scenario:

At present the system is automated and can perform all the needs of the system, Which can be summarized as follows?

Maintenance of Master Data such as Project Software Category Sub Category

Addition of Master Data. Deletion of Master Data Updating of Master Data. Users belonging to different USER category can access various modules

depending on there access rights. Maintenance of details of document which are issued for NIC Showing of Scanned Image of document.


Future Scenario:

The system is built on such Flexible technology that it can be modified and further enhanced according to future needs.

The system is independent of platform so it may be further extended to different hardware configuration.

.

ANALYSIS


Software Requirement Specification

Introduction:

Online File Tracking System and Frequently Asked Question Software is a fully featured web based application, which is used for the management of Office Documents such as Letters, Reports, Meetings Details and Software. The system allows uploading and downloading of Letters, Circulars, and Software’s developed by NIC.FAQ software maintain Queries such as some problem occur in Software etc. and allow the Solution of that Problem

Scope of the Software:

Scope of File Tracking System and Frequently Asked Question is to allow uploading and downloading of Letters, Documents, Project and Software’s developed by NIC.FAQ Software maintain all Queries and allow the Solution.

Scope of Tracking System and Frequently Asked Question can be categorized in two points:


Present Scenario:

At present the system is automated and can perform all the needs of the system, Which can be summarized as follows:

Maintenance of Master Data such as Project Software Category Sub Category

Addition of Master Data. Deletion of Master Data Updating of Master Data. Users belonging to different USER category can access various modules

depending on there access rights. Maintenance of details of document which are issued for NIC Showing of Scanned Image of document.

Future Scenario:

The system is built on such Flexible technology that it can be modified and further enhanced according to future needs.

The system is independent of platform so it may be further extended to different hardware configuration.

Overview:

This project is categorized in some modules and interfaces which are as follows:

Modules: This project is categorized in some modules and interfaces which are as follows:-

Administration module. Transaction module Report module.


Use Case:

o Use Case for Administration: This interface is for Administration for maintaining the database

o Use Case for Transaction: This interface provides for addition, deletion, updating of database regarding,.

o Use Case for Report Generation : This interface generates reports of

uploaded documents and soft ware’s and also can download them

Overall description

Administrator

Transaction


REPORTER ANIMATOR

LOGIN

Maintain Master FilesAdd Record Delete RecordUpdate Record View Record

ADMINITRATOR

TRANSACTION

Maintain Transaction FilesAdd Record Delete RecordUpdate Record View Record

Generates Various Report

DATA BASE

Reporter

GENERAL CHARACTERISTICS

Introduction:

It introduces software product, describes their characteristics and limitations affecting the product and its requirements.

Product Perspective:

The product independently governs the tools to provide the information regarding software, project, and category and sub category and manage the same. It provides for insertion, deletion and updation of information, to various users depending upon their rights and passwords.

Product Activity:

Functions of software are divided into following categories.


Functions available for Administrator

Can update the database Can delete records from the database Can insert records into database Can view database

Functions available for Transaction Authority

Add information of the product Delete information of the product Update information of the product.

Functions available for Report Generators

View information through reports available.

User Characteristics:

Administrator

Must have knowledge of computers. Must be aware of all the mandatory fields in the form

Transaction Authority

Should have general knowledge of working of at DTA. Should have knowledge of working with computers. Must be aware of all the mandatory fields in the form

Report Generators

The site is completely GUI so the Report Generators will never feel the difficulty in accessing the required report . User must be aware of all the mandatory fields in the form. Information filled by the user must be accurate so that he may be able to access all the pages of the site correctly.


Assumptions And Dependencies:

We are assuming that the Administrator, the Transaction authorities, Report generating authorities are officers of DTA, who are well acquainted with working of department and it’s data.

We are assuming that users are familiar with simple English language.

General Constraints:

Availability of Internet connection.

SPECIFIC REQUIREMENT

It includes some special requirement such as functional and nonfunctional requirements.

Functional Requirements:

It includes the following modules:-

Selecting the Home page module: Home page will allow the users to select services of their interest.

INPUT: the click on particular services which is acting as a hyperlink to another web page.


PROCESS: request to fetch the web page containing the options of selected services e.g. allow administrator to maintain master data, transaction authority to maintain transaction data, reporting authority to access page for selecting report options.

OUTPUT: page containing details of options of the services.

Selecting the Administration module: This module will allow administrator to do the tasks concerned with administration of website.

INPUT: the click on a particular administrative option, which is acting as a hyperlink to another web page.

PROCESS: A request to fetch the page to allow administrator to carry out selected administrative task

OUTPUT: page allowing Administrator to select administrative task will be displayed.

Selecting the Transaction module: This module provides the facility to transaction Operators to manage information regarding Project, Software,Documents,Queries etc.

INPUT: click on option will act as a hyperlink to another web page containing transaction menu.

PROCESS: request to fetch the page to allow Transaction Operators to add, delete and update information.

OUTPUT: page that allows Transaction Operators to carry out their task.

Selecting the Report module: this module will allow the generation of static departmental reports.

INPUT: click on a particular option will act as a hyperlink to another web page

PROCESS: A request to fetch the page showing the report options.


OUTPUT: page that allows Report Operators to select report option.

Non Functional Requirement:

This requirement defines the following requirements:-

Performance: any number of clients can access site at one time and the site should be accessed fast.

Safety: prevent the client from directly accessing some specific page by knowing its path.

Quality: this site should be in GUI form so that user has to make little efforts.

External Interface Requirement:

User Interface:

The software must be developed in such away that it can hold the users interest, While navigating the site .The site should be developed in user friendly manner so that they can explore it easily.

Hardware Interface:

Able to interact with the hardware that is compatible. Availability of INTERNET Connection is constraint.

Server Side:- 512 MB RAM , 2 GB HARD DISK, P-IV

Client Side:- 64 MB RAM, P-III processor

Software Interface:

Server Side


Web Server : IIS 4.0(Internet Information Services) Operating System : Windows XP/2000 Server

Developer Side

Front End : ASP.NET Back End : SQL SERVER 2000 Operating System : Windows XP/2000 Server Web Server : IIS 4.0(Internet Information Services)

Client Side

Web Browser : Internet Explorer 6.0 , Mozilla Firefox & above

DESIGN


SYSTEM DESIGN SPECIFICATION

INTRODUCTION:

PURPOSE:

Software Design Specification (SDS) is a solution to how to approach to the creation of a new system. this important phase is composed of several steps to provide the understanding and the procedural detail to implement the system design which goes through a logical and physical task of development. Logical design reviews the present physical system, prepares input output specification, make audit security detailed implementation plans and prepares a logical design


walk through. The physical design makes out the detail of the system, plans the system, implements plans and specifies any new hardware and software product.

System design is highly creative process that can be greatly facilitated by the Following.

Strong problem definition Pictorial description of existing System Set of requirement of new System

With these basic concepts stepwise refinement approach was adopted in this project.the design is flexible enough to accommate the change easily. Our SDS includes the description of all modules, which are defined in the designing of the software.

SCOPE

Scope of File Tracking System and Frequently Asked Question is to allow uploading and downloading of Letters, Documents, Project and Software’s developed by NIC.FAQ Software maintain all Queries and allow the Solution.

DECOMPOSITION

DESCRIPTION

Module Decomposition

There are three modules in the system, which are as follows


Module 1- Administration

This module authenticates the Administrator to log on to the site and process involved in this module is to validate the Administrator. The processes are Add, Delete, View and Update.

Module 2 – Transaction

This module authenticates Transaction operator to log on to site and the process involved in this module allows maintenance of transaction details regarding Project, Software, Document, Queries etc.. The processes are Add, Delete, View and Update.


ONLINE FILE TRACKING SYSTEM & FREQUENTLY ASKED QUESTION

MASTER

REPORT GENERATION

TRANSACTION

Module 3- Report

This module provides for generation of various reports for the user according to some given criteria. The user selects one of the given criteria’s and the report is generated accordingly.

Process Decomposition

Module1- Administrator

Add: This process will allow the Administrator to add entries in table

like Project, Software, Category, Sub Category etc.

Delete: This will allow Administrator to delete entries in the above-mentioned tables.

View: This will allow Administrator to view entries of the above-mentioned tables.

Update: This will allow Administrator to update information in the above- mentioned tables.

Module 2- Transaction

Add: This process will allow Transaction Operator to add entries of Project, Software, Category, Sub Category, Queries after password validation in the concerned tables.

Delete: This process will allow Transaction Operator to delete entries of the Project, Software, Category, Sub Category, Queries after password validation in the concerned tables.

View: This process will allow Transaction Operator to view entries of the Project, Software, Category, Sub Category, Queries after password validation in the concerned tables.


Update: This process will allow Transaction Operator to update entries of the Project, Software, Category, Sub Category, Queries after password validation in the concerned tables.

Module 3- Reports

Report Generation Process: Generation of Reports Data Decomposition

Database

MS SQL SERVER 2000 (DBMS) has been used to create and handle data.

Table Structure

Table 1 : FAQ_Result_Table

This table contains the Result Details.

S. No. Field Name Type Length Constraint Field Descriptions1. Project_Name Varchar 50 Not Null Project Name2. Soft_Name Varchar 50 Not Null Software Name3. Prob Varchar 2048 Not Null Problem4. Sol Varchar 2048 Not Null Solution5. File_Name Varchar 2048 Not Null Uploaded File Name6. Path Varchar 2048 Not Null Uploaded File Path7. Id Numeric 9 Not Null Identity

Constraints –Primary Key- Id

Table 2 : FAQ_Soft_Table

This table contains the Soft Master detailsS. No. Field Name Type Length Constraints Field Descriptions

1. Soft_Name Varchar 50 Not Null Soft Name2. Soft_Code Varchar 50 Not Null Soft Code

Constraints –Primary Key- Soft_Code

Table 3 : Login_Table

This table contains the Password details

No. Field Name Type Length Constraints Field Descriptions

1. User_nm Varchar 50 Not Null User Name


2. Pass_nm Varchar 50 Not Null Password

Table 4: FAQ_Project_Table

This table contains details of all the Projects.

S. No.Field Name Type Length Constraints Field Descriptions

1. Project_Name Varchar 50 Not Null Project Name2. Project_Code Varchar 50 Not Null Project Code

Constraints –Primary Key- Project_Code

Table 5 : FAQ_RTmp

This table contains the Result Details According Project Name.

S. No. Field Name Type Length Constraints Field Descriptions1. Soft_Name Varchar 50 Not Null Software Name

According to Project name

2. Prob Varchar 2048 Not Null Problem

3. Sol Varchar 2048 Not Null Solution4. File_Name Varchar 2048 Not Null Uploaded File name

Table 6 : Cat_Table

This table contains the Category details.

S. No. Field Name Type Length Constraints Field Descriptions1. Cat_Id Int 4 Not Null Category Id

2. Cat Varchar 50 Not Null Category Name

Constraints –Primary Key- Cat_Id

Table 7 : SubCat_Table

This table contains the SubCategory details.

S. No. Field Name Type Length Constraints Field Descriptions1. SubCat_id Int 4 Not Null Sub Category Id

2. SubCat Varchar 50 Not Null Sub Category Name


Constraints –Primary Key- SubCat_ Id

Table 8: File_Table This table contains the Uploaded File details.

S. No. Field Name Type Length Constraints Field Descriptions1. f_id Int 4 Not Null File Identity

2. File_Name1 Varchar 2048 Not Null Uploaded File Name

3. r_id Int 4 Not Null Identity

4. Path Varchar 2048 Not Null Uploaded File path

Constraints –Primary Key- f_id , r_id

Table 9: Project_Table

This table contains details of all the Projects.


1. Project_Name Varchar 50 Not Null Project Name2. Project_Code Varchar 50 Not Null Project Code

Table 10 : R_tmp

This table contains the Category details.

S. No. Field Name Type Length Constraints Field Descriptions1. r_id Int 4 Not Null Identity

2. f_id Int 4 Not Null File Identity



4. Sud_Cat Varchar 50 Not Null Sub Category Name

5. Subject Varchar 50 Not Null Subject

6. S_Date Date 50 Not Null Date


8. Path Varchar 2048 Not Null Uploaded File Path

Table 11 : ResultCat_Table

This table contains the Result details.S. No. Field Name Type Length Constraints Field Descriptions

1. r_id Int 4 Not Null Table Identity

2. Project_Name Varchar 50 Not Null Project Name


4. Sub_Cat Varchar 50 Not Null Sub Category Name


6. S_Date Date 8 Not Null Date

Constraints –Primary Key- r_ id

Table 12: Rpt_Cat

This table contains details of all the Project according to the category.


1. r_id Int 4 Not Null Identity

2. Project_Name Varchar 50 Not Null Project Name

3. Sub_Cat Varchar 50 Not NullSub Category Name


5. S_Date Varchar 50 Not Null Date




8.Path.

Varchar 2048 Not Null Uploaded File Path

Table 13: Rpt_Tmp

This table contains details of all the Project according to the category.


1. r_id Int 4 Not Null Identity 2. Project_Name Varchar 50 Not Null Project Name


4. Sub_Cat Varchar 50 Not Null Sub Category Name


6. S_Date Varchar 50 Not Null Date



9. Path. Varchar 2048 Not Null Uploaded File Path


Flow Chart


Start

Login

Userna

me

Passwor

d is

Correct

?

Message

“Username

Password

incorrect”

Stop

Cancel NO

Administrator

Transaction Report FAQ

A B C D

Yes

Login again


A

B

C

Project Master

Category

Sub

Category

File upload

E

Project wise

Category wise

F

G

D

D

Administrato

r

Transaction Report Back

Project

Software

Data Entry

Upload

Project wise

H

I


E

Start

Select Project to which the document

belong

Select Category (Letter, Document)

Select Sub Category (Resume,

Pension)

Enter Subject

Select Date

Select document or s/w to be uploaded

Upload Document

End

F

Start

Select Project Name to which the document

belong

Show all document of selected Project

Select Required Document

Perform the desire operation

(Download)

G

Start

Select Category to which the document belong

Show all document of selected Category


Perform the desire operation

(Download)

End End


H

Start

Select Project to

which the document belong

Select s/w to which

the document belong

Enter Problem

Enter Solution

Select document to be uploaded

Upload Document

I

Start

Select Project Name to which the document belong

Show all document of selected Project


Perform the desire

operation (Download)

End

End

Design Implementation


“Methodology adopted” Active Server Page(ASP.NET)

Introduction of ASP.NET

Microsoft Active Server Pages (ASP.NET) is a server-side scripting environment that you can use to create dynamic and interactive Web pages, and to build powerful Web applications. When the server receives a request for an ASP.NET file, it processes server-side script code contained in the file to build the HTML Web page that is sent to the browser. In addition to server-side script code, ASP.NET files can contain HTML (including related client-side scripts) as well as calls to COM components that perform a variety of tasks, such as connecting to a database or processing business logic.

ASP.NET Compatibility

ASP.NET is a Microsoft Technology

To run IIS you must have Windows NT 4.0 or later

To run PWS you must have Windows 95 or later

How Does ASP.NET Differ from HTML?

When a browser requests an HTML file, the server returns the file


When a browser requests an ASP.NET file, IIS passes the request to the ASP.NET engine. The ASP.NET engine reads the ASP.NET file, line by line, and executes the scripts in the file. Finally, the ASP.NET file is returned to the browser as plain HTML

MS SQL SERVER 2000

Introduction to MS SQL SERVER 2000

MS SQL SERVER 2000 is a computer application use to create and manage computer based database on desktop computer and/ or on connected computers (a network). MS SQL SERVER 2000 can be used for personal information management (PIM), in a small business to organize and manage all data, or in enterprise to communicate with servers.

MS SQL SERVER 2000 DESCRIPTION

MS SQL SERVER 2000 is a powerful program to create manages databases. It has many built in features to assist in constructing and viewing info. Access is much more involved and as a genuine database application.Some keywords involved in this process are Database files, Tables, Records, Fields and Data types. Here is a hierarchy that MS SQL SERVER 2000 uses in breaking down a database.

FIELD DATA TYPES AVAILABLE IN MS SQL SERVER 2000

The following list summarizes all the field data types available in MS SQL SERVER 2000, their uses, and their storage sizes.

Varchar: Use for Varchar or combinations of Varchar and numbers, such as addresses, or for numbers that do not require calculations, such as phone numbers, part numbers or postal codes. Stores up to 255 characters. The Field Size property controls the maximum number of characters that can be entered.


Memo: Use for lengthy Varchar and numbers, such as notes or descriptions. Stores up to 65,536 characters.

Number: Use for data to be included in mathematical calculations, except Calculations involving money (use currency type). Stores 1, 2, 4, or 8 bytes; stores 16 bytes for Replication ID (GUID). The Field Size

property defines the specific Number type.

Date/Time: Use for dates and times. Stores 8 bytes.

Currency: Use for currency values and to prevent rounding off during Calculations. Stores 8 bytes.

AutoNumber: Use for unique sequential (incrementing by 1) or random numbers That is automatically inserted when a record is added. Stores 4 bytes;

Stores 16 bytes for Replication ID (GUID).

Yes/No: Use for data that can be only one of two possible values, such as Yes/No, True/False, On/Off. Null values are not allowed. Stores 1 bit.

OLE Object: Use for OLE Objects (such as Microsoft word documents, Microsoft Excel spreadsheets, pictures, sounds, or other binary data) that were Created in other programs using the OLE Protocol. Stores up to 1 gigabyte (limited by disk space).

Hyperlink: Use for hyperlinks. A hyperlink can be a UNC path or a URL. Stores Up to 64,000 characters.

Lookup Wizard: Use to create a field that allows you to choose a value from another Table or from a list of values using a combo box-- choosing this option

I The data type list starts a wizard to define this for you.

Requires the same storage size as the primary key that corresponds to The Lookup field—typically 4 bytes.

JavaScript Language:

What is JavaScript ?

JavaScript is a scripting language

A scripting language is a lightweight programming language


JavaScript is a light version of Microsoft's programming language Java

How Does it Work?

When a JavaScript is inserted into a HTML document, the Internet browser will read the HTML and interpret the JavaScript. The JavaScript can be executed immediately, or at a later event.

Hardware Specification:

The following are the minimum hardware required to operate FILE TRACKING SYSTEM & FREQUENTLY ASKED QUESTION:

Server Side : 512 MB RAM, Minimum 2 GB Hard Disk, P-IV processor

Client Side: 64 MB RAM P-III processor

Software Specification:

The following are the minimum software required to operate File Tracking System & Frequently Asked Question

:

Server Side

Web Server : IIS 4.0(Internet Information Services) Operating System : Windows XP/2000 Server

Developer Side

Front End : ASP.NET Back End : MS SQL SERVER 2000 Operating System : Windows XP/2000 Server Web Server : IIS 4.0(Internet Information Services)


Client Side

Web Browser : Internet Explorer 6.0 , Mozilla Firefox and above

Screen Layout


Login Page:

File Uploading System and Frequently Asked Question starts with a splash screen. The username and correct password is asked from the user before using the project.


Administrator Module

“Layout”


Project Master Form:


Editing in Project Master :


New Data Insert in Project Master :


Data Delete in Project Master:


Category Master Form


New Data Insert in Category Master :


Editing in Category Master :


Data Delete in Category Master


Sub Category Master Form:


New Data Insert in Sub Category Master:


Editing in Sub Category Master:


Data Delete in Sub Category Master


Transaction Module

“Layout”


File Upload Module :


Upload File :


File Uploaded :


FTS REPORT VIEW


Category Wise Report :-


Browse Screen Open Document :


Project Wise Report :-


Browse Screen Open Document :


FAQ Administrator Module “Layout ”


Project Master Form:


Data Insert in Project Master Form :


View of Project Master Form :


Data Delete in Project Master Form :


Editing in Project Master Form :


Software Master Form :


Data Insert in Software Master Form :


View of Software Master Form :


Data Delete in Software Master Form :


Editing in Software Master Form :


FAQTransaction

Module“Layout”


File Upload Module :


Data Upload :


View records of Data Upload File :


REPORT VIEW


Project Report :


Browse Screen to Print Document :


Software Report :


Browse Screen to Print Document :


Data Entry Report :


Download File Report :


Browse Screen open Document :


TESTING

Methodology used for Testing

TESTING OBJECTIVE

Our objective of testing is to find errors and remove them.


TESTING PRINCIPLES

All tests should be traceable to customer requirements. Testing should be planned long before testing begins. The Pareto principle applied to the software testing. Testing should begin “in the small “ and progress towards testing “in the

large” Exhaustive testing is not possible. To be most effective, testing should be conducted by an independent third

party.

TESTING METHODOLOGY

Our strategy of software testing may be viewed in the

conVarchar of spiral .We started with Unit Testing at the

vertex of the spiral and concentrated on each unit (i.e.

component ) Of the software as implemented in source code .

In this testing we tested for following:

Interfaces Local Data Structure Independent Paths Boundary Conditions Error Handling Paths

We followed the WBT techniques for Unit Testing and we

performed

Condition Testing Loop Testing

Integration Testing :


Integration testing is a systematic technique for constructing the program structure while at the same time to uncover errors associated with the interfacing. The objective is to take the unit tested modules and build a program structure that has-been detected by designing. Testing progressed moving outward along the spirit to integration testing, where the focus remained on design and construction of software architecture .We followed the BBT and WBT techniques of testing in integration testing.

Mixed Integration Testing :

Mixed integration testing is the testing that that uses top-down tests for the upper levels of the program structure, coupled with the bottom-up tests for the sub-ordinate levels. First we tested atomic modules using bottom-level tests one by one. After it they are combined with other modules and then tested. When they are combined into a top-level module, then that module is tested for functioning of each module .As an error is found it is corrected using the top-level tests.

Regression Testing :

Each time a new module is added as part of integration testing , the software changes. New data flow paths are established, new I/O may occur and new control logic is invoked. These changes may cause problems with the functions that previously worked flawlessly. Regression testing is the re-execution of some subsets of tests that have already been conducted to ensure that changes have not propagated unintended side effects we also moved in the same way. Whenever we combined a unit-tested module with another module, we again tested both the modules to check them for correct functionality For example, after unit testing of Administration and Transaction modules when they combined we tested them again for their whole functionality.

System Testing :


During System Testing, the system is used experimentally to ensure that the software not fail, i.e., it will run according to its specifications and up to the expectations of the user, special test data input for processing is used and the results are examined.

Validation Testing :

Taking other turn outward on the spiral , we encounter a validation testing , where requirement established as part of software requirement analysis revalidated against the software that has been constructed. At the culmination of integration testing, software is completely assembled as a package, interfacing errors have been uncovered and corrected and final series of software tests –validation testing- may begin. Validation can be defined in many ways, but a simple definition is that validation succeeds when software functions in a manner that can be reasonably expected by the customer. Software is achieved through a series of BBT. That demonstrates conformity with requirements. Validation testing provides final assurance that software meets all functional, behavioral and performance requirements. Finally, we arrived at System Testing, where the software and other system elements are tested as a whole.

Usability Testing :

The key to usability testing is to study what a user actually does. An observer records the user’s actions and reactions to determine what types of problems the user encounters and how he overcomes them. The main steps of usability testing are Identify the websites’ purpose

Identify the intended users Define tests and conduct the usability testing. Analyze the acquired information

Acceptance Testing :


It is sometimes performed with realistic data of the client to check whether the software is working properly. Testing here focuses on the external behavior of the system. The internal logic of the system is not emphasized. The user enters the live data and reports are tested to their satisfaction.

Navigation Testing :

Good testing is an essential part of our website, especially those that are complex and provide a lot of information. Assessing navigation is a major part of usability. Most users expect the following:

Easy and quick access to the information they want. Logical hierarchy of pages Confirmation of where they are at any point. Facility to return to previous pages or home pages. Consistent look and layout of every page Uncluttered pages.

Key issues with navigation testing include:-

Moving to and from pages Scrolling through pages Clicking on all the images and their thumbnails to ensure that they

work Testing all the links for validity and correctness. Ensuring no broken links exist. Viewing table and forms to verify proper layout which can vary under

different browsers. Ensuring compatibility and consistent usage of buttons and mouse

actions.

Link Testing :

As part of navigation testing, the tester must ensure that all links work as expected.


This means:

Following all links presented on a website, including hyperlinked Varchar , Linked graphics etc.

Verifying that the pages retrieved are the ones that are expected.

Ensuring that all errors are user friendly.

Form Testing :

Websites that use forms need tests to ensure that each field works properly and that the form posts all data as intended by the designers.

It includes:

Using the tab key to verify that the form traverses fields in proper order, both forward and backward.

Testing boundary values.

Checking that forms traps invalid data correctly, especially numeric formats.

Verifying that the form updates the information correctly.

Page Content Testing :

Each web page must be tested for correct content from the user perspective.These


tests fall into two categories: Ensuring that each component functions correctly and ensuring that the content of

each is correct.

The first category includes:

All images and graphics display correctly across through various browsers.

All content is present per the requirements. Page structures are consistent across browsers. Critical pages maintain same content from version to version. All parts of table and forms are present and in the right place. Links to relevant content inside and out of site are accurate. Web pages are visually appealing.

The second category includes:

Determining whether the new pages download the same as the prior pages.

Checking whether the new pages rare identical with prior version. Checking whether vital information is same or different. Verifying whether links are still correct .

Database Testing :

Database testing involves some in depth knowledge of the given application and requires a more defined plan of approach to test the data. The tester must have the ability to query the database consistently at Specified point in the workflow. Key issues in the database testing Include: -

Data integrity Data validity (input into database in proper form ) Data manipulation and updates.

Test Report :

Login Form


S.NO. FIELD NAME INPUT EXPECTED OUTPUT

RESULT

1

User_nmPass_nm

blankblank

Error message, Pls Enter User Name & Password

Error message, Pls Enter User Name & Password

2User_nm Pass_nm

asablank

Error message, Pls Enter Pasword

Error message, Pls Enter Pasword

3

User_nm Pass_nm

nicasd

Error message, Invalid Password

Error message, Invalid Password

4User_nm Pass_nm

nicnic123

Accepted Accepted

5

User_nm Pass_nm

adminnic

Accepted Accepted

Project Master Form


RESULT

Project_Name blank Error message, Error message,


1 Project_Code blank Enter Project Name

Enter Project Name

2

Project_NameProject_Code

blankjaipur

Error message, Enter Numbers only Project code

Error message, Enter Numbers only Project code

3Project_ NameProject_Code

blank1234

Error message, Enter Project name

Error message, Enter Project name

4Project_NameProject_Code

DDS1234

Accepted Accepted

Software Master Form


RESULT

1

Soft_NameSoft_Code

blankblank

Error message, Enter Software Name

Error message, Enter Software Name

2

Soft_NameSoft_Code

jaipurblank

Error message, Enter Software Code

Error message, Enter Software Code

3Soft_NameSoft_Code

blank123

Error message, Enter Software name

Error message, Enter Software name

4Soft_NameSoft_Code

Oracle123

Accepted Accepted

Category Master Form


RESULT

Cat_id blank Error message, Error message,


1 Cat blank Enter Id and Category Name

Enter Id and Category Name

2

Cat_idCat

jaipurblank

Error message, Enter Numeric Id


3Cat_idCat

12blank

Error message, Enter Category Name

Error message, Enter Category Name

4Cat_idCat

12Letter

Accepted Accepted

Sub Category Master Form


RESULT

1

SubCat_idSubCat

blankblank

Error message, Enter Id and SubCategory Name

Error message, Enter Id and SubCategory Name

2

SubCat_idSubCat

jaipurblank



3SubCat_idSubCat

12blank

Error message, Enter Sub Category Name

Error message, Enter Sub Category Name

4SubCat_idSubCat

12Note Sheet

Accepted Accepted

File Uploading Form

S.NO. FIELD NAME INPUT EXPECTED RESULT


OUTPUT

1Project_NameCatSubCatSubjectDateFile Upload

blankblankblankblankblankblank

Error message, Select Project Name

Error message, Select Project Name

2

Project_NameCatSubCatSubjectDateFile Upload

DDSLetterblankblankblankblank

Error message,Select Sub Category Name

Error message, Select Sub Category Name


DDSLetterNote sheetIssue Bill 11-11-08blank

Error message, Enter Date in MM-DD-YYYY Format

Error message, Enter Date in MM-DD-YYYY Format


DDSLetterNote sheetIssue Bill 11-11-2008blank

Error message, Select File For Uploading

Error message, Select File For Uploading

5

Project_NameCatSubCatSubjectDateFile Upload

DDSLetterNote sheetIssue Bill 11-11-2008Bill.Txt

Accepted Accepted

Entry Data Form

S.NO. FIELD NAME INPUT EXPECTED

OUTPUT RESULT

Project Name blank Error message, Error message,


1 Software NameProblemSolutionFile Upload

blankblankblankblank

Select Project Name

Select Project Name

2

Project NameSoftware NameProblemSolutionFile Upload

DDSblankblankblankblank

Error message,Select Software Name

Error message, Select Software Name

3Project NameSoftware NameProblem

SolutionFile Upload

DDSOracleHow we delete complete table?blankblank

Error message, Pls Enter Solution

Error message, Pls Enter Solution

4Project NameSoftware NameProblem

Solution

File Upload

DDSOracleHow we delete complete table?Use Drop commandblank

Error message, Pls Browse a file

Error message, Pls Browse a file

5

Project NameSoftware NameProblem

Solution

File Upload

DDSOracleHow we delete complete table?Use Drop commandCommand.txt

Accepted Accepted

User/Operational Manual

Introduction


The purpose of this document is to provide manual to users, guiding them how to use our system .The manual is supplied in conVarchar to every user including security ASP.NET etc., access rights, back up.

In our system there are following types of users who can use our system:

Administrator Transaction Report

Administrator

Administrator is the user who is responsible for maintaining database concerned with maintaining of this dynamic web based application. Maintenance of the database by Administrator can be done dynamically. He is provided interface for this purpose. The Administrator has the right to provide and change passwords for users and manage those databases that facilitates the other users to select options.

Steps to access our system by Administrator

On First page, at the middle there is a “Login” . There administrator need to enter login id as “nic” password as

“nic123”. & Second is login id as “admin” & password as “nic”.

After password validation administrator is allowed to do administrative tasks.

Transaction Authority

Transaction Authority is the user who is responsible for maintaining document, letters, query details and uploading of documents under concerned projects and category.


Steps to access our system by Transaction Authority

On First page, at the middle there is a “Login” There administrator need to enter login id as “admin” &

password as “nic”. & second is login id as “nic” & password as “nic123”.

After password validation Transaction Authority is allowed to do transactive tasks.

Reporting Authority

Reporting Authority is the user who is responsible for generating the reports of uploaded documents and softwares and also can download them.

Steps to access our system by Report Authority

On First page, at the middle there is a “Login” .

There administrator need to enter login id as “admin” & password as “nic”. & second is login id as “nic” & password as “nic123”.

After password validation reporting authority is allowed to do generate report.


SystemImplementation

System Implementation :

Implementation is the process of personnel check out, install the required equipment and application and train the user accordingly. Depending on the size of the organization and its requirements, the implementation is divided into three parts.


Stage Implementation

Here system is implemented in stages. The whole system is not

implemented at once. Once the user starts working with system

and is familiar and friendly with it, then a next stage is

introduced and implemented. Also the system is usually updated,

regularly until a final system is sealed.

Direct Implementation

The proposed new system is implemented directly and the user

starts working in the new system. The shortcomings, if any,

faced are then rectified later.

Parallel Implementation

The old and new systems are used simultaneously. This helps in

comparison of the results from the two systems. Once the user is

satisfied and his intended objectives are achieved by the new

system, he stops using old one.

The methodology that we adopted in the implementation

is Parallel Implementation i.e. the old and new systems

were used simultaneously during implementation.

System Maintenance :


Maintenance is enigma of the system development Analysts and

programmers spend far more time maintaining programs and

packages than writing them. Maintenance accounts for 60-80 % of the

total system development cost incurred. The problems in maintenance

occur largely because software is handmade product designed in

adhoc fashion with a few standards. Poor documentation makes

maintenance of the program even more difficult. The more carefully is

the system thought out and developed, with attention paid to external

influence over reasonable lifetime, the less is the maintenance

required.

Maintenance has been classified as:

Corrective Maintenance Adaptive Maintenance Perfective Maintenance

Corrective Maintenance

This means repairing the processing and performance failure or

making changes because of previously uncorrected problems or

false assumptions.

Adaptive Maintenance

This means changing the program functions as and when

required.


Perceptive Maintenance

This means enhancing the performance or modifying the

programs to respond to the user’s additional or time-to-time

changing needs.

Project Implementation

Project is running at: -

NIC, Vitta Bhawan, Jaipur

1. User Name : admin Password : nic

2. User Name : nic Password : nic123


BIBLIOGRAPHY


Books: ASP.NET in 21 Days by Techmedia. Active Server Solutions by

All Williams Kim Barber Paul Newkirk

JavaScript Interactive Course By Noel Jerke Michael Hatmaker JohnyAnderson

Beginning web programming by Jon duck ell The complete reference HTML and XHTML by

Thomas A. Powell

Websites Referred:

www.msdn.com www.w3school.com www.msdn2.microsoft.com www.coadtoad.com www.a1vbcode.com


http://www.coadtoad.com/

http://msdn2.microsoft.com/

http://www.msdn.com/

report

Documents

system maintenance

system design specification

indexfile tracking system

informatics support

asked question project

senior system analysts

description of existing

introduction of project