Scribd
Upload
4 views11 pages

Computer Store Management System Guide

The Computer Store Management System is a database-driven application aimed at automating the operations of a computer retail store, focusing on product, supplier, customer, and sales management. Key features include detailed product tracking, supplier management, customer records, and billing generation. The system's database consists of entities such as customers, products, orders, and payments, with defined attributes for each entity.

Uploaded by

myprogresstracker544
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
4 views11 pages

Computer Store Management System Guide

The Computer Store Management System is a database-driven application aimed at automating the operations of a computer retail store, focusing on product, supplier, customer, and sales management. Key features include detailed product tracking, supplier management, customer records, and billing generation. The system's database consists of entities such as customers, products, orders, and payments, with defined attributes for each entity.

Uploaded by

myprogresstracker544
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

COMPSTORE

MANAGEMENT
SYSTEM

GAURISH GOGULWAR
SIDDHANT JAIN
PAGE 01
HARSHIT GUPTA
PROJECT OVERVIEW – COMPUTER
STORE MANAGEMENT SYSTEM
The Computer Store Management System is a
database-driven application designed to simplify
and automate the daily operations of a computer
retail store. The project focuses on efficiently
managing products, suppliers, customers, and
sales transactions while maintaining accurate
stock and billing records.

PAGE 02
KEY FEATURES:

• Maintain detailed product and accessory information.


• Track suppliers and manage purchase orders for
inventory restocking.
• Record customer details and sales transactions.
• Generate accurate bills and invoices.
• Monitor stock levels and identify fast-moving items.

[Link] PAGE 03
DATABASE:
ENTITIES
[Link] – Stores customer details such as ID, name, and contact.
[Link] – Stores product categories like Laptops, Accessories,
Components.
[Link] – Stores product brands for classification.
[Link] – Stores product ID, name, category, brand, price, and stock.
[Link] – Stores order ID, customer ID, order date, and status.
[Link] Items – Stores products included in each order, quantity, and price.
[Link] – Stores payment ID, order ID, amount, date, and payment
method.

[Link] PAGE 04
DATABASE:
ATTRIBUTES
[Link]: customer_id INT, first_name VARCHAR(100), last_name
VARCHAR(100), email VARCHAR(150)
[Link]: category_id INT, name VARCHAR(100)
[Link]: brand_id INT, name VARCHAR(100)
[Link]: product_id INT, name VARCHAR(150), price DECIMAL(10,2),
stock_qty INT, brand_id INT, category_id INT
[Link]: order_id INT, customer_id INT, order_date DATE, total_amount
DECIMAL(10,2)
[Link]: payment_id INT, order_id INT, payment_date DATE, amount
DECIMAL(10,2), method ENUM
7.order_items: order_item_id INT, order_id INT, product_id INT, quantity INT,
unit_price DECIMAL(10,2)

[Link] PAGE 05
ER DIAGRAM PRIMARY KEY

FOREIGN KEY
ER DIAGRAM

CUSTOMER — PLACES — ORDER


CATEGORY — CONTAINS — PRODUCT
PRODUCT — BELONGS TO — BRAND
PRODUCT — APPEARS IN — ORDERITEM
ORDER — INCLUDES — ORDERITEM
ORDER — GENERATES — PAYMENT

[Link] PAGE 07
WEBSITE
PROTOTYPE

[Link] PAGE 08
ADMIN
PORTAL

[Link] PAGE 09
CUSTOMER
PORTAL

[Link] PAGE 10
THANK
YOU!

You might also like