A relational database for an online store, normalized to 3NF.
categories, customers, products, orders, order_items, payments
- ERD diagram
- Table creation script with PK/FK, CHECK constraints and indexes
- Sample data
- 7 reporting queries (monthly sales, top products, top customers, revenue by category, order details, customers without orders, low stock)
- Open
ecommerce_db_sqlserver.sqlin SSMS - Execute the script
- Run the report queries one by one
SQL Server (T-SQL), dbdiagram.io