Online ordering and inventory system

LIST OF TABLES

Table 1: Cardinality 26

Table 2: Data dictionary 31

Table 3: Organizational Modal of Process 35

LIST OF FIGURES

Figure 1: Function Diagram 18

Figure 2: Context Diagram 20

Figure 3: DFD level 0 for whole OOIS 21

Figure 4: DFD level 1 for manage product 21

Figure 5: DFD level1 for manage customers 22

Figure 6: Entity Relationship Diagram 24

Figure 7: TMC ordering product 28

Figure 8: TMC invoice 29

Figure 9: TMC of delivering 30

Figure 10: Physical data Model 36

Figure 11: A client and a server 41

Figure 12: the client-server architecture 42

Figure 13: Home page screenshot 44

Figure 14: Product category view screen 45

Figure 15: Customer shopping invoice 46

Figure 16: Customer login form for ordering 47

Figure 17: Authorized user login interface 48

Figure 18: Customer information interface 49

Figure 19: Customer suggestion interface 50

ABSTRACT

The purpose of this project is to design and implement online ordering and inventory system for which the case study is La GALETTE supermarket, specialized in the ordering of family use alimentation products like bread, cake and fruits. The problem currently facing the La GALETTE supermarket in the existing system; the activities like ordering online their products, registration of customers and users details, also it doesn't easily to control all store transaction details.

The main problems are make ordering online and to manage the product on stock. The La GALETTE supermarket has no specific software that helps us customers ordering their product online wherever they are in the world and help us to manage its inventory.

This Application offers the ability to visit all products recorded in supermarket, ordering product he/she selected, report and print information about products stored and customers ordered products, finally it lets the authorized user know how many products are remained in store and how many order received.

To implement this application, setups are created and some are installed on the server side and the other is installed on the client side.

LIST OF ABREVIATION

ASP: Active Server Page

BISM: Bachelor in Information System and Management

CNLS: Centre Nationale de Lutter contre le Sida

CSS: Cascading Style Sheets

DFD: Data Flow Diagram

DOM: Document Object Model

ERD: Entity Relationship Diagram

ERDM: Entity Relationship Data Model

FTP: File Transfer protocol

HTML: Hypertext Markup Language

HTTP: Hyper Text transfer Protocol

ICT: Information Communication Technology

INILAK: Independent Institute of Lay Adventists of Kigali

IP: Internet Protocol

ISP: Internet Service Provider

LAMP : Linux, Apache, Mysql and PHP

LDM: Logic Data Model

MERISE: Méthode d'Etude et de Réalisation Informatique pour les Systèmes d'Entreprise

MINISANTE: Ministère de la Sante

MTN: Mobile Telephone Network

ODBMS: Object Data base Management System

OMP: Organizational Model of Process

OOIS: Online Ordering and Inventory System

OSMIS: Online Student Management Information System

PHP: Personal Home Page or Hypertext Preprocessor

PMD: Physical Data Model

RRA: Rwanda Revenue Authority

SMTP: Simple Mail Transport Protocol

SQL: Structure Query Language

TCP: Transmission Control Protocol

TMC: Treatment conceptual model

WWW: World Wide Web

XAMPP: X Apache, MySQL Perl and PHP