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

  • Type: Project
  • Department: Information Management Technology
  • Project ID: IMT0066
  • Access Fee: ₦5,000 ($14)
  • Pages: 98 Pages
  • Format: Microsoft Word
  • Views: 157
  • Report This work

For more Info, call us on
+234 8130 686 500
or
+234 8093 423 853

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


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
For more Info, call us on
+234 8130 686 500
or
+234 8093 423 853

Share This
Payment Instruction
Bank payment for Nigerians, Make a payment of ₦ 5,000 to

Bank GTBANK
gtbank
Account Name Obiaks Business Venture
Account Number 0211074565

Bitcoin: Make a payment of 0.0005 to

Bitcoin(Btc)

btc wallet
Copy to clipboard Copy text

500
Leave a comment...

    Details

    Type Project
    Department Information Management Technology
    Project ID IMT0066
    Fee ₦5,000 ($14)
    No of Pages 98 Pages
    Format Microsoft Word

    Related Works

    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... Continue Reading
    TABLE OF CONTENTS DECLARATION APPROVAL DEDICATION ACKNOWLEGMENT iv TABLE OF CONTENTS LIST OF ABBREVIATIONS AND ACRONYMS ix ABSTRACT CHAPTER INTRODUCTION I 1.0 Introduction 1 1.1 Background ofthe study 2 1.2 Scope of the study 2 1.3 Objectives ofthe project 2 1.4 Statement of the problem 3 1.5 Research questions 4 1.6 Significance ofthe project 4 1... Continue Reading
    ABSTRACT This project was aimed at designing a Video Library Management Information System; a system to aid in the management and operation of the video library. Methods that were used to gather information about the current system include; interviews, document review and questionnaires. From that information, requirements for the new system were... Continue Reading
    CHAPTER ONE INTRODUCTION 1.0 Introduction This chapter presents the introduction to the research study under the following headings: -          Theoretical Background -          Statement of the problem -          Aim and objectives of the study -          Significance of the study -          Scope of the... Continue Reading
    CHAPTER ONE INTRODUCTION 1.0 Introduction This chapter presents the introduction to the research study under the following headings: -          Theoretical Background -          Statement of the problem -          Aim and objectives of the study -          Significance of the study -          Scope of the... Continue Reading
    ABSTRACT Every year, new technology is found in which computers is one of them, computers take part in solution of business problems, initially, they were seen as capable of performing calculation, which would be impossible, which came the commercial break through were faster method of input, and output are more developed and it was realized that... Continue Reading
    ABSTRACT Every year, new technology is found in which computers is one of them, computers take part in solution of business problems, initially, they were seen as capable of performing calculation, which would be impossible, which came the commercial break through were faster method of input, and output are more developed and it was realized that... Continue Reading
    ABSTRACT Every year, new technology is found in which computers is one of them, computers take part in solution of business problems, initially, they were seen as capable of performing calculation,... Continue Reading
    Data management systems have a great impact on the day to day activities of most  organizations. They among others provide data accessibility, integrity, and security of  information. Today, the trend of most organizations has shifted from traditional way of storing data to  a modern and organized way. Because of this, Kiryandongo hospital... Continue Reading
    TABLE OF CONTENTS DECLARATION APPROVAL DEDICATION ACKNOWLEDGEMENT iv CHAPTER ONE 1.0 INTRODUCTION ............ .——..~ 1 1.1 Back ground ofthe Study I 1.2 Statement ofthe Problem 2 1.3 Objectives of the study 2 1.3.1 General objective 2 1.3.2 Specific objective of the study 2 1.4 Scope of the Study 3 1.5 Significance of the Study 3 CHAPTER TWO... Continue Reading
    Call Us
    Get this work
    whatsappWhatsApp Us