# zheniatrochun/db-intro-course architecture

> Architecture diagram of the GitHub repository zheniatrochun/db-intro-course, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-06). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/zheniatrochun/db-intro-course
- Repository: https://github.com/zheniatrochun/db-intro-course

## Overview

This repository is a database-course resource set with a documented Docker-based PostgreSQL and pgAdmin environment. The principal learner workflow is to study lecture materials, complete labs and SQL exercises, then use the database environment for practice. The map includes the documented course stages and environment; because no source excerpts were provided, relationships are limited to those stated in the README.

Main entry points: [`docker-compose.yml`](https://github.com/zheniatrochun/db-intro-course/blob/master/docker-compose.yml) (Compose environment), [`lectures`](https://github.com/zheniatrochun/db-intro-course/tree/master/lectures) (Lectures), [`labs`](https://github.com/zheniatrochun/db-intro-course/tree/master/labs) (Laboratories), [`exercises`](https://github.com/zheniatrochun/db-intro-course/tree/master/exercises) (SQL exercises)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_learning["Course materials"]
  node_lectures["Lectures"]
end

subgraph group_practice["Hands-on work"]
  node_labs["Laboratories"]
  node_sql_exercises["SQL exercises"]
  node_campus_schema["Campus schema"]
  node_sql_examples["SQL examples"]
end

subgraph group_environment["Database environment"]
  node_compose["Compose environment<br/>[docker-compose.yml]"]
  node_postgres[("PostgreSQL")]
  node_pgadmin["pgAdmin"]
end

subgraph group_reference["Quick reference"]
  node_glossary["Glossary<br/>[glossary.md]"]
  node_cheat_sheet["SQL cheat sheet<br/>[sql-cheat-sheet.md]"]
end

node_learner(("Learner"))

node_learner -->|"studies"| node_lectures
node_learner -->|"completes"| node_labs
node_learner -->|"practices SQL"| node_sql_exercises
node_learner -->|"references"| node_glossary
node_learner -->|"references"| node_cheat_sheet
node_learner -->|"starts environment"| node_compose
node_compose -->|"starts service"| node_postgres
node_compose -->|"starts service"| node_pgadmin
node_learner -->|"manages database"| node_pgadmin
node_pgadmin -->|"connects to"| node_postgres

click node_lectures "https://github.com/zheniatrochun/db-intro-course/tree/master/lectures"
click node_labs "https://github.com/zheniatrochun/db-intro-course/tree/master/labs"
click node_sql_exercises "https://github.com/zheniatrochun/db-intro-course/tree/master/exercises"
click node_campus_schema "https://github.com/zheniatrochun/db-intro-course/blob/master/scripts/create-campus-tables.sql"
click node_sql_examples "https://github.com/zheniatrochun/db-intro-course/tree/master/scripts"
click node_glossary "https://github.com/zheniatrochun/db-intro-course/blob/master/glossary.md"
click node_cheat_sheet "https://github.com/zheniatrochun/db-intro-course/blob/master/sql-cheat-sheet.md"
click node_compose "https://github.com/zheniatrochun/db-intro-course/blob/master/docker-compose.yml"

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_lectures toneBlue
class node_labs,node_sql_exercises,node_campus_schema,node_sql_examples toneAmber
class node_compose,node_postgres,node_pgadmin toneMint
class node_glossary,node_cheat_sheet toneRose
class node_learner toneIndigo
```

## Components

### Course materials

- [Lectures](https://github.com/zheniatrochun/db-intro-course/tree/master/lectures): `lectures`

### Hands-on work

- [Laboratories](https://github.com/zheniatrochun/db-intro-course/tree/master/labs): `labs`
- [SQL exercises](https://github.com/zheniatrochun/db-intro-course/tree/master/exercises): `exercises`
- [Campus schema](https://github.com/zheniatrochun/db-intro-course/blob/master/scripts/create-campus-tables.sql): `scripts/create-campus-tables.sql`
- [SQL examples](https://github.com/zheniatrochun/db-intro-course/tree/master/scripts): `scripts`

### Database environment

- [Compose environment](https://github.com/zheniatrochun/db-intro-course/blob/master/docker-compose.yml): `docker-compose.yml`
- **PostgreSQL**
- **pgAdmin**

### Quick reference

- [Glossary](https://github.com/zheniatrochun/db-intro-course/blob/master/glossary.md): `glossary.md`
- [SQL cheat sheet](https://github.com/zheniatrochun/db-intro-course/blob/master/sql-cheat-sheet.md): `sql-cheat-sheet.md`

### Other components

- **Learner**

## Connections

- Learner → Lectures: studies (evidence: `README.md`)
- Learner → Laboratories: completes (evidence: `README.md`)
- Learner → SQL exercises: practices SQL (evidence: `README.md`)
- Learner → Glossary: references (evidence: `README.md`)
- Learner → SQL cheat sheet: references (evidence: `README.md`)
- Learner → Compose environment: starts environment (evidence: `README.md`)
- Compose environment → PostgreSQL: starts service (evidence: `README.md`)
- Compose environment → pgAdmin: starts service (evidence: `README.md`)
- Learner → pgAdmin: manages database (evidence: `README.md`)
- pgAdmin → PostgreSQL: connects to (evidence: `README.md`)
