Online Shopping Database Management System
Overview
I modeled an e-commerce domain end to end: entities and relationships were pinned down in an ERD, then translated into MySQL through documented DDL scripts. On top of that schema I shipped two Python desktop applications (Jupyter notebooks driving Tkinter UIs): one for administrators (orders, stock, customer records, lightweight charts) and one for shoppers (profiles and order history). Both talk to the database through PyMySQL.
The public GitHub repository holds the ERD assets, SQL DDL folder, runnable notebooks, and the PDF write-up so the design and apps stay reproducible.
Deliverables
- An entity-relationship diagram and supporting assets under
ERD/that record catalog, customers, orders, inventory, and related relationships. - SQL DDL scripts to create and populate the schema in MySQL.
- An admin notebook application for back-office tasks: order and inventory visibility, customer records, and Matplotlib-backed summaries where quick visuals help.
- A customer notebook application for self-service profile maintenance and order tracking against the same database.
- A consolidated project report (PDF) describing design choices and usage.
Technology stack
- Database: MySQL with hand-authored DDL (see
SQL DDL/in the repository). - Application layer: Python in Jupyter Notebook, Tkinter for desktop UIs, PyMySQL for connections and queries.
- Visualization: Matplotlib for admin-facing charts.
- Documentation: ERD PDF, SQL scripts, and the written PDF report linked from the repository root.
Repository links
Clone or browse Online-Shopping-Database-Management-System on GitHub. Entry points for reviewers: