# dndn15/mysql-python-data-analytics-mini-project architecture

> Architecture diagram of the GitHub repository dndn15/mysql-python-data-analytics-mini-project, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/dndn15/mysql-python-data-analytics-mini-project
- Repository: https://github.com/dndn15/mysql-python-data-analytics-mini-project

## Overview

This project turns retail transaction data into a normalized MySQL design and business-intelligence analysis. The documented workflow covers the raw dataset, five relational tables, and visualizations that support business decisions. The notebook and SQL file are represented as implementation components, but no source excerpts were available to verify their internal calls or data handling; relationships shown here rely on README statements.

Main entry points: [`mini_project_store.csv`](https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/mini_project_store.csv) (Retail Dataset), [`miniproject.sql`](https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/miniproject.sql) (Normalized Schema), [`Miniproject.ipynb`](https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/Miniproject.ipynb) (Data Analysis), [`README.md`](https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/README.md) (Business Insights)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Retail Data"]
  node_dataset[("Retail Dataset")]
end

subgraph group_database["Data Model"]
  node_schema[("Normalized Schema<br/>[miniproject.sql]")]
  node_erd["ER Diagram"]
end

subgraph group_analytics["Business Intelligence"]
  node_analysis["Data Analysis<br/>[Miniproject.ipynb]"]
  node_visualizations["Business Visualizations<br/>[Miniproject.ipynb]"]
  node_insights["Business Insights<br/>[README.md]"]
end

node_analyst(("Analyst"))

node_analyst -->|"provides data"| node_dataset
node_dataset -->|"normalizes into"| node_schema
node_schema -->|"documents relationships"| node_erd
node_dataset -->|"analyzes"| node_analysis
node_analysis -->|"creates"| node_visualizations
node_visualizations -->|"supports decisions"| node_insights
node_analyst -->|"uses findings"| node_insights

click node_dataset "https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/mini_project_store.csv"
click node_schema "https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/miniproject.sql"
click node_erd "https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/Mini%20Porject-ER%20and%20Visualizations.docx"
click node_analysis "https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/Miniproject.ipynb"
click node_visualizations "https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/Miniproject.ipynb"
click node_insights "https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/README.md"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_dataset toneBlue
class node_schema,node_erd toneAmber
class node_analysis,node_visualizations,node_insights toneMint
class node_analyst toneIndigo
```

## Components

### Retail Data

- [Retail Dataset](https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/mini_project_store.csv): `mini_project_store.csv`

### Data Model

- [Normalized Schema](https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/miniproject.sql): `miniproject.sql`
- [ER Diagram](https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/Mini%20Porject-ER%20and%20Visualizations.docx): `Mini Porject-ER and Visualizations.docx`

### Business Intelligence

- [Data Analysis](https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/Miniproject.ipynb): `Miniproject.ipynb`
- [Business Visualizations](https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/Miniproject.ipynb): `Miniproject.ipynb`
- [Business Insights](https://github.com/dndn15/mysql-python-data-analytics-mini-project/blob/MySQL-Python-Data-Analytics-Mini-Project/README.md): `README.md`

### Other components

- **Analyst**

## Connections

- Analyst → Retail Dataset: provides data (evidence: `README.md`)
- Retail Dataset → Normalized Schema: normalizes into (evidence: `README.md`)
- Normalized Schema → ER Diagram: documents relationships (evidence: `README.md`)
- Retail Dataset → Data Analysis: analyzes (evidence: `README.md`)
- Data Analysis → Business Visualizations: creates (evidence: `README.md`)
- Business Visualizations → Business Insights: supports decisions (evidence: `README.md`)
- Analyst → Business Insights: uses findings (evidence: `README.md`)
