DESIGN AND IMPLEMENTATION AN ONLINE INFORMATION DATABASE SYSTEM CASE STUDY OF NATIONAL ARCHIVES ENUGU

ABSTRACT

As the number of documents in an online information database system grows, it becomes increasingly difficult to store, manage the large amount of documents and finding requested relevant documents by users. An online information database system (OIDS) is used for this purpose. OIDS is a general tool for building and managing Referencing system of all kinds of documents to meet user needs. It implements system management and query processing in parallel. The functions of OIDS include data collection, format standardization, information extraction, automatic classification, data loading, data maintenance, query processing, external data entering, personalized recommendation etc. This study introduces the design and implementation of an online information database system, OIDS.

ORGANIZATION OF WORK

            This project work is primarily designed to give an insight to an online information database system for national archives.

            Chapter one talks about introduction to an online information database system, study of problem and objectives as well as definition of the scope.

            Chapter two comprises the literature review. Chapter three gives the detailed information about the existing (old) system, while chapter four and five deals with the design and implantation of new system.

            Chapter six document the project work, while chapter seven summaries,  conclusion and suggestions were made.

TABLE OF CONTENT

Title page                                                                                                       i          

Certification                                                                                                  ii

Approval                                                                                                       iii

Dedication                                                                                                     iv

Acknowledgement                                                                                       v

Abstract                                                                                                         vi

Organization of work                                                                                  vii

Table of content                                                                                           viii

CHAPTER ONE

1.0       Introduction                                                                                                  1

1.1       Statement of problem                                                                                  2

1.2       Aims and objectives                                                                                    2

1.3       Purpose of study                                                                                          3

1.4       Significant of study                                                                                     3

1.5       Scope/Delimitations                                                                             4

1.6       Limitations/Constraints                                                                              4

1.7       Assumption of study                                                                                   5

1.8       Definition of terms                                                                   5                     

CHAPTER TWO

2.0       Literature review                                                                                          6

CHAPTER THREE

3.0       Description and analysis of the existing system                                     9

3.1       Fact-finding method/ methodology                                                           9

3.2       Organisational Structure/Organogram                                                      10

3.3       Objectives of the existing system                                                             10

3.4       Input, Process, and Output Analysis                                                         11

            3.4.1   Input Analysis                                                                                  11

            3.4.2   Process Analysis                                                                              11

            3,4.3   Output Analysis                                                                               11

3.5       Information Flow diagram                                                                          12

3.6       Problems of the existing system                                                                12

3.7       Justification of the new system                                                                 13

CHAPTER FOUR

4.0       Design of the new system                                                                           14

4.1       Design Standard                                                                                           14

4.2       Output specification and design                                                                14

4.3       Input specification and design                                                                   14

4.3.1   file design                                                                                          15

4.4       Procedure chart                                                                                            16

4.5       Systems flowchart                                                                                        17

4.6       System requirements                                                                                   18

            4.6.1   Hardware Requirements                                                                 18

            4.6.2   Software Requirements                                                                   18

            4.6.3   Operational Requirements                                                              18

            4.6.4   Personnel Requirements                                                                 18

CHAPTER FIVE

5.0       Implementation                                                                                            19

5.1       Design Standard                                                                                           19

5.2       Program design                                                                                             20

5.2.1   Program Flowchart                                                                           20

5.2.2   Pseudo code                                                                                      24

5.3       Coding                                                                                                           25

5.4       Test Data/Test Run                                                                                      31

5.5       User Training – An overview                                                                     31

5.6       Cutover Process                                                                                           31

CHAPTER SIX

6.0       Documentation                                                                                             32

6.1       The user documentation                                                                             32

6.2       The programmer documentation                                                               32

CHAPTER SEVEN

7.0       Recommendations, Summary and Conclusion                      33

7.1       Recommendation                                                                                         33

7.2       Summary                                                                                                       34

7.3       Conclusion                                                                                                    34

REFERENCES                                                                                                          35

BIBLIOGRAPHY

APPENDIX                                  &nbs