Design And Implementation Of Supermarket Management System

Project and Seminar Material for Computer Science and Computer Engineering

Abstract

This study is based on the sales transaction and billing of items in a supermarket. It is to produce software which manages the sales activity done in the supermarket, maintaining the stock details, keeping the records of the sales done for a particular month/year, thereby helping progress level, stock taking and managerial decisions, and so on. This paper examines in detail the analysis and design of the Skillmid supermarket system, highlighting the testing exercise and describing some of the main components of the system’s Graphical User Interface (GUI). It is a high standard program that can weather the storm of technology advancement, it is most needed in all supermarkets and it is an antidote for poor business speed and transaction with record keeping and maintenance, it will be very helpful to clients and customers in the marketing business.

Chapter One

Introduction

1.1 General Overview

Supermarket management system is the system where all the aspects related to the proper management of supermarket is done. These aspects involve managing information about the various products, staff, managers, customers, billing etc. This system provides an efficient way of managing the supermarket information. Also allows the customer to purchase and pay for the items purchased.

This study is based on the sales transaction and billing of items in a supermarket. The first activity is based on adding the items to the system along with the rate which are present in the supermarket and the name of the items which the supermarket will agree to sell. This authority is given only to the admin (administrator). Any modifications to be done in the item’s name and the rate can be done only by admin. He also has the right to delete any item. As the customer buys the products and comes to the billing counter, the user is supposed to enter the item name he purchased and the quantity of the item he had purchased. This is not a huge a task.

This study is to produce software which manages the sales activity done in a supermarket, maintaining the stock details, maintaining the records of the sales done for a particular month/year. The users will consume less time in calculation and the sales activity will be completed within a fraction of seconds whereas manual system will make the user to write it down which is a long procedure and so paper work will be reduced and the user can spend more time monitoring the supermarket. The program will be user friendly and easy to use.

The system will display all the items whose name start with the letter selected by the user. He can select out of those displayed. Finally a separate bill will be generated for each customer. This will be saved in the database. Any periodic records can be viewed at any time. If the stock is not available, the supermarket orders and buys from a prescribed vendor. The amount will be paid by deducting the total amount acquired in the sales activity. Admin provides a unique username and password for each employee through which he can login.

1.1.2 The Modules of Operation is stated below

Employee: When a new employee joins the company, his record is saved in the database.
Items: Here the Admin can add any new items present in the supermarket. He also has the right to modify or delete it from the database.
Registration: As soon as the employee joins the company, the admin provides unique username and password to him.
Vendor Order: If the stock is not available, the supermarket orders and buys from a prescribed vendor. The amount will be paid by deducting the total amount acquired in the sales activity.
Stock entry: The items bought from the vendor will be entered here and this will be added to the stock.
Indent Report: This provides the report of the items sold for a particular month/ year and also gives the total amount acquired.
Vendor Report: This provides the report of the items bought from a vendor for a particular month/ year and also gives the total amount spent.
Display: A user can view information regarding Items present in the supermarket.
Logout: This module allows the user to Logout the application. Further operations cannot be performed after user exits.

Functions Of This System:

This system provides list of various products
There are various brands information along with the additional details
There is online application form where customers can choose their respective product.
There is one important function provided where the information about the staff can be maintained.
There is database connectivity provided where each customer detail has been stored.
The system provides functions of editing customer details.
It provides functions of editing product details.
It provides functions of editing staff details.

1.2 Statement of Problem

As a Computer student he had to go into the business department to learn some basic sales and supermarket management topics to increase intellectual understanding on the study at hand and which was really tasking.
Building a standard Supermarket management system was not an easy task looking at the problems of existing manual system

The factors for these difficulties are:

1. Time Consumption:

Manual systems are time consuming, as the business owner must keep track of Supermarket sales on a daily basis, while updating the system manually at the end of the day.

2. Poor Communication:

A manual Supermarket system requires employees and managers to write down each time an item is removed from the Supermarket. If one employee forgets to mention that the last coffee product has been removed from the Supermarket, a manager expects the item to still be available for a customer during a sale. Compared with a technical Supermarket system, a manual Supermarket system does not help the communication in the workplace.

3. Physical Counts:

