COMPUTERIZED DOCUMENT MANAGEMENT SYSTEM

ABSTRACT

This research project focuses on the development of a computerized and web based Document Management System for the Department of Computer science, University of Port Harcourt. The topic was selected due to the handicaps of the existing system of document management in the department. This new system has been designed to eliminate the delay, loss, insecurity and immobility of the existing system. The methodology used in the analysis of the new system is Object Oriented Analysis and Design (OOAD). The new system was implemented using PHP server side scripting language for the front end and MySQL as the database management system for storing information obtained from the front end. The result is a web based application that can efficiently store documents, provide document security, retrieve documents when needed and can be accessed at anywhere and on any device supporting internet applications.

 

 

 

 

 

 

 

 

 

 

 

TABLE OF CONTENTS

Approval………………………………………………………………………….i

Dedication……………………………………………….……………………..ii

Acknowledgement………………………………………………………………iii

Abstract…..……………………………………………………………………..v

Table of Contents………………………………………………………………vi

CHAPTER ONE…………………………………………………………………1

INTRODUCTION………………………………………………………………1

• Background of Study………………..………………………………………1
• Statement of the Problem…………….…………………………………….2
• Aim and Objectives of the Study………….………………………………3
• Significance of the Study…………………………………………………..4
• Scope of the Study………..………………………………………………..6
• Definition of Terms…………………………………………………………6

CHAPTER TWO………………………………………………………………..8

LITERATURE REVIEW……………………………………………………….8

2.1  Trends in Information Technology………………………………………….8

2.2  Rich Internet Applications…………………………………………………9

2.3  Process of Working with Electronic Documents………………………..11

2.4  The Existing System of Document Management and       Processing……….12

2.4.1  Types of Document……………………………………………………12

2.4.2  Some Software Used for Document Processing………………………..14

2.5  Problems Associated with the Existing System………………………….18

2.6  The Proposed System………………………………………………………19

 

CHAPTER THREE……………………………………………………………20

ANALYSIS AND DESIGN……………………………………………………20

3.1  Analysis of the Existing System…………….……………………………20

3.1.1  Advantages of the Existing System……………………………………20

3.1.2  Disadvantages of the Existing System………………………….……..20

3.2  Analysis of the Proposed System…………….………………………….21

3.2.1  Advantages of the Proposed System…………………………………..22

3.3  Methodology…….………………………………………………………..22

3.3.1  Object Oriented Analysis and Design………………………………….23

3.3.2  Benefits of OOAD………..…………………………………………….23

3.3.3  OOAD Techniques….………………………………………………….24

3.4  Unified Modeling Language………..……………………………………24

3.4.1  Use-Case Modeling…….……………………………………………….24

3.4.1.1  Use-Case..………………………………….…………………………25

3.4.1.2  Actor..……………………………….………………………………..25

3.4.1.3  Communication Link…………….…………………………………..25

3.4.1.4  Use-Case Diagram for the Proposed System……………..…………26

3.4.2  Class Diagram…………………………………………………………..27

3.4.3  Activity Diagram…….…………………………………………………31

3.4.4  Flow Chart……………………………………………………………….32

3.4.5  Entity Relationship (ER) Diagram…………………….………………34

3.5  System Design Interface……….…………………………………………36

3.5.1  Input Specification……..………………………………………………36

3.5.2  Output Specification……………………………………………………38

3.6  Language Justification………………………………….…………………38

3.6.1  PHP Programming Language……………..……………………………38

 

CHAPTER  FOUR…………………………………………………………….40

IMPLEMENTATION AND RESULTS………………………………………..40

4.1  System Requirements……………………………………………………40

4.4.1  Hardware Requirements…………………….…………………………..40

4.4.2  Software Requirements………..………………………………………41

4.2  Installing The Application…………..…………………………………….42

4.2.1  Using Xampp……………………………………………………………44

4.3  Setting Up Mysql Database………………….……………………………44

4.4  Testing The Application………….………………………………………46

4.4.1 Home Page….……………………………………………………………47

4.4.2  Adding Documents………..…………………………………………….47

4.4.3  View Documents………………………………………………………..48

