Designing and Implementation of an Inventory Control System of a Supermarket, Using Oracle, Demo and Vb (Visual Basic) A Case Study of American Shop and Supermarket

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