A manual Supermarket system does not provide any number, as all numbers from the Supermarket are gained through physical Supermarket counts. One of the difficulties of running a manual Supermarket system is that physical Supermarket counts must be performed frequently to control the items in the Supermarket. This is time consuming and can cost the business money, if employees must come in to help out outside of business hours.

4. Daily Purchases:

Keeping track of daily purchases is another difficult controlling measure with manual Supermarket systems. A manual Supermarket system requires the employees to write down the items sold during a single work day. This can be a difficult task, as one employee may lose the list of items sold or another may forget to write down a sale.

5. Ordering Supplies:

A manual Supermarket system does not update at the end of the day with updated Supermarket

1.3 Aims and Objective of Study

Aim of study is

To design a Computerized Supermarket Management System to ascertain stock level of a supermarket, when to order for more goods, keep status and updates of transactions, thereby helping progress level, stock taking and managerial decisions,.

The objective are

To study the functions of Supermarket management system.
To explore the challenges being faced by the manual system.
To make a software fast in processing, with good user interface.
To ensure accurate statistics of product item.
For Easy record of goods in store and proper identification.

1.3 Scope of Study

This research work covers stock control, management and tends to correct anomalies in Supermarket business. It analyses opening of new stocks, stock updates and ability to view existing ones. It provides quick way of operation by capturing the manual process and automating them. This project is helpful to computerize the item transaction, sales activity record keeping which is a very huge task and maintaining the stock.

1.4 Limitation of Study

Due to time and basic factors like unstable electricity, poor networks, unavailability of concrete business idea and many more this research has been limited to certain areas in supermarket management we only looked more into the supermarket inventory management area using Wampserver and Java.

1.5 Definition of Terms

Modules:

This can be described a search of a set of standardized parts or independent units that can be used to construct a more complex structure, such as an item.

Admin:

This is the administration of a business, organization,

Username:

This is an identification used by a person with access to a computer, network, or online service.

Password:

This is a secret word or phrase that must be used to gain admission to a place.

Vendor Order:

This is a commercial document used to request someone to supply something in return for payment and providing specifications and quantities;

Indent Report:

This contains order for goods (placed often through a local or foreign agent of a foreign supplier) under specified conditions of sale, the acceptance of which by the supplier (or the agent) constitutes a contract of sale.

Wampserver:

Refers to a software stack for the Microsoft Windows operating system, created by Romain Bourdon and consisting of the Apache web server, OpenSSL for SSL support, MySQL database and PHP programming language.

JAVA:

Is a programming language and computing platform first released by Sun Microsystems in 1995. There are lots of applications and websites that will not work unless you have Java installed, and more are created every day. Java is fast, secure, and reliable. From laptops to datacenters, game consoles to scientific supercomputers, cell phones to the Internet, Java is everywhere!

Chapter Five

Conclusion and Recommendation

5.1 Conclusion

In conclusion, Supermarket Management System has to do with making appropriate effort to stop the rising problem to all manual supermarket operation in order to enhance the operation of such supermarket. In this project, the software or system that can be used to aid all supermarkets that is still operating manually have been successfully developed. The software can be implementing in all types of supermarket as mentioned in the second chapter. The software has a large memory of storing all the goods in the supermarket and also keeping record it is highly effective and accurate.

5.2 Recommendation

In the development of this supermarket management system, I will recommend that if there is going to be any modification the new writer should endeavor to improve on the limitations such as inclusion of the report generation using iReport to further increase the system architecture and to satisfy users need more for writing of the source code, Java should be used and WampServer for the database. There are some limitations during the development of this supermarket management system that will require improvement as stated in previous chapter writer should put them in mind and face it as a challenge and not a problem.

5.3 Problem Encountered

A lot of challenges surfaced during the development of this incredible application though it tried stopping this project but the doggedness and consistency of the writer was in match with the challenge

The following are some of the problems or challenges encountered:

Expensive internet facility.
Understanding the M.S ADODC (Active X Data Object Data Control).
Inadequacy of power supply and many more.
Time factor on research to get a way of packaging the application successively.

5.4 Further Research

In the future, the following components can be added to the system in order to improve the effectiveness and efficiency of the system, which includes:

An advanced password system that will be embedded into all login pages to increase the security of the system.
A good Printing module should be included.
A good internet backup should be automated after everyday sales.
Internet Transactions should be allowed.