MuhammadAhmad
Resume

06 / Case study

Freight Cargo Inventoryand Shipment System

A full-stack inventory, shipment and administration platform backed by normalized PostgreSQL.

  1. Next.js01
  2. Supabase02
  3. PostgreSQL03

Calgary, ABMMVI KID

Same city.Brightertomorrows.

Hamodiiiiiii

The challenge

How can a freight operator manage users, warehouses, carriers, shipments and containers in one reliable system?

Impact

Database tables
15
Seeded locations
63
Continents represented
6

Calgary

Realplacesrealprogress

Overview

Built for CPSC 471, this freight-management system combines a Next.js 15 and React 19 interface with Supabase authentication and a normalized PostgreSQL database.

My contribution

I connected Supabase authentication to application users, created structured seed data, and built personalized dashboards, analytics and reporting. I also implemented approval, promotion, demotion and pending-registration workflows, plus responsive UI and dark mode.

Data design

The database contains 15 tables, two views, two stored functions and an audit trigger. Queries use direct parameterized SQL rather than an ORM.