# nkosinathi-m/sql-projects architecture

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

- Interactive diagram: https://gitdiagram.com/nkosinathi-m/sql-projects
- Repository: https://github.com/nkosinathi-m/sql-projects

## Overview

This repository is a learning portfolio, not an executable application. Its documented user journey is to practise SQL, study database design, and review the Student Management System project. The student project combines design guidance, SQL artifacts, and explanatory documentation; the tree shows only table creation and sample-data scripts, so other SQL capabilities mentioned in the README are not represented as files. Relationships below reflect the README’s project descriptions, not runtime calls; no source excerpts were available.

Main entry points: [`Main/Student-Management-System/README.md`](https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Student-Management-System/README.md) (Project Guide), [`Main/SQL-Fundamentals/README.md`](https://github.com/nkosinathi-m/sql-projects/blob/main/Main/SQL-Fundamentals/README.md) (SQL Fundamentals Guide), [`Main/Database-Design-Excercises/README.md`](https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Database-Design-Excercises/README.md) (Design Exercises Guide), [`README.md`](https://github.com/nkosinathi-m/sql-projects/blob/main/README.md) (Portfolio Overview)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_student["Student Database"]
  node_student_readme["Project Guide<br/>[README.md]"]
  node_design_rules["Business Rules<br/>[business-rules.md]"]
  node_entities["Entities &amp; Attributes"]
  node_normalization["Normalization<br/>[normalization.md]"]
  node_erd["ER Diagram"]
  node_table_sql["Table Definitions"]
  node_sample_sql["Sample Data"]
  node_db_docs["Database Documentation"]
end

subgraph group_fundamentals["SQL Practice"]
  node_sql_fundamentals["SQL Fundamentals Guide<br/>[README.md]"]
end

subgraph group_design["Design Practice"]
  node_design_exercises["Design Exercises Guide<br/>[README.md]"]
end

node_learner(("Learner"))
node_portfolio["Portfolio Overview<br/>[README.md]"]

node_learner -->|"explores"| node_portfolio
node_learner -->|"studies"| node_student_readme
node_learner -->|"practises SQL"| node_sql_fundamentals
node_learner -->|"practises design"| node_design_exercises

click node_portfolio "https://github.com/nkosinathi-m/sql-projects/blob/main/README.md"
click node_student_readme "https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Student-Management-System/README.md"
click node_design_rules "https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Student-Management-System/Database-Design/business-rules.md"
click node_entities "https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Student-Management-System/Database-Design/entities-and-attributes.md"
click node_normalization "https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Student-Management-System/Database-Design/normalization.md"
click node_erd "https://github.com/nkosinathi-m/sql-projects/tree/main/Main/Student-Management-System/ERD"
click node_table_sql "https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Student-Management-System/SQL/02-create-tables.sql"
click node_sample_sql "https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Student-Management-System/SQL/04-insert-sample-data.sql"
click node_db_docs "https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Student-Management-System/Documentation/database-documentation.md"
click node_sql_fundamentals "https://github.com/nkosinathi-m/sql-projects/blob/main/Main/SQL-Fundamentals/README.md"
click node_design_exercises "https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Database-Design-Excercises/README.md"

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_student_readme,node_design_rules,node_entities,node_normalization,node_erd,node_table_sql,node_sample_sql,node_db_docs,node_portfolio toneBlue
class node_sql_fundamentals toneAmber
class node_design_exercises toneMint
class node_learner toneIndigo
```

## Components

### Student Database

- [Project Guide](https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Student-Management-System/README.md): `Main/Student-Management-System/README.md`
- [Business Rules](https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Student-Management-System/Database-Design/business-rules.md): `Main/Student-Management-System/Database-Design/business-rules.md`
- [Entities & Attributes](https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Student-Management-System/Database-Design/entities-and-attributes.md): `Main/Student-Management-System/Database-Design/entities-and-attributes.md`
- [Normalization](https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Student-Management-System/Database-Design/normalization.md): `Main/Student-Management-System/Database-Design/normalization.md`
- [ER Diagram](https://github.com/nkosinathi-m/sql-projects/tree/main/Main/Student-Management-System/ERD): `Main/Student-Management-System/ERD`
- [Table Definitions](https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Student-Management-System/SQL/02-create-tables.sql): `Main/Student-Management-System/SQL/02-create-tables.sql`
- [Sample Data](https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Student-Management-System/SQL/04-insert-sample-data.sql): `Main/Student-Management-System/SQL/04-insert-sample-data.sql`
- [Database Documentation](https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Student-Management-System/Documentation/database-documentation.md): `Main/Student-Management-System/Documentation/database-documentation.md`

### SQL Practice

- [SQL Fundamentals Guide](https://github.com/nkosinathi-m/sql-projects/blob/main/Main/SQL-Fundamentals/README.md): `Main/SQL-Fundamentals/README.md`

### Design Practice

- [Design Exercises Guide](https://github.com/nkosinathi-m/sql-projects/blob/main/Main/Database-Design-Excercises/README.md): `Main/Database-Design-Excercises/README.md`

### Other components

- **Learner**
- [Portfolio Overview](https://github.com/nkosinathi-m/sql-projects/blob/main/README.md): `README.md`

## Connections

- Learner → Portfolio Overview: explores (evidence: `README.md`)
- Learner → Project Guide: studies (evidence: `README.md`)
- Learner → SQL Fundamentals Guide: practises SQL (evidence: `README.md`)
- Learner → Design Exercises Guide: practises design (evidence: `README.md`)
