DBMS Report

Download as pdf or txt
Download as pdf or txt
You are on page 1of 12

“Online Store Management System ”

Submitted by
CHITRA SATHISH [4VV21CS045]
DIVYA NAGESH [4VV21CS056]
NAIK
DIVYASHREE B [4VV21CS057]
ARYA CHIDANAND [4VV21CS025]

Under the guidance of

Dr. Hemashree L
Assistant Professor
Department of Computer Science & Engineering
VVCE, Mysuru
INTRODUCTION
Superstore is an Indian retail store that operates as a chain of hypermarkets. It is one of India’s
oldest and largest hypermarket chains, housing about 150+ stores in over 60 cities and towns of
the country. It has a wide range of categories such as Groceries, Clothing & Fashion, Furniture,
Electronics, Office Supplies, Cosmetics, Kitchen & Dining utilities, and many more.

MAIN FEATURES OF THE PROJECT


• Main features of the Project
• Sales Management
• Revenue Analytics
• Inventory Management
• Shipment Management
• Category wise Analytics
• Advance Records Searching
• Advance Reports

OBJECTIVES
• Maintains the details of Sales by Store/Region/State
• Profits/Sales Analytics
• Details of Store i.e. No’s, Region, Address
• List of orders which have not been Delivered
• List of payments paid or pending to the Distributors
• Profit calculation by date/month/season
• Maintains the details of product stock.
• Track Shipment of a Store Order
• The stock that is to buy if quantity goes less than a particular amount and Profit
calculation for a month

TECHNOLOGY USED
• Web Browser: Google Chrome, Firefox, etc.
• Database: MySQL
• User Interface: HTML, CSS
• Language Used : PHP for Backend
SCHEMA DIAGRAM
FRONT END DESIGN

HOME

ADMIN LOGIN
ADMIN HOMEPAGE

SALES REPORT
DISTRIBUTOR TABLE AND
NEW DISTRIBUTOR REGISTRATION PANEL

STORE MANAGEMENT PANEL


4.1.1 STORE LOGIN:

STORE PANEL
EDIT PROFILE PANEL

SALES REPORT MANAGEMENT PANEL


STORE ORDERS TO THE DISTRIBUTOR

STOCK DETAILS
4.1.2 DISTRIBUTOR LOGIN:

DISTRIBUTOR HOME
DISTRIBUTOR ORDERS FROM VARIOUS STORES

ORDER STATUS MANAGE PANEL


CONCLUSION

While developing this project we have learnt a lot about HTML/CSS/JS/PHP/MySQL and working with
database management, we have also learnt how to make the application user- friendly (easy to use and
handle) by hiding the complicated parts of it from the users.

During the development process, we studied carefully and understood the criteria for making a software more
demanding, we also realized the importance of maintaining a minimal margin for errors.

BIBLIOGRAPHY
https://github.com/AbhishekMali21/SUPERSTORE-SALES-MANAGEMENT-SYSTEM-DBMS-
PROJECT/tree/master/screenshots

You might also like