🧾 Sales Management Database (MySQL)

A simple SQL project demonstrating a basic sales database structure using MySQL Workbench 8.0.

📂 Structure

• 01_create_tables.sql → Table creation scripts
• 02_insert_data.sql → Sample data
• 03_queries.sql → Practice queries (JOINs, GROUP BY, etc.)

🧠 Key Concepts

• Database normalization
• Relationships (1:N between Customers–Orders and Products–Orders)
• Aggregation & filtering (SUM, AVG, GROUP BY, HAVING)

⚙️ How to Run

1. Open MySQL Workbench
2. Run scripts in order: 01_create_tables.sql → 02_insert_data.sql → 03_queries.sql
3. Explore and modify as needed!

Created by Panagiotis Zois | MSc ICT | Bridging Business & Technology