Design and Implementation of a Stock Control System Case Study: Ebenezer Supermarket Limited

Table of Contents

CHAPTER ONE: INTRODUCTION 1

1.0 INTRODUCTION 1

1.1 BACKGROUND 1

1.2 STATEMENT OF THE PROBLEM 1

1.3 MAIN OBJECTIVE 2

1.3.1 SPECIFIC OBJECTIVES 2

1.4 SCOPE 2

1.5 CONCEPTUAL MODEL 3

1.6 SIGNIFICANCE OF THE PROJECT 3

CHAPTER TWO: LITERATURE REVIEW 5

2.0 INTRODUCTION 5

2.1 STOCK CONTROL SYSTEMS 5

2.2 DATABASE SYSTEMS 5

2,2.1 ADVANTAGES OF DATABASE SYSTEMS 6

2.2.2DISADVANTAGES OF DATABASE SYSTEMS 6

2.3 INFORMATION SYSTEM 6

2.3.1 CHARACTERISTICS OF INFORMATION SYSTEMS 7

2.3.2 ADVANTAGES OF INFORMATION SYSTEM 7

2.4 REVIEW OF METHODOLOGIES 7

2.4.1 SYSTEM DEVELOPMENT LIFE CYCLE (SDLC) 8

2.4.2 PROTOTYPING 8

2.4.3 DESIGN TOOLS TO BE USED 8

CHAPTER THREE: METHODOLOGY 9

3.0 INTRODUCTION 9

3.1 RESEARCH PROCEDURE 9

3.2 TARGET POPULATION 9

3.2.1 SAMPLE POPULATION 9

3.3 DATA COLLECTION 10

3.4 FACT FINDING TECHNIQUES 10

3.4.1 OBSERVATION 10

3.2.2 QUESTIONNAIRES 11

3.2.3 ANALYSIS, DESIGN AND DEVELOPMENT OF THE PROTOTYPE 11

3.3 DEVELOPMENT METHODOLOGY AND TOOLS 12

V

3.3.1 TOOLS 1

3.4 INFORMATION SYSTEM PLAN 12

3.4.1 SYSTEM REQUEST 12

3.5 FEASIBILITY ANALYSIS 13

3.5.1 ECONOMIC FEASIBILITY 13

3.5.2 ORGANIZATION FEASIBILITY 14

3.6 PROJECT PLAN 14

3.8 RISK ASSESSMENT 16

3.9 PROBLEMS ENCOUNTERED DURING THE STUDY 16

CHAPTER FOUR: SYSTEM DESIGN 17

4.0 INTRODUCTION 17

4.1 LOGICAL DESIGN 17

4.2ENTITY RELATIONSHIP DIAGRAM 17

4.3FLOW CHART 19

4.4 PHYSICAL DESIGN 20

4.6 DATA INPUT 28

CHAPTER FIVE: SYSTEM IMPLEMENTATION 29

5.0 INTRODUCTION 29

5.1 PROGRAM TESTING 29

5.2 PROJECT IMPLEMENTATION 30

5.2.1 SYSTEM IMPLEMENTATION 30

5.3 USER INTERFACE 31

5.4 SYSTEM CONVERSION 36

CHAPTER SIX: EVALUATION, RECOMMENDATIONS AND CONCLUSION 37

6.0 INTRODUCTION 3

6.1 EVALUATION OF THE NEW SYSTEM 37

6.4 RECOMMENDATION 38

6.5 CONCLUSION 38

REFERENCES 40

APPENDIX A 41

APPENDIX B: OBSERVATION CHECKLIST 43

APPENDIX C: SOURCE CODE FOR THE PROGRAM 44