Computerized Asset Management System

TITLE PAGE

COMPUTERIZED ASSET MANAGEMENT SYSTEM

(A Generic Case Study)

BY

DEPARTMENT OF COMPUTER SCIENCE

IN PARTIAL FULFILLMENT OF THE REQUIREMENT FOR THE AWARD OF NATIONAL DIPLOMA IN COMPUTER SCIENCE

AUGUST 2008

CERTIFICATION

This is to certify that this project being an original work was undertaken by

-------------------------------------------------------------------

Project SupervisorDate

--------------------------------------------------------------------

Director of StudiesDate

DEDICATION

This project work is dedicated to the God Almighty; the giver of life, strength, wisdom and every good gifts who has seen us through the challenges of making this work a reality.

.

AKNOWLEDGEMENT

There are many individuals who contributed to the production of this project work through their moral and technical support, advice or participation.

Finally, we would like to thank our families and friends for their understanding, encouragement, and support over the completion and fulfillment of our project work.

ABSTRACT

The record keeping routines, information tracking, complicated logistics and many other administrative procedures are all regular activities that constantly make up the core processes in the management of real and financial assets. However these processes could be quite cumbersome and inefficient when manual systems being used continue to play prominent roles in organizations that offer such services.

Basically, with the advent of Information Technology (IT), some organizations, government agencies, individuals etc. have employed various database management software including relational database and spreadsheet software for the management of assets. However, these application software are generic; hence there is need to design a system that is tailored to specific need of asset management.

Consequently, this project work finds it necessary to study and analyze the difficulties inherent in the administration and management of asset manually in organizations with a view to proposing an extensive solution to these problems.

TABLE OF CONTENTS

CONTENTSPages

TITLE PAGE-------i

CERTIFICATION------ii

DEDICATION------iii

ACKNOWLEDGEMENT-----iv

ABSTRACT-------v

TABLE OF CONTENTS-----VI

CHAPTER ONE

NTRODUCTION------1

DEFINITION OF TERMS-----2

PROBLEM STATEMENT-----3

OBJECTIVES OF THE STUDY----4

SCOPE OF PROJECT-----4

SIGNIFICANCE OF THE STUDY----5
LIMITATIONS & CONSTRAINTS OF THE ROJECT-6

CHAPTER TWO - LITERATURE REVIEW

ASSETS-------7

ASSET MANAGEMENT-----9

COMPUTERIZATION-----10

PROBLEMS INHERENT IN THE EXISTING SYSTEM-12

CHAPTER THREE - SYSTEM ANALYSIS AND DESIGN

SYSTEM ANALYSIS----13

SYSTEM DESIGN------14

SPECIFICATION REQUIREMENT---14

SYSTEM ARCHITECTURE----19

CHAPTER FOUR – IMPLEMENTATION

LANGUAGE OF IMPLEMENTATION---21

CODING-------22

SYSTEM REQUIREMENTS----22

THE INTERFACE OF THE NEW SYSTEM--24

UPDATE AND MAINTENANCE OF SYSTEM--25

CHAPTER FIVE – SUMMARY CONCLUSION AND RECOMENDATION

SUMMARY-------26
CONCLUSION------26
RECOMMENDATION-----27
APPENDIX 1 – PROGRAM CODE---28
APPENDIX 2 – PROGRAM FLOWCHART--32
APPENDIX 3 – GUIDELINES FOR DBASE DESIGN-33
APPENDIX 4 – DIAGRAM OF ASSET MAGT SYSTEM-34
APPENDIX 5SCREENSHOT OF INTERFACE--35
REFERENCES------38

CHAPTER ONE

INTRODUCTION

Asset intensive industries face the harsh realities of operating in highly competitive markets and dealing with high value facilities and equipment where each failure is disruptive and costly. At the same time, they must also adhere to stringent occupational safety, health and environmental regulations. Maintaining optimal availability reliability and...