Online ordering and inventory system

DEDICATION

To my Brothers and Sisters,

To all my Family and Knowledge,

Relatives, Friends and classmates.

DECLARATION BY THE CANDIDATE

Jean Claude KANYESHYAMBA hereby declare that the project report entitled «OOIS of La GALETTE supermarket» submitted in partial fulfillment of the requirement for the award of the degree of Bachelor in Information Systems and Management is a record of bonafide project work carried out by myself under the guidance of my supervisor. I further declare that the work reported in this project has not been submitted, either in part or in full, for the award of any other degree or diploma in this institute or any other institute or university.

Kigali: Signature of the candidate

Date: Jean Claude KANYESHYAMBA

INDEPENDENT INSTITUTE OF LAY ADVENTIST OF KIGALI

(INILAK)

B.P. 6392 KIGALI, Tél: [phone]

E-mail: [e-mail]

Website: www.inilak.ac.rw

BONAFIDE CERTIFICATE

This is to certify that the project report entitled «ONLINE ORDERING AND INVENTORY SYSTEM OF LA GALETTE SUPERMARKET» submitted by Jean Claude KANYESHYAMBA (9867/08) to Independent Institute of Lay Adventists of Kigali in partial fulfillment of the requirement for the award of the degree of Bachelor in information systems and management is a record of

bonafide work carried out by him under my guidance.

Signature of the Supervisor Signature of the Department Head

TURIHO Jean Claude MSc ZIRARUSHYA Pierre Célestin

Academic year 2011

Date:................... Date:.................

Accredited by the Ministerial Order No 002/09 0f 09/04/2009 granting the Definitive Operating Licence

ACKNOWLEDGEMENTS

First and foremost, We are most grateful and also extend our lovely appreciation to the Mighty fortress is our God, a bulwark never failing for his mercies endures forever, and by whom this work has been made possible.

Sincere thanks goes to my supervisor Mr. Jean Claude TURIHO, for his support throughout my entire research. His continuous suggestions, critics, adherence and guidance made this project a success.

I am grateful to all information system management lecturers in the department of economics sciences for their efforts in availing the required knowledge for entire duration of my course, and families we are going to refer below. This work couldn't have been accomplished without their willing moral, financial and technical support.

I acknowledge the support of La GALETTE supermarket for their information data which helped in performance of this work.

I am also highly indebted to my friends for their support and the sharing of everything developmental throughout my studies, may you achieve for anything you struggle for.

Finally I thank who ever, in one way or another contributed to the success of my project. God Bless you all.

TABLE OF CONTENTS

DEDICATION i

DECLARATION BY THE CANDIDATE ii

BONAFIDE CERTIFICATE iii

ACKNOWLEDGEMENTS iv

TABLE OF CONTENTS v

LIST OF TABLES ix

LIST OF FIGURES xi

ABSTRACT xii

LIST OF ABREVIATION xiii

CHAPTER 1: GENERAL INTRODUCTION 1

1.1 Introduction 1

1.2 Statement of the problem 1

1.3 Interest of the study 2

1.3.1 Personal interest 2

1.3.2 Institutional interests 2

1.4 Objective of the study 2

1.4.1 General Objective 2

1.4.2 Specific objectives 2

1.5 Motivation 3

1.6 Challenges 3

1.7 Methodology approach 3

1.8 Scope of the project 3

1.9 Significance of the study 3

1.10 Expected results 4

1.11 Organization of the project 4

CHAPTER II: LITERATURE REVIEW 5

2.1 introduction 5

2.2 specific terminologies 5

2.2.1 Online 5

2.2.2 Supermarket 5

2.2.3 Customer 5

2.2.4 Product 5

2.2.5 Order 6

2.2.6 Invoice 6

2.2.7 Store 6

2.2.8 Payment 6

2.2.9 Registration 7

2.2.10 Administrator 7

2.2.11 Normal selling 7

2.2.12 Super-Selling 7

2.3 Comparative study 7

2.3.1 Online auction for vision finance company 7

2.3.1.1 Strengths 8

2.3.1.2 Weaknesses 9

2.4 Personal contribution 10

CHAPTER III: THE ANALYSIS OF EXISTING SYSTEM 11

3.1 Introduction 11

3.2 Company description 11

3.2.1 History of La GALETTE supermarket 11

3.2.2 Structure of La GALETTE supermarket 12

3.3 Mission and vision 12

3.3.1 Vision 12

3.3.2 Mission 12

3.4 Process of existing system 12

3.4.1 Recording of product 12

3.4.2 Customer collecting product 13

3.4.3 Order process 13

3.4.4 Delivery process 14

3.4.5 Payment process 14

3.5 limitations and weakness of the system in use 15

3.6 Proposed solutions to the problems 15

CHAPITER IV: ANALYSIS AND DESIGN OF THE PROPOSED SYSTEM 16

4.1 Introduction 16

4.2 Requirement specifications 16

4.2.1 Functional Requirements 16

4.2.2 Non- functional requirements 16

4.3 User Requirements Specifications 16

4.4 System Analysis 16

4.5 System design 17

4.5.1 Design and development of the system 17

4.5.2 Functional Diagram 17

4.5.3 Data Flow Diagram 18

4.5.4 Context diagram 19

4.5.4.1 DFD level 0 for whole OOIS 21

4.5.4.2 DFD level 1 for manage product 21

4.5.4.3 DFD level1 for manage customers 22

4.6 Ways of recording information 22

4.6.1 Entity Relationship Diagram 22

4.6.2 Designing the ERD 23

4.6.3 Entity Relationship Diagram 24

4.7 Conceptual Model of Data 25

4.8 Logical Data Model 26

4.9 The Conceptual Level 27

4.9.1 The Treatment Conceptual Model 27

4.9.2 Treatment Conceptual Model for Ordering Product 28

4.9.3 Treatment Conceptual Model for Invoice 29

4.9.4 Treatment Conceptual Model for Delivering 30

4.10 Data Dictionary 30

4.11 Organizational Model of Process 33

4.12 Physical Data Model 36

4.13 Advantage of the new system 37

CHAPTER V: IMPLEMENTATION OF THE SYSTEM 38

5.1 Implementation overview 38

5.2 Description of tools used 38

5.2.1 Xampp 38

5.2.2 HTML 38

5.2.3 Macromedia Dreamweaver 38

5.2.4 My SQL 38

5.2.5 Apache 39

5.2.6 Php MyAdmin 39

5.3 Client-server Interaction 40

5.3.1 Characteristics of Clients and Servers 40

5.3.2 The client Server Architecture 41

5.3.3 Some common Internet protocols 41

5.4 Software testing 42

5.4.1Introduction 42

5.4.2 Unit testing 42

5.4.3 Integration testing 43

5.4.4 Validation testing 43

5.4.5 Black Box testing 43

5.5 Some User Interface Screenshots 44

5.5.1 Home page screenshot 44

5.5.2 Product category view screen 45

5.5.3 Customer shopping invoice 46

5.5.4 Customer login form for ordering 47

5.5.5 Authorized user login interface 48

5.5.6 Customer information interface 49

5.5.7 Customer suggestion interface 50

CHAPTER VI: CONCLUSION AND RECOMMENDATION 51

6.1 CONCLUSION 51

6.2 RECOMMENDATIONS 52

REFERENCES 53

Appendices 54