Online-Retail-System

🛒 Online Retail Database

A relational Online Retail Database project built with MySQL to model and manage the core data of an online shopping system.

The project focuses on database design, relationships between entities, SQL queries, JOIN operations, and basic sales analysis.

📌 Project Overview

This database represents an online retail environment where customers can purchase products, place orders, and make payments.

The project demonstrates how a relational database can organize retail data and connect different business entities through relationships and SQL queries.

🎯 Objectives

• Design a structured relational database for an online retail system.
• Store and manage customer and product information.
• Track orders and payments.
• Create relationships between database tables.
• Practice SQL queries and JOIN operations.
• Extract useful information from retail data.
• Build views for easier data analysis.

🗂️ Main Entities

The database is organized around core online-retail entities such as:

• Customers — customer information.
• Products — products available for purchase.
• Orders — customer orders and order information.
• Payments — payment information associated with orders.

These entities are connected through relational database relationships to maintain consistent and organized data.

🔍 SQL Concepts Covered

This project demonstrates practical SQL skills, including:

• Database and table creation
• Primary Keys
• Foreign Keys
• Relationships between tables
• SELECT
• WHERE
• ORDER BY
• GROUP BY
• Aggregate functions
• INNER JOIN
• LEFT JOIN
• Multi-table queries
• Views
• Data analysis queries

📊 Example Analysis

The database can be queried to answer business questions such as:

• Which customers have placed orders?
• What products are available?
• Which orders belong to each customer?
• What payment information is associated with an order?
• How can customer, order, and product data be combined using JOIN?
• What insights can be extracted from the retail data?

🛠️ Technologies

• MySQL
• SQL
• Relational Database Design

📁 Project Structure

Online-Retail-Database/
│
├── database.sql
├── queries.sql
├── views.sql
└── README.md

File names may vary depending on the final repository structure.

🚀 How to Run

1. Install MySQL

Install MySQL Server and a MySQL client such as MySQL Workbench.

2. Create the Database

Open the SQL script and execute the database/table creation statements.

CREATE DATABASE online_retail;

Then select the database:

USE online_retail;

3. Insert the Data

Run the provided SQL statements for creating and populating the tables.

4. Run Queries

Execute the analysis queries to explore the data and practice different SQL operations.

💡 What I Learned

Through this project, I practiced:

• Relational database modeling
• Designing connected tables
• Working with primary and foreign keys
• Writing SQL queries
• Combining data with different types of JOIN
• Creating SQL views
• Using databases to answer business-related questions

👨‍💻 Author

Ziad Sayed Ahmed (Zico)

Junior Data Scientist / Data Analytics Enthusiast

Skills: Python · SQL · Power BI · Machine Learning

---

⭐ If you find this project useful, feel free to explore the repository and the SQL queries.