www.freestudentprojects.com www.studentprojectcode.com www.bestprojectsidea.
com
SYNOPSIS
Project title: Supermarket Management System
INTRODUCTION:
Objective:
The objective of the Supermarket Management System 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 it also consumes a lot of time.
The data will be stored in the database. Because of this software, paper work will be reduced
and the user can spend more time on the monitoring the supermarket. The project will be user friendly
and easy to use.
Scope:This project is helpful to computerise the item transaction, sales activity record keeping which
is a very huge task and maintaining the stock.
PROJECT CATEGORY:
RDMS
PROJECT DESCRIPTION:
The Supermarket Management System is based on the sales transaction 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 admin. Any modifications to be done in the item name or the in 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 wanted to purchase. This is not a huge a task. The system will display
all the items whose name starts with the letter selected by the user. He can select out of those
displayed. Finally a separate 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.
Modules:
Account Configuration:
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.
Sales: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 wanted
to purchase. This is not a huge a task. The system will display all the items whose
www.freestudentprojects.com www.studentprojectcode.com www.bestprojectsidea.com
name starts with the letter selected by the user. He can select out of those displayed.
Finally a separate will be generated for each customer.
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
HARDWARE REQUIREMENTS:
Processor: Intel dual core or above
Processor Speed:1.0GHZ or above
RAM: 1 GB RAM or above
Hard Disk: 20 GB hard disk or above
User
Maitenance of
Item details
Sales
Bill
generation
tbl_item
item no, item
name , rate
item no, item name ,
rate
item name
item name, qty
item name,qty,
rate, total
tbl_sales
bill no, item name, qty,
rate, total
bill no, item name, qty,
rate, total
Vendor
deduction
item name, qty,
total amount
tbl_vendor
item name, qty
amount
amount
deducted
amount
amount
Report
item name, year
, month
item name, year
, month
www.freestudentprojects.com www.studentprojectcode.com www.bestprojectsidea.com
SOFTWARE REQUIREMENTS:
Language: Visual Basic 6.0
Database: Microsoft SQL server 2008
CONCLUSION:
Supermarket Management System software developed for a company has been designed to
reduce the time taken to handle the sales activity. It is designed to replace an existing manual record
system for reducing time taken for calculations and for storing data. The system uses Visual Basic as
front end and SQL server as a backend for the database.
The system is strong to handle daily operations where the database is cleared over certain time. This
system will reduce manual work, calculations and will also provide periodic reports any time.
BIBILIOGRAPHY:
Books
An Integrated Approach to Software Engineering- Pankaj Jalote
Database Management System- Elmasri and Navathe
Websites
http:// www. google.com
http://www.wikipedia.com
