Electronic File Tracking System 2n1s2u

Electronic File Tracking System (EFTS) By: Farhat Sultana Saadia Khattak

Supervised by: Sir Jawad Ashraf A PROJECT SUBMITTED IN PARTIAL FULFILLMENT OF THE REQUIREMENTS OF THE DEGREE OF MASTER OF COMPUTER SCIENCE (MCS) UNIVERSITY OF SCIENCE & TECHNOLOGY KOHAT 2014

Dedicated to our beloved parents and to all those, whose prayers always pave to the success for us.

1

PROJECT IN BRIEF Project Title

:

EFTS

Organization

:

IIT

Objectives

:

Converting paper-based system to paperless environment

Undertaken By

:

Farhat Sultana,Saadia Khattak

Supervised By

:

Dr Jawad ashraf

Date Started

:

Date Completed

:

Technologies Used

:

MS Visual Studio 2012 (ASP.Net with C#), SQL Server

Operating System

:

System Used

:

Windows

2

ACKNOWLEDGEMENT I thank to my lord who gave us the knowledge, power, strength to complete this task. We learn a lot while attempting this project and it will definitely help us in the future. Many of our friends helped us to complete the project but we are really thankful to them and special thanks to Sir Qadeem from university institute of information technology, who helped us continuously during the project his management and his knowledge helped us a lot in difficult times. In the end we would like to thank all of our friends for their and encouragement.

Saadia khattak Frahat Sultana

3

DECLARATION We hereby declare that this software, neither as a whole nor as a part has been copied out from any source. It is further declared that we have developed this software and accompanied report entirely on the basis of our personal efforts. If any part of this project proved to be copied out from any source or found to be reproduction of some other. We shall stand by consequence. No portion of work presented has been submitted in of any application for any other degree or qualification of this or any other university or institute of learning.

Farhat Sultana Saadia Khattak

4

CERTIFICATION It is certified that the contents and form of project entitled “EFTS” submitted by Farhat Sultana,Saadia khattak has been found satisfactory for requirement of University of science and technology ,kohat For the award of degree of Masters in Computer Sciences (MCS) Supervisor:

Member 1: Member2: Dated:

Director:

5

ABSTRACT Although the paperless office has been imminent for decades, Documents in paper form continue to be used extensively in almost all organizations. Present day information system are designed on the premises that any paper document in use will be either converted in to electronic form or merely printed form electronic file(s) accessible to the system. Yet paper is medium of choice in many situations, mainly owing to its probability and usability, and the medium of necessity in others, especially where external communication or traditional notation of authenticity involved. Humans who find unique attractive features in both paper and electronic form of documents must survive this tension between the De-Jure banishment of paper and its De-facto prevalence. In this we propose to convert paper based document environment to paperless environment entirely. Recent technologies advances such as sensor have made in implementations of such a model very realistic.

6

Contents Project in Brief……………………………………………………… Acknowledgement………………………………………………….. Declaration………………………………………………………….. Certification………………………………………………………… Abstract…………………………………………………………….. Table of contents…………………………………………………… List of Figures………………………………………………………. CHAPTER 1 INTRODUCTION…………………………………… CHAPTER 2 LITERATURE REVIEW…………………………… CHAPTER 3 REQUIREMENT ANALYSIS……………………… CHAPTER 4 SOFTWARE DESIGN……………………………… CHAPTER 5 PROJECT MANAGEMENT……………………..… CHAPTER 6 IMPLEMENTATION…………………………….… CHAPTER 7 SOFTWARE TESTING……………………………. CHAPTER 8 CONCLUSIONS AND FUTURE WORK………… CHAPTER 9 REFERENCE AND BIBLIOGRAPHY……………. Table of Contents Chapter 1..........................................................................................................................................1 INTRODUCTION...........................................................................................................................1 1.1 PROJECT OVERVIEW........................................................................................................1 1.2 PROJECT SCOPE................................................................................................................2 1.3 PROPOSED SOLUTION.....................................................................................................2 1.4 MODULES OF PROPOSED SYSTEM....................................................................................3 1.4.1istration.........................................................................................................................3 1.4.2 s.......................................................................................................................................4 1.4.3 File Marking......................................................................................................................4 1.4.4 Reports..............................................................................................................................4 1.4.5 Security...................................................................................................................................4 1.5 PROPOSED SYSTEM OUTPUT........................................................................................5 1.6 FEATURES OF PROPOSED SYSTEM..............................................................................5 1.6.1 EFFICIENCY...................................................................................................................5 1.6.2 FRIENDLY INTERFACE...........................................................................................5 1.6.3 MINIMUM REDUNDANCY...........................................................................................5 1.6.4 FACILITATED DATA INPUT..........................................................................................6 1.6.5 DATA SECURITY AND INTEGRITY............................................................................6 1.6.6 TECHNICAL INNOVATION...........................................................................................6 1.6.7 FLEXIBILITY..................................................................................................................6 1.6.7.1Technology............................................................................................................................6 1.6.7.2Business Abundance.............................................................................................................7 1.6.7.3 Control.................................................................................................................................7 1.6.7.4EXTENSIBILITY.................................................................................................................7 1.6.9 SCALABILITY................................................................................................................7 7

1.7 Introduction to Tools Used:....................................................................................................7 Chapter 2..........................................................................................................................................8 LITERATURE REVIEW.................................................................................................................8 2.1 Microsoft SQL Server 2012................................................................................................10 2.2 ASP.NET Overview............................................................................................................10 2.2.1 ASP.NET includes:..........................................................................................................11 Chapter 3........................................................................................................................................13 REQUIREMENT ANALYSIS.......................................................................................................13 3.1 Software Requirement Specification (SRS).......................................................................13 3.2 Introduction.........................................................................................................................13 3.3 Purpose Solution.................................................................................................................14 3.3.1 Proposed Solution Overview..........................................................................................14 3.3.2 Modules of Proposed Solution........................................................................................14 3.3.2.1 istration................................................................................................................14 3.3.2.2 s................................................................................................................................14 . 3.3.2.3 File Marking...............................................................................................................15 3.3.2.4 Reports..........................................................................................................................15 3.3.2.5 Security...........................................................................................................................15 3.4 SPCIFICATION REQUIREMENTS..................................................................................15 3.4.1 Functional Requirements................................................................................................15 3.4.1.1 E-Document Generation....................................................................................................15 3.4.1.2 E-Document Management.................................................................................................16 3.4.1.3 E-Document Markup.........................................................................................................16 3.4.1.4 E-Document Report...........................................................................................................16 3.4.2 External Interface Requirements.....................................................................................16 3.4.2.1 Interface...................................................................................................................16 3.4.2.2 Hardware Interface..........................................................................................................17 3.4.3 Performance Requirements.............................................................................................17 3.4.3.1 Efficiency..........................................................................................................................17 3.4.3.2 Response Time.................................................................................................................17 3.5 GENERAL CONSTRAINTS.............................................................................................17 3.5.1 The Product.....................................................................................................................17 3.5.2 Hardware Constraints......................................................................................................17 3.5.2.1For Server:..........................................................................................................................17 3.5.2.2For client:............................................................................................................................17 3.5.3 Guidelines.......................................................................................................................18 3.6 Objective.............................................................................................................................18 3.7 USE CASE DESCRIPTION...............................................................................................19 3.7.1 Registration.....................................................................................................................19 3.7.2 ..................................................................................................................................20 3.7.3 ................................................................................................................................21 3.7.4 File Marking.......................................................................................................................22 3.7.5 File Creation.......................................................................................................................23 3.7.6 Security.................................................................................................................................24 3.7.7 Approval............................................................................................................................25 3.7.8 Review/Read file..................................................................................................................26 8

3.7.8 Delete File.............................................................................................................................27 3.7.9 Update file............................................................................................................................28 3.7.10 Change ................................................................................................................29 Chapter 4........................................................................................................................................30 SOFTWARE DESIGN...................................................................................................................30 4.1 USE CASE DIAGRAM.....................................................................................................30 4.2 Extended use case diagrams...............................................................................................32 4.2.1 .....................................................................................................................................32 4.2.2 ...................................................................................................................................32 4.2.3 Create File.............................................................................................................................33 4.2.4 Manage File..........................................................................................................................33 4.2.5 Mark File..............................................................................................................................34 4.2.6 ........................................................................................................................34 4.2.7 Security.................................................................................................................................35 4.3 CLASS DIAGRAM............................................................................................................36 4.4 ACTIVITY DIAGRAMS...................................................................................................37 4.4.1 ....................................................................................................................................37 4.4.2 File Manage..........................................................................................................................38 4.4.3 Mark File..............................................................................................................................39 4.4.4 ........................................................................................................................40 4.4.5 Update File............................................................................................................................41 4.4.6 Create File.............................................................................................................................42 4.4.7 Delete File.......................................................................................................................43 4.5 SEQUENCE DIAGRAM...................................................................................................44 4.5.1 ....................................................................................................................................44 4.5.2 Create File.............................................................................................................................45 4.5.3 Delete File.............................................................................................................................46 4.5.4 Create ...........................................................................................................................47 4.5.5 Mark File............................................................................................................................48 4.5.6 ...................................................................................................................................49 4.6 COLLEBORATION DIAGRAM............................................................................................50 4.6.1 .....................................................................................................................................50 4.6.2 Create File.............................................................................................................................50 4.6.3 Delete File.............................................................................................................................51 4.6.4 Create ...........................................................................................................................51 4.6.5 Mark File..............................................................................................................................52 4.7 Deployment Diagram...............................................................................................................53 4.8 ERD.........................................................................................................................................54 4.9 Data Dictionary...................................................................................................................55 Chapter5.........................................................................................................................................65 PROJECT MANAGEMENT.........................................................................................................65 5.1 Milestones........................................................................................................................65 5.2 Project Closeout Report...................................................................................................65 5.2.1 Project Deliverables........................................................................................................65 5.2.2 Operations and Maintenance...........................................................................................66 5.3.3Project Resources.............................................................................................................67 9

5.3 Risk Management....................................................................................................................67 5.3.1 Introduction...........................................................................................................................67 5.3.2 Purpose..............................................................................................................................68 5.3.3 Analysis Of Risk...........................................................................................................69 5.3.4 Response Of Risk.............................................................................................................69 Chapter 6........................................................................................................................................70 IMPLEMENTATION....................................................................................................................70 6.1 Visual C# .NET...................................................................................................................70 6.1.1 Developer productivity......................................................................................................70 6.1.2 Improved Performance......................................................................................................71 6.1.3 Improve Reliability.......................................................................................................71 6.1.4 System Requirement for visual studio.Net........................................................................71 6.2 Window 8:................................................................................................................................72 6.3 Microsoft SQL Server 2012.....................................................................................................73 6.3.1 Features..........................................................................................................................73 6.3.2 System Requirements for MS SQL 2012...........................................................................74 Chapter 7........................................................................................................................................75 SOFTWARE TESTING.................................................................................................................75 7.1 Deriving Test-Case Specification.......................................................................................75 7.2 State Test Environment..........................................................................................................75 7.3 Testing Identification..........................................................................................................76 7.3.1 ...............................................................................................................................77 7.3.2 File Marking.........................................................................................................................77 7.3.3 File Management..................................................................................................................77 7.3.4 Security.................................................................................................................................77 7.3.5 Approval...............................................................................................................................77 7.3.6 Registration..................................................................................................................77 7.3.7 Reports..................................................................................................................................77 7.4 Test Procedures...................................................................................................................77 7.5 Unit Testing.........................................................................................................................78 7.6 Integration Testing..............................................................................................................78 7.7 System Testing....................................................................................................................79 7.8 Test Schedules..........................................................................................................................80 7.8.1 Objectives.............................................................................................................................80 7.8.2 Software Test Environment...............................................................................................80 7.8.3 Test Identification............................................................................................................80 7.8.4 Test Schedules.............................................................................................................80 7.8.5 Requirement Traceability......................................................................................................82 7.8.6 Test Cases........................................................................................................................83 Chapter 8........................................................................................................................................90 CONCLUSIONS & FUTURE WORK..........................................................................................90 8.1 ACHIEVEMENTS.............................................................................................................90 8.2 LIMITATIONS...................................................................................................................91

10

11