4.4.4  Retrieve Documents………………….………………………………….49

4.5  Running The Programme…………………………………………………50

4.6  Results………….…………………………………………………………50

4.6.1  Login……..……………………………………………………………..50

4.6.2  Add documents…………………………………………………………51

4.6.3  Authorisation…………….……………………………………………..51

4.6.4  Retrieve documents…………………………………………………….52

CHAPTER FIVE………………………………………………………………54

SUMMARY, CONCLUSION AND RECCOMMENDATION………………54

5.1  Summary……………….………………………………………………….54

5.2  Conclusion…..……………………………………………………………55

5.3  Reccommendations…………..…………………………………………..55

References…..…………………………………………………………………56

Appendix A..………………………………………………………………….58

Appendix B…………………………………………………………………….83

 

LIST OF FIGURES

Fig 2.1  Desktop, Web and Rich Internet Application……………….……….10

Fig 2.2  Stored Files…….………………………………………………………13

Fig 2.3  MS Word Used for Typing a Memo…………………………………..16

Fig 2.4  MS Word Used for Importing Images…………………………………17

Fig 2.5  Excel Spreadsheet Displaying Student Result………………….……18

Fig 3.1  Use-Case Symbols…….………………………………………………25

Fig 3.2  Use-Case Diagram for the Proposed System…………………………26

Fig 3.3  Class Diagram for the Proposed System……………………………..28

Fig 3.4  Activity Diagram for the Proposed System…………………..………31

Fig 3.5  Data Flow Diagram for the Proposed System………………………..33

Fig 3.6  ER Diagram for the Proposed System…………….………………….35

Fig 3.7  Login Table……………………………………………………………37

Fig 3.8  Create Document Table……………………………………………….37

Fig 3.9  Search Document Table………..…………………………………….38

Fig 4.1  Screen Shot of the Document Management Database ………………45

Fig 4.2  Doc-Document Table…………………………………………………45

Fig 4.3  Login Table…..………………………………………………………46

Fig 4.4  Home page after login…………..……………………………………47

Fig 4.5  Add Document Screen Shot…………………………………………..48

Fig 4.6  View Document……….………………………………………………49

Fig 4.7  Retrieve Document……….……………………………………………49

Fig 4.8  Login as Admin……………………………………………………….50

Fig 4.9  Adding a Document……………………………………………………51

Fig 4.10  Documents Waiting to be Reviewed…………………….………….52

Fig 4.11  Searching for a Document……………………..…………………….52

Fig 4.12  Searched Document Displayed…………..…………………………53

Fig 4.13  Retrieved Document in Excel Format……………………………….53

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CHAPTER ONE

INTRODUCTION

• Background of the study

Information management has become a major strategic factor in companies’ development. It is important to get the right information circulated to the right people, as efficiently as possible, yet still keep it secure. Document management provides a way for companies to organize their information, in all its forms, in one place. Streamlining business processes and increasing efficiency are fundamental concerns for any organisation regardless of size or sector. In today’s ever increasingly strict regulating environment, compliantly managing documents and records of all types takes significant time and money that could better be spent on achieving mission critical objectives. By implementing a document management system, organisations can realize many benefits that noticeably improve organisational efficiency.

Digital document management system can help an organisation succeed by; Saving time, Saving money, Increasing efficiency, Increasing productivity, Increasing inter-departmental and inter-organisational communication, and Enabling automation.

A Document Management System (DMS) is a system based on computer programs used to store and access documents.

Electronic document management solutions are designed to organize business files and records digitally, whether they started out in paper form or were generated by software applications.

Paper files are first converted to electronic format by scanning. This provides a more compact means of storage, universal access for retrieval, and higher levels of data security and privacy.

A company-wide document management system also controls digital files that are generated directly through applications — such as those in the Microsoft Office suite (Word, Excel and PowerPoint), accounting software, CAD, email, and so on. Managing (rather than simply storing) documents enables quicker access to, and greater command over, business information.

 

1.2  Statement of the Problem

