ABSTRACT
This project work deals with the
design and implementation of online supermarket for marketing organization with
the aim of computerizing sales and purchase online. This research work will
among other things assist the organization in rapid and accurate calculations,
sales and retrieval of customers’ data and information. The system is designed
with three sub-systems which include file maintenance and transaction, report
generation and help facilities. Each of them is accessed with a careful
designed menu system with the features offered by Dreamweaver mysql and php.
Through the available utilities, the customer will be able to get item-by-item
description of
each of the products and information related to group of item
like price and manufacturers name. The software will also enable the user (site
owners) to generate analysis of sales on daily, monthly and yearly basis, which
can be used by business organization in their day to day decision making. All
in all, I was able to design and implement an online supermarket for CY
supermarket with the capability of accepting payment online using visa card.
TABLE
OF CONTENTS
Title page - - - - - - - - - - i
Certification - - - - - - - - - ii
Approval Page - - - - - - - - iii
Dedication - - - - - - - - iv
Acknowledgment
- - - - - - - - v
Abstract - - - - - - - - - vi
Table of
contents - - - - - - - - vii
List of Tables
- - - - - - - - - xi
List of
Figures - - - - - - - - xii
CHAPTER ONE
1.0
INTRODUCTION
1.1 Background Concept - - - - - - 1
1.2 Statement of Problem - - - - - - 2
1.3 Significance of the Study - - - - - 2
1.4 Aim and Objectives - - - - - - 3
1.5 Scope of the Study - - - - - 3
CHAPTER TWO
2.0
LITERATURE
REVIEW
2.1 Internet - - - - - - - 4
2.2 Electronic Commerce - - - - - - 4
2.2.1 Website - - - - - - 5
2.2.2 Online Magazine (E-zine) - - - - 5
2.2.3 Autoresponder - - - - - - 6
CHAPTER THREE
3.0
ANALYSIS
OF THE EXISTING SYSTEM
3.1 Documentation Packages - - - - - 7
3.2 Operation of the Present System - - - - 9
3.2.1 Purchase Unit - - - - - - 9
3.2.2 Sales Unit - - - - - - 9
3.2.3 Main Store/Warehouse Unit - - - - 10
3.2.4 Account Unit - - - - - - 10
3.3 Data Collection and Analysis - - - - - 10
3.4 Summary of Interview - - - - - 11
3.5 Input and Output Analysis - - - - - 11
3.6 Progress and recommendation report - - - - 15
3.7 Operational Progress and recommendation - - - 15
3.7.1 Efficient Management Control - - - 15
3.7.2 Efficient Inventory Control - - - - 16
3.7.3 Efficient Account Control - - - - 16
CHAPTER FOUR
4.0 SYSTEM
DESIGN AND SPECIFICATION
4.1 Introduction
to New system - - - - - 17
4.2 Description
of the new system - - - - 17
4.3 Project
Design - - - - - - - 17
4.3.1 Data Model - - - - - - 18
4.3.1.1 Database Design - - - - 19
4.3.2 Process Model - - - - - - 21
4.3.2.1 Functional decomposition Diagram - - 21
4.3.2.2 Data Flow Diagram - - - - 24
4.3.3 User Interface
design - - - - - 27
CHAPTER FIVE
5.0 SYSTEM
IMPLEMENTATION, TESTING AND INTEGRATION
5.1 Implementation
Technology - - - - - 32
5.2 Mysql
Database - - - - - - 33
5.3 Integrating
the Website and Database - - - 34
5.4 Web Page
Programming Options - - - - 35
5.4.1 Server-Side Processing - - - - 37
5.4.2 Client-Side
Processing - - - - 40
5.5 Integration - - - - - - - 41
5.6 Testing - - - - - - - 42
5.6.1 Test Plan - - - - - - 43
5.6.2 Test Result - - - - - - 43
5.6.3 Performance Evaluation - - - - 45
CHAPTER SIX
6.0
SUMMARY, CONCLUSION AND
RECOMMENDATION
6.1
Summary
Of Achievements - - - - - 46
6.2
Problems
and Solution - - - - - 46
6.3
Recommendation - - - - - - 46
6.4
Conclusion - - - - - - - 47
References - - - - - - - - - 48
Appendix A Website Coding - - - - - - 50
Appendix B Sample Input and Output Screens - - - - 64
LIST OF TABLES
Table 4.1 Customer
Table - - - - - - - 19
Table
4.2 Products Table - - - - - - - 20
Table
4.3 Order Table - - - - - - - 20
Table
4.4 Credit Card Table - - - - - - - 20
Table
4.5 Purchase History - - - - - - - 21
Table 4.6 Main
Menu - - - - - - - - 28
Table 4.7 Display of goods present in the store - - - - 28
Table 4.8
Customer registration Form 29
Table 4.9 Show
Room - - - - - - - - 29
Table 4.10
Customer Login - - - - - - - 30
Table 4.11
Customer Placing an Order - - - - - 30
Table 4.12
Admin Login Form - - - - - - 30
Table 4.13
Admin Page - - - - - - - 31
Table 4.9
Customer Registration Form - - - - - 28
Table 5.4 Processing Technology for Different File Extensions - - 39
Table
5.1 Test result (Actual Versus Expected) - - - - 43
PRESENTED BY
OBEJI IBEABUCHI ERIC
EBSU/2007/42252
A PROJECT SUBMITTED TO THE
DEPARTMENT OF
COMPUTER SCIENCE
IN PARTIAL FULFILMENT FOR THE REQUIREMENTS FOR THE
AWARD OF BACHELOR OF SCIENCE (B.SC)
DEGREE INCOMPUTER SCIENCE
FACULTY OF PHYSICAL SCIENCES
EBONYI STATE UNIVERSITY, ABAKALIKI
MARCH, 2012