# madfixisme/databasetechnologies architecture

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

- Interactive diagram: https://gitdiagram.com/madfixisme/databasetechnologies
- Repository: https://github.com/madfixisme/databasetechnologies

## Overview

This repository contains SQL setup/query scripts and CSV datasets for two apparent database exercises: a Datacrafting Lab sales dataset and a Superstore dataset. With no README or source excerpts, their exact schemas, query behavior, and data flow cannot be verified, so the graph shows only the available product assets and makes no unsupported execution or import claims.

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_datacraftinglab["Datacrafting Lab"]
  node_dcl_setup["Database setup<br/>[database_setup.sql]"]
  node_dcl_queries["Database queries"]
  node_sales_csv["Sales dataset"]
end

subgraph group_superstore["Superstore"]
  node_ss_setup["Database setup<br/>[database_setup.sql]"]
  node_ss_queries["Database queries"]
  node_customers["Customers data<br/>[customers.csv]"]
  node_orders["Orders data<br/>[orders.csv]"]
  node_products["Products data<br/>[products.csv]"]
end

node_exercise_sql["SQL exercise<br/>[cvicenie_1.sql]"]

click node_dcl_setup "https://github.com/madfixisme/databasetechnologies/blob/master/datacraftinglab_db/database_setup.sql"
click node_dcl_queries "https://github.com/madfixisme/databasetechnologies/blob/master/datacraftinglab_db/database_queries.sql"
click node_sales_csv "https://github.com/madfixisme/databasetechnologies/blob/master/datacraftinglab_db/csv/FlourMills_Sales_2022_2024.csv"
click node_ss_setup "https://github.com/madfixisme/databasetechnologies/blob/master/superstore/database_setup.sql"
click node_ss_queries "https://github.com/madfixisme/databasetechnologies/blob/master/superstore/database_queries.sql"
click node_customers "https://github.com/madfixisme/databasetechnologies/blob/master/superstore/csv_files/customers.csv"
click node_orders "https://github.com/madfixisme/databasetechnologies/blob/master/superstore/csv_files/orders.csv"
click node_products "https://github.com/madfixisme/databasetechnologies/blob/master/superstore/csv_files/products.csv"
click node_exercise_sql "https://github.com/madfixisme/databasetechnologies/blob/master/cvicenie_1.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_dcl_setup,node_dcl_queries,node_sales_csv toneBlue
class node_ss_setup,node_ss_queries,node_customers,node_orders,node_products toneAmber
class node_exercise_sql toneTeal
```

## Components

### Datacrafting Lab

- [Database setup](https://github.com/madfixisme/databasetechnologies/blob/master/datacraftinglab_db/database_setup.sql): `datacraftinglab_db/database_setup.sql`
- [Database queries](https://github.com/madfixisme/databasetechnologies/blob/master/datacraftinglab_db/database_queries.sql): `datacraftinglab_db/database_queries.sql`
- [Sales dataset](https://github.com/madfixisme/databasetechnologies/blob/master/datacraftinglab_db/csv/FlourMills_Sales_2022_2024.csv): `datacraftinglab_db/csv/FlourMills_Sales_2022_2024.csv`

### Superstore

- [Database setup](https://github.com/madfixisme/databasetechnologies/blob/master/superstore/database_setup.sql): `superstore/database_setup.sql`
- [Database queries](https://github.com/madfixisme/databasetechnologies/blob/master/superstore/database_queries.sql): `superstore/database_queries.sql`
- [Customers data](https://github.com/madfixisme/databasetechnologies/blob/master/superstore/csv_files/customers.csv): `superstore/csv_files/customers.csv`
- [Orders data](https://github.com/madfixisme/databasetechnologies/blob/master/superstore/csv_files/orders.csv): `superstore/csv_files/orders.csv`
- [Products data](https://github.com/madfixisme/databasetechnologies/blob/master/superstore/csv_files/products.csv): `superstore/csv_files/products.csv`

### Other components

- [SQL exercise](https://github.com/madfixisme/databasetechnologies/blob/master/cvicenie_1.sql): `cvicenie_1.sql`
