TABLE OF CONTENTS
DECLARATION.ii
APPROVAL iii
DEDICATION iv
ACKNOWLEDGEMENT v
TABLE OF CONTENTS vi
ABSTRACT
CHAPTER ONE 1
INTRODUCTION 1
1.1 Background 1
1.2 Problem Statement 3
1.3 Objectives 3
1.3.1 General Objective 3
1.3.2 Specific Objectives 3
1.3 Research Questions 4
1.4 Scope of the Study 4
1.5 Significance 4
CHAPTER TWO 5
LITERATURE REVIEW 5
2.0 Introduction 5
2.1 Reasons for Forming Supply Chain Management 5
2.2 Definition 6
2.3 Key Management Processes in the Supply Chain 6
2.4 Inventory Management 7
2.5 Roles of Inventory 8
2.6 Inventory Management in the Supply Chain 9
3.0 Database Management Systems (DBMS) 10
3.1 Database 10
3.2 Database Models 11
3.3 Relational Database Management System (RDBMS) 11
CHAPTER THREE 12
METHODOLOGY 12
3.0 Introduction 12
3.1 Sample 12
3.1.1 Sample selection 12
3.2 System Study and Investigation 12
3.3 Literature Review 13
3.4 Questionnaires 13
3.5 Interviews 13
vi
3.6 Observation.13
3.7 System Analysis and Design 13
3.7.1 Data Flow Diagram for Sales and Inventory System 14
3.8 Consultations 14
CHAPTER FOUR 15
SYSTEM ANALYSIS AND DESIGN 15
4.0 Introduction 15
4.1 Requirements Elicitation and Analysis 15
4.2 Requirements specification 15
4.2.1 User requirements 15
4.2.1.1 Functional requirements 15
4.2.1.2 Non-Functional Requirements 16
4.2.2 System Requirements 16
4.2.2.1 Hardware Requirements 17
4.2.2.2 Software requirements 17
4.3 System design 17
4.3.1 Context models 18
4.3.2 Weaknesses of the existing system 18
4.3.3 Proposed System Modeling 19
4.3.4 Processes and si.ib-processes involved in the System 19
4.3.5 Entities involved in the system 20
4.3.6 Data Flow Diagram for the System 21
4.4 Database Design 22
4.4.1 Conceptual Design 22
4.4.1 .1 Definition of entities 22
4.4.2 Entities and their attributes 22
4.4.3.1 Entity Relationship Diagram 24
4.5 Physical Design 26
4.5.1 Description of relations (Data dictionary) 27
CHAPTER FIVE 29
SYSTEM IMPLEMENTATION 29
5.0 Introduction 29
5.1 Forms 29
5.1.1 Login Form 29
5.1.2 The Menu Form 30
5.1.3 Sales details Form 31
5.2 Database tables 32
5.2.1 Category database table 32
5.2.2 Supplier database table 32
5.3 Reports 33
5.3.1 Product’s details report 33
vii
ABSTRACT
This study focused at An Authenticated Inventory Management System for SOSUMO Sugar
Industry in Bujumbura Central Market (Burundi) which will handle effectively and
efficiently the management of inventory information. The system was able to address the
following problems; many inventory management systems are operated manually by group of
people. In such situations many people involved in the process of managing the industry such
a way that to keep records regarding the books of accounts (borrowers), check the books
manually, keep records on issued books etc. all these have to be carried out manually and manual record
keeping was also not a reliable method as people tend to forget things. On the borrower’s point ofview,
in manual system borrower can’t find a book exactly at once as they are not ordered well. The
researchers used the following techniques and approaches in order to achieve the objectives
of the study. It covers the requirements elicitation process, system analysis and design,
implementation, testing and validation. The system design used two-tier client server
architecture whereby the database was implemented using MS.Acccess whereas the interface
was implemented using VB 6.0. The significance of the study is to make the Inventory
Management, Process and Storage much simpler. And also improve on the speed with which
the inventory processes is done.