Project Overview
A modern web application built on the classic Northwind database, demonstrating CRUD operations, complex data relationships, reporting, and role-based access controls.
The Problem
The Northwind database is a well-known learning resource, but most implementations are limited to basic queries. This project extends it into a full web application with real operational features.
The Solution
A Flask-based web interface with full CRUD operations for all major entities, reporting dashboards, filtered views, and role-based access control.
Key Features
- Full CRUD for customers, orders, products, suppliers, employees
- Order management with line items and totals
- Product inventory and category management
- Sales reporting and analytics
- Role-based access control
- Filtered and searchable data views
My Role
Complete design and implementation — database integration, backend logic, frontend templates, and access control system.
Technology Used
Challenges and Learning
Implementing complex multi-table relationships and ensuring data integrity across CRUD operations. Building a meaningful reporting layer on top of relational data.
Outcome / Value
A thorough demonstration of full-stack web development skills, relational database management, and application architecture using a well-understood data model.
Screenshots