It has become widely recognized that manual paper-based  processing has inherent problems that disadvantage companies in critical ways, undermining productivity and impeding the flow of information. Ignoring the problem is proving less and less an option in the current economic and competitive climate. Looking at the department of computer science, University of Port Harcourt as a case study, students submit hard copies of document as a means of making requests, Memos are sent to the department in paper form which degenerates to bulk of files in the offices. This system of storing documents is tedious, complicated and time consuming.

Faced with the need to organize documents, the proposed system for management of documents is unique and totally innovative in its integrated approach. Its functionality of making documents available anytime, anywhere and enabling easy access, retrieval and storage of documents makes it called for.

The system to be developed makes use of rich internet technology to replace desktop application with web application running on a remote server. The system shares the advantage of both web application and desktop application, and removes the most disadvantages of both.

 

1.3  Aim and Objectives of the Study

The aim of the project is to develop a document management system for the department of computer science, University of Port Harcourt that is able to deliver access to anyone authorized anytime, anyplace, and on any device.

The objectives of the study are to develop a system that should be able to;

1. Store documents properly
2. Archive and retrieve documents properly and efficiently
3. Ensure document security and availability.
   • Significance of the Study

The proposed system will offer the following advantages to the department of computer science, University of Port Harcourt;

1. Reduced Storage: The cost of commercial property and the need to store documentation for e.g. retrieval, regulatory compliance means that paper based document storage competes with people for space within an organisation. Scanning documents and integrating them into a document management system can greatly reduce the amount of prime storage space required by paper. It also allows any documents that still have to be stored as paper to be stored in less expensive locations.
2. Flexible Indexing: Indexing paper in more than one way can be done, but it is awkward, costly and time-consuming. Images of documents stored within a document management system can be indexed in several different ways simultaneously.
3. Improved, faster and more flexible search: Document Management Systems can retrieve files by any word or phrase in the document – known as full text search – a capability that is impossible with paper.
4. Controlled and Improved Document distribution: Imaging makes it easy to share documents electronically with colleagues and clients over a network, by email or via the Web in a controlled manner. Paper documents usually require photocopying to be shared. This provides a cost saving by reducing the overheads associated with paper based document distribution, such as printing and postage and removes the typical delay associated with providing hard copy information.
5. Improved Security: A document management system can provide better, more flexible control over sensitive documents. Many document management system solutions allow access to documents to be controlled at the folder and/or document level for different groups and individuals. Paper documents stored in a traditional filing cabinet or filing room does not have the same level of security i.e. if you have access to the cabinet you have access to all items in it. A document management system also provides an audit trail of who viewed an item, when or who modified an item and when, which is difficult to maintain with paper based systems.
6. Disaster Recovery: A document management system provides an easy way to back-up documents for offsite storage and disaster recovery providing failsafe archives and an effective disaster recovery strategy. Paper is a bulky and expensive way to back-up records and is vulnerable to fire, flood, vandalism and theft.
7. No Lost Files: Lost documents can be expensive and time-consuming to replace. Within a Document Management System, imaged documents remain centrally stored when being viewed, so none are lost or misplaced. New documents are less likely to be incorrectly filed and even if incorrectly stored can be quickly and easily found and moved via the full-text searching mechanisms.
8. Digital Archiving: Keeping archival versions of documents in a document management system helps protect paper documents that still have to be retained, from over-handling.

1.5   Scope of The Study

The main challenge of document management is flexible storage and retrieval. This study’s intended user is the department of computer science, University of Port Harcourt. The system will be provided with facilities for easy storage, retrieval and security of documents.

 

• Definition of Terms

Document: A document is a form of information. It could be electronic or in the form of paper.

Management System: A documented and step by step method aimed at smooth functioning through standard processes.

Retrieval: The process of accessing information from memory or other storage devices.

Web Application: An application program stored on a remote server and delivered over the internet through a browser interface.

Web browser: A software application used to locate, retrieve and display contents on a World Wide Web, including web pages, video and other files.

Server: A running instance of an application capable of accepting requests from the client and giving responses accordingly.

Database:  A computerized record-keeping system. It is a repository for storing information.

 

 

 

 

 

 

 

 

₦5,000.00 – DOWNLOAD FULL PROJECT DOWNLOAD FULL PROJECT Added to cart

---

---

---

---

---

Related Project Topics :