ABSTRACT An Inventory Control System defines a series of processes and actions involved in capturing raw data, processing data into useable information and disseminating information to use in the needed form. The system is a general purpose set of instruction that facilitates the process of defining, construction, controlling and manipulation of databases for various applications; this Inventory Control System describes the database as a collection of data, typically describing the activities of one or more related origination; the report covers the fundamentals of the an Inventory Control System utilizing relational database systems in coupled to Visual Basic and Demo programming. The report concentrates a lot on issues central to designing, tuning and implementation of an Inventory.
TABLE OF CONTENT
DECLARATION II
APPROVAL III
DEDICATION IV
ACKNOWLEDGMENT V
LIST OF FIGURES VI
ABBREVIATIONS VII
ABSTRACT VIII
TABLE OF CONTENT
CHAPTER ONE 4
INTRODUCTION 4
1.0 Introduction 4
1.1 Background 4
1.2 The Scope of the Study 5
1.3 Objectives 6
1.3.1 Main objectives 6
1.3.2 Specific Objective 6
1.4 Statement of the Problem 6
1.5 Research Questions 7
1.6 Research Methodology 7
1.6.1 Target Population 7
1.6.2 Sample selection 7
1.6.3 Research procedure 8
1.6.4 Data collection 8
1.6.5 Data collection tools 9
1.7 Significance of the project 9
1.8 Limitation of the study 9
1.9 Conclusion 10
CHAPTER TWO 11
LITERATURE REVIEW 11
2.0 Introduction 11
2.1 The importance of an Inventory Control System 11
2.2 Information Technology 12
2.3 The concept of a System Development Life Cycle (SDLC) 13
2.4 Prototyping 14
2.5 Data as a Corporate Asset 14
2.6 The concept of database system environment 15
2.7 Previous studies 15
2.7,1 DBMS 15
2.7.2 The advantages of DBMS are as follows 16
2.7.3 Disadvantages of DBMSs 16
2.8 Structured Query Language (SQL) 17
2.8.1 It has the following advantages 17
2.8.2 Disadvantages 17
2.9 Database Security 17
1
2.9.lCountermeasures — computer-based controls .17
2.9.2 Redundant array of independent disks (RAID) 19
2.10 Visual Basic 19
2.11 BARCODE 20
2.11.1 Benefits of using barcodes 20
2.12 Barcode Reader 21
2.12.1 Description of a barcode reader 21
2.12.2 Methods 21
2.12.1 2D Imaging scanners 23
2.13 Conclusion 23
CHAPTER THREE 24
METHODOLOGY 24
3.0 Introduction 24
3.1 Research Methodology 24
3.2 Fact Finding 24
3.3 Targeted Population 25
3.4 Sample selection 25
3.5 Research procedure 25
3.6 Data collection 26
3.7 Data collection tools 26
3.8 Questionnaire 27
3.8.1 Advantages of questionnaire 27
3.8.2 Disadvantages of questionnaires 27
3.9 Interviewing 27
3.9.1 Advantages of Interview 27
3.9.2 Disadvantages of Interviews: 28
3.10 Observation 28
3.11 Reading 28
3.13 Kind of information to be stored 29
3.14 Development Methodology and Tools 29
3.14.1 Tools 30
3.15 Information System Plan 30
3.15.1 System Request 30
3.15.2 Name of the project 30
33.15.3 Name of the organization 30
3.15.4 Business needs of the organization 30
3.15.5 Expected functionality of the system 31
3.15.6 Expected value of the system 31
3.16 Feasibility Analysis 31
3.16.1 Economic feasibility 31
3,16.2 Intangible benefits 32
3.16.3 Organization feasibility 32
3.17 Risk assessment 32
3.18 Conclusion 33
CHAPTER FOUR 34
REPRESENTATION OF THE FINDINGS AND SYSTEM DESIGN 34
2
4.0 Introduction .34
4.1 System design 34
4.2 The new computerized system 35
4.3 Stages of database design 35
4.3.1 Logical design 35
4.3.1.1 Entity Relationship Diagram 35
4.3.1.2 Basic concepts about entity relationship model (E-R model) 35
4.3.2 Physical Design 41
CHAPTER FIVE 48
SYSTEM IMPLEMENTATION 48
5.1 Introduction 48
5.2 Program Testing 48
5.3 Project implementation 48
5.3.1 System implementation 49
5.3.2 User training 49
5.4 User Interface 49
Sample reports from different tables 60
5.5 System Conversion 63
CHAPTER SIX 64
EVALUATION, RECOMMENDATIONS AND CONCLUSION 64
6,1 Introduction 64
6.2 Evaluation of the new system 64
6.3 Recommendation 65
6.4 Conclusion 65
REFERENCES 67
Books 67
APPENDICES 68
APPENDIX A 68
A sample questionnaire 68
APPENDIX B 72
Sample codes 72
Source code for the MDI form 72
Source code for the Administrator form 75
Source code for the Staff form 76
Source code for the Customer form 79
Source code for the Items form 83
APPENDIX C 89
Definition of some terms 89