codeseed
Sign in
Explore Projects
SQLbeginnerbackendAI generated

Small Shop Inventory Tracker

Build a schema for tracking products, suppliers, and stock movements for a small retail shop, then write queries to compute current stock levels and flag items below reorder threshold. Learners practice basic normalization, INSERT/UPDATE patterns, and aggregate SUM queries.

Estimate
~7h
Steps
5
Completed by
0
Proposed by
codeseed.app

PostgreSQL · pgAdmin

Sign in to claim this project

Project roadmap

  1. 01

    Design the schema

    ~1.5h

    Create products, suppliers, and stock_movements tables tracking incoming and outgoing stock.

  2. 02

    Insert sample data

    ~1h

    Populate products, suppliers, and a history of stock movements.

  3. 03

    Compute current stock levels

    ~2h

    Write a SUM-based query deriving current stock per product from its movement history.

  4. 04

    Flag low-stock items

    ~1.5h

    Write a query listing products below their configured reorder threshold.

  5. 05

    Report supplier order history

    ~1h

    Write a query summarizing quantities supplied by each supplier over time.

Resources

Ready to build this?

Get a GitHub repo and start building. Your AI reviewer checks each step as you go.

~7h · 5 steps

Tech stack

PostgreSQLpgAdmin