Design and Implementation of an Inventory System V for A Supermarket Case Study: Uchuzi Supermarket

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 .7Conceptual models 4

CHAPTER TWO 7

LITERATURE REVIEW.~ 7

2.0 Introduction 7

2.1 Management infonnation system 8

2.1.Ilnformation 8

2.1.2 System 9

2.1.3 System Element 9

2.2 Information systems 11

2.3 Information system reference 11

2.4. Databases 13

An inventory system for Uchuzi supermarket by haroun A and Sa,nba A v

2.5 Database management system 13

2.6 The effects ofthe database and dbms 15

2.7 Database maintenance 15

2.7.1 Advantages ofDatabase And DBMS 16

2.7.2 Disadvantages ofUsing Database and DBMS 17

CHAPTER THREE 19

RESEARCH METHODOLOGy, 19

3.0 Introduction 19

3.lFesibility study 19

3.2 Target population 19

3.3 Sample selection 19

3.4 Research procedures 20

3.5 Data collections methods 20

3.5.1 Interviews 20

3.5.2 Questionnaires 20

3.5.3 Document analysis 21

3.6 Research findings 22

3.7 Limitation ofthe study 22

CHAPTER FOUR 24

SYSTEM ANALYSIS DESIGN AND IMPLEMENTATION, ,,,, 24

4.0 Introduction 24

4.1 System Analyst 24

4.1 .IResults from the interviev 27

4.1 .2Result from the Questionaire 27

4.2Data and documentation flow 26

4.3 System software development (The system development life cycle) 25

4.3.lFigure System Software development 27

4.3.1 .1 Requirement analysis and definition 27

4.3.. 1.2Hardware and Software development 26

An inventory system for Uchuzi supermarket by haroan A and Samba A vi

4.3.1.3 User and Security Requirement 27

4.3.2.4 System and Sofiware design 27

4.3.2.5 Physical System Design 28

4.2 Context of the Diagram 28

4.3.3 Entity Relation Diagram 35

4.3.4 Implementation coding and Testing 35

4.3.5 Intergration and System testing 35

4.3.6 Operation Mainteinance 35

4.3.7 System Specification 35

4.4 Analysis 35

4.5 Final testing 35

4,6 Dafa Flow Diagram 36

4.7,Tables 36

4.8 Sample Codes 40

4.9 Login and Staff form 35

CHAPTER FIVE

DISCUSSION, RECOMMENDATION AND CONCLUSION 43

5.0 Introduction 43

5.1 Discussion

5.2 Recommendation