Skip to content

Xindi8/Retail_Data_Analytics_Database_System

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

17 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Retail Data Analytics Database System

It is a console-based retail management system that simulates a small online store.

In this system, users can register or log in, then customers can search products by keywords, view product details, add items to a cart, update quantities, and checkout to create an order with a shipping address. Customers can also view past orders and see order details.

There is also a sales role that can update product price and stock, generate a weekly sales report, and show top products by orders and by views. When the user wants the top product report, it will automatically generate the excel file.

The system records user sessions, search history, and viewed products, so it can support reports later. For checkout, I also used a transaction to make sure stock updates and order creation stay consistent — if stock is not enough, it rolls back safely.

Setup

1) Create & activate virtual environment (Windows PowerShell)

python -m venv .venv
.\.venv\Scripts\Activate.ps1
  1. Install dependencies
python -m pip install -r requirements.txt
  1. Run the app

From the project root:

python -m src.app data/store.db

The Excel sheet contains all tables in this system

image

About

No description, website, or topics provided.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages