Developing A Stock Management System for a Supermarket

TABLE OF CONTENTS

DECLARATION .................................................................................................................. i

APPROVAL ....................................................................................................................... ii

DEDICATION ................................................................................................................... iii

ACKNOWLEDGEMENT ................................................................................................. .iv

CHAPTER ONE

1.0 INTRODUCTION ....................................................................................................... 1

1.1 Back ground of the Study .............................................................................................. !

1.2 Statement of the 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

LITERATURE REVIEW

2.0 INTRODUCTION ....................................................................................................... 4

2.1 Management Information System ................................................................................. 4

2.2 Information Technology ................................................................................................ 4

2.3 Information system ........................................................................................................ 5

2.3.1 The roles of information system ............................................................................. 6

2.3.2 Components of information systems ...................................................................... 7

2.4 Database and all its aspects ........................................................................................... 8

2.4.1 Advantages of databases ......................................................................................... 9

2.4 .2 Database Maintenance ......................................................................................... 11

2.5 Application architecture and development process ..................................................... 11

2.6 Database management information system ................................................................. 12

2.6.1 Merits of Database management system ............................................................. 12

2.6.2 Limitations ofDatabase management system ...................................................... 13

2.7 Description of the system ............................................................................................ 15

2.8 Developing Management Information System ............................................................ 16

v

2.9 Review ofSupermarkets .............................................................................................. 17

2.10 Systems Currently Serving Supermarkets ................................................................. 18

2.11 Strength of manual filling systems ............................................................................ 19

2.11.1 Weaknesses of Manual Filling Systems ............................................................. 19

CHAPTER THREE

METHODOLOGY

3. 0. Introduction ................................................................................................................ 22

3 .1. System Development Life Cycle (SDLC) description; .............................................. 22

3.2. Data collection instruments ........................................................................................ 22

CHAPTER FOUR

SYSTEMANALYSISDESIGN,IMPLEMENTATION ANDEVALUTION

4.0. Introduction ................................................................................................................ 28

4.1. Logical Design ............................................................................................................ 30

4.2. Detailed design ........................................................................................................... 45

4.3. Output requirements ................................................................................................... 45

4.4. Hard copy ................................................................................................................... 45

4.5. Softcopy ...................................................................................................................... 45

4.6. Input Requirements ..................................................................................................... 46

4.7. Processing Requirements ............................................................................................ 46

4.8. Operating system ........................................................................................................ 46

4.9 Database Management Information System .............................................................. .46

4.10. Anti- Virus software .............................................................................................. .47

4.11. Docurnentation .......................................................................................................... 47

4.12. Hardware acquisition ................................................................................................ 48

4.13. Software requirement ............................................................................................... 48

4.14. Software testing ........................................................................................................ 48

4.15. Unit testing ............................................................................................................... 48

4.16. System testing ........................................................................................................... 49

4.17. System implementation ............................................................................................ 49

4.18. System Maintenance ................................................................................................. 50

4.19. Security implementation ........................................................................................... 50

4.21. System Evaluation .................................................................................................... 51

4.22. System Validation ..................................................................................................... 51

4.23. System maintenance and Operations ...................................................................... 52

vi

CHAPTER FIVE

DISCUSSIONS, CONCLUSIONS AND RECOMMENDATIONS

5.0.INTRODUCTION ...................................................................................................... 53

5.1. Discussions ................................................................................................................. 53

5.2. Conclusions ................................................................................................................ 54

5.3. Recommendations ...................................................................................................... 54