# atchudan/amazon-sales-sql architecture

> Architecture diagram of the GitHub repository atchudan/amazon-sales-sql, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-27). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/atchudan/amazon-sales-sql
- Repository: https://github.com/atchudan/amazon-sales-sql

## Overview

This repository is a MySQL sales analytics project: a user loads a CSV into a normalized relational database, then runs SQL analyses to answer business questions. The README documents schema creation, CSV loading, and 15 queries across sales, products, customers, sellers, payments, returns, and time trends. Source excerpts were not available, so the relationships shown rely on the README and file tree; individual query implementations and screenshot contents are not verified.

Main entry points: [`queries.sql`](https://github.com/atchudan/amazon-sales-sql/blob/main/queries.sql) (Business queries), [`schema.sql`](https://github.com/atchudan/amazon-sales-sql/blob/main/schema.sql) (Schema and import)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_setup["Data setup"]
  node_schema["Schema and import<br/>[schema.sql]"]
end

subgraph group_storage["Relational data"]
  node_database[("Sales database")]
end

subgraph group_analysis["Business analysis"]
  node_queries["Business queries<br/>[queries.sql]"]
  node_sales["Sales and trends<br/>[queries.sql]"]
  node_products["Product analysis<br/>[queries.sql]"]
  node_customers["Customer analysis<br/>[queries.sql]"]
  node_sellers["Seller analysis<br/>[queries.sql]"]
  node_orders["Orders and returns<br/>[queries.sql]"]
end

node_analyst(("Analyst"))
node_csv["Sales CSV"]
node_results["Query results"]

node_analyst -->|"runs setup"| node_schema
node_schema -->|"reads CSV"| node_csv
node_schema -->|"creates and loads"| node_database
node_analyst -->|"runs queries"| node_queries
node_queries -->|"reads tables"| node_database
node_queries -->|"analyzes"| node_sales
node_queries -->|"analyzes"| node_products
node_queries -->|"analyzes"| node_customers
node_queries -->|"analyzes"| node_sellers
node_queries -->|"analyzes"| node_orders
node_queries -->|"returns results"| node_results

click node_schema "https://github.com/atchudan/amazon-sales-sql/blob/main/schema.sql"
click node_queries "https://github.com/atchudan/amazon-sales-sql/blob/main/queries.sql"
click node_sales "https://github.com/atchudan/amazon-sales-sql/blob/main/queries.sql"
click node_products "https://github.com/atchudan/amazon-sales-sql/blob/main/queries.sql"
click node_customers "https://github.com/atchudan/amazon-sales-sql/blob/main/queries.sql"
click node_sellers "https://github.com/atchudan/amazon-sales-sql/blob/main/queries.sql"
click node_orders "https://github.com/atchudan/amazon-sales-sql/blob/main/queries.sql"

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_schema toneBlue
class node_database toneAmber
class node_queries,node_sales,node_products,node_customers,node_sellers,node_orders toneMint
class node_analyst,node_csv,node_results toneIndigo
```

## Components

### Data setup

- [Schema and import](https://github.com/atchudan/amazon-sales-sql/blob/main/schema.sql): `schema.sql`

### Relational data

- **Sales database**

### Business analysis

- [Business queries](https://github.com/atchudan/amazon-sales-sql/blob/main/queries.sql): `queries.sql`
- [Sales and trends](https://github.com/atchudan/amazon-sales-sql/blob/main/queries.sql): `queries.sql`
- [Product analysis](https://github.com/atchudan/amazon-sales-sql/blob/main/queries.sql): `queries.sql`
- [Customer analysis](https://github.com/atchudan/amazon-sales-sql/blob/main/queries.sql): `queries.sql`
- [Seller analysis](https://github.com/atchudan/amazon-sales-sql/blob/main/queries.sql): `queries.sql`
- [Orders and returns](https://github.com/atchudan/amazon-sales-sql/blob/main/queries.sql): `queries.sql`

### Other components

- **Analyst**
- **Sales CSV**
- **Query results**

## Connections

- Analyst → Schema and import: runs setup
- Schema and import → Sales CSV: reads CSV
- Schema and import → Sales database: creates and loads
- Analyst → Business queries: runs queries
- Business queries → Sales database: reads tables
- Business queries → Sales and trends: analyzes
- Business queries → Product analysis: analyzes
- Business queries → Customer analysis: analyzes
- Business queries → Seller analysis: analyzes
- Business queries → Orders and returns: analyzes
- Business queries → Query results: returns results