# kego-mashigo/school-report-etl architecture

> Architecture diagram of the GitHub repository kego-mashigo/school-report-etl, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-05). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/kego-mashigo/school-report-etl
- Repository: https://github.com/kego-mashigo/school-report-etl

## Overview

This repository is identified as a school-report ETL for grades 10–12 at Kathu College. The tree contains a CSV dataset and SQL files named for database creation and staging/silver tables, but no source excerpts document how they are run or connected. The graph therefore lists these assets without asserting a workflow or data flow.

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Report data"]
  node_marks_csv["Student marks"]
end

subgraph group_sql["SQL assets"]
  node_createdb["Database creation<br/>[01_createdDb.sql]"]
  node_schema_sql["Database schema"]
  node_staging_sql["Staging tables"]
  node_silver_sql["Silver tables"]
end

click node_marks_csv "https://github.com/kego-mashigo/school-report-etl/blob/main/Raw%20Data/prelim_science_students_marks.csv"
click node_createdb "https://github.com/kego-mashigo/school-report-etl/blob/main/01_createdDb.sql"
click node_schema_sql "https://github.com/kego-mashigo/school-report-etl/blob/main/001_createdb_schema.sql"
click node_staging_sql "https://github.com/kego-mashigo/school-report-etl/blob/main/002_create_stg_tables.sql"
click node_silver_sql "https://github.com/kego-mashigo/school-report-etl/blob/main/003_create_silver_tables.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_marks_csv toneBlue
class node_createdb,node_schema_sql,node_staging_sql,node_silver_sql toneAmber
```

## Components

### Report data

- [Student marks](https://github.com/kego-mashigo/school-report-etl/blob/main/Raw%20Data/prelim_science_students_marks.csv): `Raw Data/prelim_science_students_marks.csv`

### SQL assets

- [Database creation](https://github.com/kego-mashigo/school-report-etl/blob/main/01_createdDb.sql): `01_createdDb.sql`
- [Database schema](https://github.com/kego-mashigo/school-report-etl/blob/main/001_createdb_schema.sql): `001_createdb_schema.sql`
- [Staging tables](https://github.com/kego-mashigo/school-report-etl/blob/main/002_create_stg_tables.sql): `002_create_stg_tables.sql`
- [Silver tables](https://github.com/kego-mashigo/school-report-etl/blob/main/003_create_silver_tables.sql): `003_create_silver_tables.sql`
