# aritro19g/sql_project_data_jobs architecture

> Architecture diagram of the GitHub repository aritro19g/sql_project_data_jobs, 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/aritro19g/sql_project_data_jobs
- Repository: https://github.com/aritro19g/sql_project_data_jobs

## Overview

This repository is a PostgreSQL analysis project for identifying salary, skill-demand, and skill-pay patterns in India’s non-remote data analyst job market. The documented workflow prepares a database schema, then runs five separate SQL analyses whose results inform career decisions. The SQL files and README support the analysis scope and database relationship; no source excerpts show dataset loading or query execution wiring, so those links are omitted.

Main entry points: [`sql_load/1_create_database.sql`](https://github.com/aritro19g/sql_project_data_jobs/blob/main/sql_load/1_create_database.sql) (Create database), [`sql_load/2_create_tables.sql`](https://github.com/aritro19g/sql_project_data_jobs/blob/main/sql_load/2_create_tables.sql) (Create tables), [`sql_load/3_modify_tables.sql`](https://github.com/aritro19g/sql_project_data_jobs/blob/main/sql_load/3_modify_tables.sql) (Modify tables), [`project_sql/1_top_paying_jobs.sql`](https://github.com/aritro19g/sql_project_data_jobs/blob/main/project_sql/1_top_paying_jobs.sql) (Top-paying jobs)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_schema["Database Setup"]
  node_create_db["Create database"]
  node_create_tables["Create tables"]
  node_modify_tables["Modify tables"]
end

subgraph group_analysis["Market Analysis"]
  node_paying_jobs["Top-paying jobs"]
  node_paying_skills["Skills for top jobs"]
  node_demanded_skills["In-demand skills"]
  node_highest_skills["Highest-paying skills"]
  node_optimal_skills["Optimal skills"]
end

node_analyst(("Career researcher"))
node_dataset["Job postings data"]
node_db[("PostgreSQL database")]

node_analyst -->|"prepares schema"| node_create_db
node_create_db -->|"creates"| node_db
node_analyst -->|"prepares schema"| node_create_tables
node_create_tables -->|"creates tables"| node_db
node_analyst -->|"updates schema"| node_modify_tables
node_modify_tables -->|"alters tables"| node_db
node_analyst -->|"runs analysis"| node_paying_jobs
node_paying_jobs -->|"queries"| node_db
node_analyst -->|"runs analysis"| node_paying_skills
node_paying_skills -->|"queries"| node_db
node_analyst -->|"runs analysis"| node_demanded_skills
node_demanded_skills -->|"queries"| node_db
node_analyst -->|"runs analysis"| node_highest_skills
node_highest_skills -->|"queries"| node_db
node_analyst -->|"runs analysis"| node_optimal_skills
node_optimal_skills -->|"queries"| node_db

click node_create_db "https://github.com/aritro19g/sql_project_data_jobs/blob/main/sql_load/1_create_database.sql"
click node_create_tables "https://github.com/aritro19g/sql_project_data_jobs/blob/main/sql_load/2_create_tables.sql"
click node_modify_tables "https://github.com/aritro19g/sql_project_data_jobs/blob/main/sql_load/3_modify_tables.sql"
click node_paying_jobs "https://github.com/aritro19g/sql_project_data_jobs/blob/main/project_sql/1_top_paying_jobs.sql"
click node_paying_skills "https://github.com/aritro19g/sql_project_data_jobs/blob/main/project_sql/2_top_paying_job_skills.sql"
click node_demanded_skills "https://github.com/aritro19g/sql_project_data_jobs/blob/main/project_sql/3_top_demanded_skills.sql"
click node_highest_skills "https://github.com/aritro19g/sql_project_data_jobs/blob/main/project_sql/4_top_paying_skils.sql"
click node_optimal_skills "https://github.com/aritro19g/sql_project_data_jobs/blob/main/project_sql/5_optimal_skills.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_create_db,node_create_tables,node_modify_tables toneBlue
class node_paying_jobs,node_paying_skills,node_demanded_skills,node_highest_skills,node_optimal_skills,node_db toneAmber
class node_analyst,node_dataset toneIndigo
```

## Components

### Database Setup

- [Create database](https://github.com/aritro19g/sql_project_data_jobs/blob/main/sql_load/1_create_database.sql): `sql_load/1_create_database.sql`
- [Create tables](https://github.com/aritro19g/sql_project_data_jobs/blob/main/sql_load/2_create_tables.sql): `sql_load/2_create_tables.sql`
- [Modify tables](https://github.com/aritro19g/sql_project_data_jobs/blob/main/sql_load/3_modify_tables.sql): `sql_load/3_modify_tables.sql`

### Market Analysis

- [Top-paying jobs](https://github.com/aritro19g/sql_project_data_jobs/blob/main/project_sql/1_top_paying_jobs.sql): `project_sql/1_top_paying_jobs.sql`
- [Skills for top jobs](https://github.com/aritro19g/sql_project_data_jobs/blob/main/project_sql/2_top_paying_job_skills.sql): `project_sql/2_top_paying_job_skills.sql`
- [In-demand skills](https://github.com/aritro19g/sql_project_data_jobs/blob/main/project_sql/3_top_demanded_skills.sql): `project_sql/3_top_demanded_skills.sql`
- [Highest-paying skills](https://github.com/aritro19g/sql_project_data_jobs/blob/main/project_sql/4_top_paying_skils.sql): `project_sql/4_top_paying_skils.sql`
- [Optimal skills](https://github.com/aritro19g/sql_project_data_jobs/blob/main/project_sql/5_optimal_skills.sql): `project_sql/5_optimal_skills.sql`

### Other components

- **Career researcher**
- **Job postings data**
- **PostgreSQL database**

## Connections

- Career researcher → Create database: prepares schema
- Create database → PostgreSQL database: creates
- Career researcher → Create tables: prepares schema
- Create tables → PostgreSQL database: creates tables
- Career researcher → Modify tables: updates schema
- Modify tables → PostgreSQL database: alters tables
- Career researcher → Top-paying jobs: runs analysis
- Top-paying jobs → PostgreSQL database: queries
- Career researcher → Skills for top jobs: runs analysis
- Skills for top jobs → PostgreSQL database: queries
- Career researcher → In-demand skills: runs analysis
- In-demand skills → PostgreSQL database: queries
- Career researcher → Highest-paying skills: runs analysis
- Highest-paying skills → PostgreSQL database: queries
- Career researcher → Optimal skills: runs analysis
- Optimal skills → PostgreSQL database: queries