# sahidul-shaikh/stock-market-analysis-with-sql architecture

> Architecture diagram of the GitHub repository sahidul-shaikh/stock-market-analysis-with-sql, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-26). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/sahidul-shaikh/stock-market-analysis-with-sql
- Repository: https://github.com/sahidul-shaikh/stock-market-analysis-with-sql
- Video tour (about a minute): https://gitdiagram.com/sahidul-shaikh/stock-market-analysis-with-sql/video

## Overview

This repository is a SQL-based stock-market analysis assignment: historical prices for six stocks are imported into MySQL, analyzed with 20- and 50-day moving averages, and used to create trading signals. The README also specifies a combined price table, a Bajaj-specific signal function, and a written summary. The SQL source was not sampled, so internal query details and exact execution order cannot be verified.

Main entry points: [`sql-code.sql`](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/sql-code.sql) (Analysis SQL), [`Bajaj Auto.csv`](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/Bajaj%20Auto.csv) (Bajaj Prices), [`Eicher Motors.csv`](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/Eicher%20Motors.csv) (Eicher Prices), [`Hero Motocorp.csv`](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/Hero%20Motocorp.csv) (Hero Prices)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_inputs["Stock Data"]
  node_bajaj_csv["Bajaj Prices<br/>[Bajaj Auto.csv]"]
  node_eicher_csv["Eicher Prices<br/>[Eicher Motors.csv]"]
  node_hero_csv["Hero Prices<br/>[Hero Motocorp.csv]"]
  node_infosys_csv["Infosys Prices<br/>[Infosys.csv]"]
  node_tcs_csv["TCS Prices<br/>[TCS.csv]"]
  node_tvs_csv["TVS Prices<br/>[TVS Motors.csv]"]
end

subgraph group_analysis["SQL Analysis"]
  node_mysql[("MySQL Assignment")]
  node_sql["Analysis SQL<br/>[sql-code.sql]"]
end

subgraph group_results["Analysis Results"]
  node_ma_tables[("Moving Averages<br/>[sql-code.sql]")]
  node_master_table[("Master Prices<br/>[sql-code.sql]")]
  node_signal_tables[("Buy Sell Hold<br/>[sql-code.sql]")]
  node_bajaj_function["Bajaj Signal Function<br/>[sql-code.sql]"]
  node_report["Summary Report<br/>[Summary-Report.pdf]"]
end

node_user(("Analyst"))

node_user -->|"imports data"| node_mysql
node_bajaj_csv -->|"imported into"| node_mysql
node_eicher_csv -->|"imported into"| node_mysql
node_hero_csv -->|"imported into"| node_mysql
node_infosys_csv -->|"imported into"| node_mysql
node_tcs_csv -->|"imported into"| node_mysql
node_tvs_csv -->|"imported into"| node_mysql
node_user -->|"runs"| node_sql
node_sql -->|"queries"| node_mysql
node_sql -->|"creates"| node_ma_tables
node_sql -->|"creates"| node_master_table
node_sql -->|"creates"| node_signal_tables
node_sql -->|"defines"| node_bajaj_function
node_user -->|"reviews"| node_report

click node_bajaj_csv "https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/Bajaj%20Auto.csv"
click node_eicher_csv "https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/Eicher%20Motors.csv"
click node_hero_csv "https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/Hero%20Motocorp.csv"
click node_infosys_csv "https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/Infosys.csv"
click node_tcs_csv "https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/TCS.csv"
click node_tvs_csv "https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/TVS%20Motors.csv"
click node_sql "https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/sql-code.sql"
click node_ma_tables "https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/sql-code.sql"
click node_master_table "https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/sql-code.sql"
click node_signal_tables "https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/sql-code.sql"
click node_bajaj_function "https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/sql-code.sql"
click node_report "https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/Summary-Report.pdf"

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_bajaj_csv,node_eicher_csv,node_hero_csv,node_infosys_csv,node_tcs_csv,node_tvs_csv toneBlue
class node_mysql,node_sql toneAmber
class node_ma_tables,node_master_table,node_signal_tables,node_bajaj_function,node_report toneMint
class node_user toneIndigo
```

## Components

### Stock Data

- [Bajaj Prices](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/Bajaj%20Auto.csv): `Bajaj Auto.csv`
- [Eicher Prices](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/Eicher%20Motors.csv): `Eicher Motors.csv`
- [Hero Prices](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/Hero%20Motocorp.csv): `Hero Motocorp.csv`
- [Infosys Prices](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/Infosys.csv): `Infosys.csv`
- [TCS Prices](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/TCS.csv): `TCS.csv`
- [TVS Prices](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/TVS%20Motors.csv): `TVS Motors.csv`

### SQL Analysis

- **MySQL Assignment**
- [Analysis SQL](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/sql-code.sql): `sql-code.sql`

### Analysis Results

- [Moving Averages](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/sql-code.sql): `sql-code.sql`
- [Master Prices](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/sql-code.sql): `sql-code.sql`
- [Buy Sell Hold](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/sql-code.sql): `sql-code.sql`
- [Bajaj Signal Function](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/sql-code.sql): `sql-code.sql`
- [Summary Report](https://github.com/sahidul-shaikh/stock-market-analysis-with-sql/blob/main/Summary-Report.pdf): `Summary-Report.pdf`

### Other components

- **Analyst**

## Connections

- Analyst → MySQL Assignment: imports data
- Bajaj Prices → MySQL Assignment: imported into
- Eicher Prices → MySQL Assignment: imported into
- Hero Prices → MySQL Assignment: imported into
- Infosys Prices → MySQL Assignment: imported into
- TCS Prices → MySQL Assignment: imported into
- TVS Prices → MySQL Assignment: imported into
- Analyst → Analysis SQL: runs
- Analysis SQL → MySQL Assignment: queries
- Analysis SQL → Moving Averages: creates
- Analysis SQL → Master Prices: creates
- Analysis SQL → Buy Sell Hold: creates
- Analysis SQL → Bajaj Signal Function: defines
- Analyst → Summary Report: reviews