DBMS Report
DBMS Report
DBMS Report
Submitted by
CHITRA SATHISH [4VV21CS045]
DIVYA NAGESH [4VV21CS056]
NAIK
DIVYASHREE B [4VV21CS057]
ARYA CHIDANAND [4VV21CS025]
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.
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 PANEL
EDIT PROFILE PANEL
STOCK DETAILS
4.1.2 DISTRIBUTOR LOGIN:
DISTRIBUTOR HOME
DISTRIBUTOR ORDERS FROM VARIOUS STORES
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