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
ABSTRACT This project is about how to effectively use the inventory system in a supermarket. It was carried out to find how customers can access items in the supermarket without any difficulties. Among many problems associated with the time, lack of training to the employees, lack of enough facilities like computers that can respond to different queries and inbuilt software’s to support to the DB to and cost and the possible guidelines that can be provided to improve management ofthe supermarket. This survey research design will be adopted by uchuzi supermarket to modernize the method of how data of day to day sales and to produce weekly reports for the manager, If well used this method will bring about fabulous outcome. However, flexible approach may also be used altogether questionnaires, interviews and observations will be the tool for data collection. Data will be presented using both qualitative and quantitative research techniques. Afterwards conclusion will be put forward for further researchers on the topic and for the policy reviewers. So that the supermarket can be managed better and their records being proceeds in a standard way that will reduce if not eliminating all the mentioned problems and this will make the work easy whereby customers will be able to get any item they want and goes to the counter for payment then a receipt will be given.