ShopNow E-Commerce Database
Course: Advanced Database Management (ISM 6218)
Timeline: October 2025 - November 2025
Project Type: Coursework
SQL Oracle
Project Description
I built this e-commerce database to model how an online shopping platform like Amazon manages its data. The database handles everything from customer accounts and product catalogs to shopping carts, orders, and payment processing. I designed normalized tables to efficiently store customer information, product details with categories and inventory levels, and complete order histories with shipping addresses. The ERD shows how customers can have multiple orders, each order contains multiple products, and how we track inventory levels in real-time. I wrote SQL queries to handle common e-commerce operations like adding items to carts, processing orders, and generating sales reports. The documentation includes the full schema design and data dictionary, demonstrating how to structure data for a complex business application.
Project Screenshots
Project Resources
Includes documentation, ERDs, data dictionaries, and other project materials.
Course Information
Advanced Database Management
ISM 6218
This was probably my favorite course, it went deep into database design and management. We started with the fundamentals of relational databases and entity-relationship modeling, then moved into advanced SQL for complex queries, triggers, and views. I learned about database normalization to eliminate redundancy, indexing strategies to improve performance, and transaction management to ensure data integrity. We covered both traditional SQL databases and newer NoSQL alternatives, discussing when each approach makes sense. The course also introduced OLAP systems for business intelligence and data warehousing concepts. The hands-on labs were great, I got to design complete database systems from scratch, implement them in SQL Server, and optimize their performance. This course gave me the skills to not just use databases, but to design and manage them effectively.
View All Courses