A relational database project designed and built from scratch in MySQL, simulating a supply chain inventory management system. Includes full schema design, sample data creation, and analytical queries covering key SQL concepts.
- MySQL Workbench
- categoris - Product categories
- vendor - Supplier information
- warehouses - Storage locations
- products - Inventory items linked to vendors and categories
- inventory - Stock levels per product per warehouse
- Q1 - Q3: JOIN queries across multiple tables
- Q4: GROUP BY - Product count per vendor
- Q5: Total inventory value per warehouse
- Q6: CASE statement - Stock status alerts (Critical/Low/Adequate)
- Q7: CTE - Warehouses above average inventory value
- Q8: Window Function - Products ranked by price within category
View the live Tableau Public dashboard here: [SupplyIQ Inventory Analytics Dashboard] https://public.tableau.com/app/profile/qushania.dillard/viz/SupplyIQInventoryAnalytics/Dashboard1