# karanmallik65/sql_project_data_job_analysis architecture

> Architecture diagram of the GitHub repository karanmallik65/sql_project_data_job_analysis, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-10-31). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/karanmallik65/sql_project_data_job_analysis
- Repository: https://github.com/karanmallik65/sql_project_data_job_analysis

## Overview

##### Project type and purpose
- This is a data-analysis project built entirely around SQL scripts. There is no “application server” or UI code—rather it’s a repository of database-definition, table-creation, ETL, and exploratory query scripts plus generated visualization assets (PNG graphs).
- Its purpose is to load job-posting data into PostgreSQL, run a series of analytical queries to answer questions about salaries and in-demand skills, then produce charts and tables for reporting.

##### File structure
- Top-level files:
- .gitignore, README.md
- assets/ (contains output images)
- Two SQL script directories:
- sql_load/: database bootstrap and schema-modification scripts in execution order
- project_sql/: analytical queries (1_top_paying_jobs.sql … 5_optimal_skills.sql)
- There are no application code files, no frontend or backend folders—this is purely a data pipeline and analysis pipeline.

##### README for additional insights
- It describes five business questions, the stack (PostgreSQL, SQL, VSCode, GitHub) and shows sample queries and visuals.

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% Repository & Documentation
    subgraph "Repository & Documentation"
        README["README.md"]:::repo
        GIT[".gitignore"]:::repo
    end

    %% Local Development Environment
    Dev["Local Development Environment\n(VSCode + Git/GitHub)"]:::repo

    %% ETL Pipeline
    subgraph "SQL-Load Pipeline" 
        SQLLoad["SQL-Load Pipeline"]:::etl
        CreateDB["1_create_database.sql"]:::etl
        CreateTables["2_create_tables.sql"]:::etl
        ModifyTables["3_modify_tables.sql"]:::etl
    end

    %% Database
    DB["(PostgreSQL Database)"]:::db

    %% Analytical Pipeline
    subgraph "Analytical Query Pipeline"
        ProjectSQL["Analytical Query Pipeline"]:::analysis
        TopPayingJobs["1_top_paying_jobs.sql"]:::analysis
        TopJobSkills["2_top_paying_job_skills.sql"]:::analysis
        TopDemandSkills["3_top_demanded_skills.sql"]:::analysis
        TopPaySkills["4_top_paying_skills.sql"]:::analysis
        OptimalSkills["5_optimal_skills.sql"]:::analysis
    end

    %% Assets
    Assets["Visualization/Reporting Assets"]:::assets

    %% Connections
    README --> Dev
    GIT --> Dev
    Dev --> SQLLoad
    SQLLoad --> CreateDB
    CreateDB --> CreateTables
    CreateTables --> ModifyTables
    ModifyTables --> DB
    DB --> TopPayingJobs
    TopPayingJobs --> TopJobSkills
    TopJobSkills --> TopDemandSkills
    TopDemandSkills --> TopPaySkills
    TopPaySkills --> OptimalSkills
    OptimalSkills --> Assets

    %% Click Events
    click README "https://github.com/karanmallik65/sql_project_data_job_analysis/blob/main/README.md"
    click GIT "https://github.com/karanmallik65/sql_project_data_job_analysis/blob/main/.gitignore"
    click SQLLoad "https://github.com/karanmallik65/sql_project_data_job_analysis/tree/main/sql_load/"
    click CreateDB "https://github.com/karanmallik65/sql_project_data_job_analysis/blob/main/sql_load/1_create_database.sql"
    click CreateTables "https://github.com/karanmallik65/sql_project_data_job_analysis/blob/main/sql_load/2_create_tables.sql"
    click ModifyTables "https://github.com/karanmallik65/sql_project_data_job_analysis/blob/main/sql_load/3_modify_tables.sql"
    click ProjectSQL "https://github.com/karanmallik65/sql_project_data_job_analysis/tree/main/project_sql/"
    click TopPayingJobs "https://github.com/karanmallik65/sql_project_data_job_analysis/blob/main/project_sql/1_top_paying_jobs.sql"
    click TopJobSkills "https://github.com/karanmallik65/sql_project_data_job_analysis/blob/main/project_sql/2_top_paying_job_skills.sql"
    click TopDemandSkills "https://github.com/karanmallik65/sql_project_data_job_analysis/blob/main/project_sql/3_top_demanded_skills.sql"
    click TopPaySkills "https://github.com/karanmallik65/sql_project_data_job_analysis/blob/main/project_sql/4_top_paying_skills.sql"
    click OptimalSkills "https://github.com/karanmallik65/sql_project_data_job_analysis/blob/main/project_sql/5_optimal_skills.sql"
    click Assets "https://github.com/karanmallik65/sql_project_data_job_analysis/tree/main/assets/"

    %% Styles
    classDef etl fill:#bae1ff,stroke:#1f77b4,color:#000
    classDef analysis fill:#baffc9,stroke:#2ca02c,color:#000
    classDef db fill:#ffd1dc,stroke:#d62728,color:#000
    classDef repo fill:#ffffba,stroke:#ff7f0e,color:#000
    classDef assets fill:#ffdfba,stroke:#9467bd,color:#000
```
