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.