“E-RETAIL”: An Online Retail Management System

Project Domain / Category
Web Based
Abstract/Introduction
“E-RETAIL” is a web based Retail Management System for XYZ Shop. Details regarding the different users involved in
the system and the functions which they can perform are given below
Functional Requirements:
Following are the users of this system. Each user has to log in first, to use the system.
 Purchaser
 Seller
 Auditor
 Admin
Responsibilities and functions of each user are given below:
Purchaser:
1. There is only one purchaser in the system which can purchase different product items from any wholesaler
within the area. The purchaser can buy one or more product items from one wholesaler.
2. Purchaser can access and browse the system and buy product itemsfrom the list(shows in the system).
3. The information which a purchaser can access include 3 non-editable and 6 editable contents:
a. Non-Editable
 Product ID
 Product Name
 Shelf No (Where it will be placed)
b. Editable
 Purchase Product Quantity
 Purchase Product Price
 Purchase Total Price(Calculated automatically)
 Wholesaler name
 Wholesaler Phone no
 Wholesaler Address
Seller:
1. Seller is responsible to manage the records ofsold products. There may be many sellers in the systems. The
seller can sell one or more products to onebuyer.
2. The information a seller can access include 3 editable and 4 non-editable
contents:

c. Non-Editable
 Seller ID
 Sale Product Quantity
 Sale Product Price
 Sale Product Total (Calculated automatically)
Auditor:
1. There is only one auditor.
2. The system which an auditor can access include 13 non-editable contents:
Admin:
 Product ID
 Product Name
 Shelf No (Where it will be placed)
 Purchase Product Quantity
 Purchase Product Price
 Purchase Total Price(Calculated automatically)
 Wholesaler name
 Wholesaler Phone no
 Wholesaler Address
 Seller ID
 Sale Product Quantity
 Sale Product Price
 Sale Product Total (Calculated automatically)
1. Admin is the power user and has the rights of each user. He can add/remove the Purchaser, Seller and
Auditor.
Proposed Tools: Java, Dotnet Framework, MySQL, SQL server etc