# bil004/progettodb architecture

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

- Interactive diagram: https://gitdiagram.com/bil004/progettodb
- Repository: https://github.com/bil004/progettodb

## Overview

This repository is a relational database project for managing national parks, not a running visitor application. Its documented workflow is to create the schema, optionally populate it, then run example analysis queries. The model covers park administration, tourism, recreation, visitor services, users, bookings, and feedback. The README documents these capabilities and script roles; source excerpts were unavailable, so links between domain areas are not inferred.

Main entry points: [`Schema/Schema_Relazionale.md`](https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md) (National parks database), [`SQL/scriptProject.sql`](https://github.com/bil004/progettodb/blob/main/SQL/scriptProject.sql) (Schema DDL), [`SQL/dataProject.sql`](https://github.com/bil004/progettodb/blob/main/SQL/dataProject.sql) (Sample data), [`SQL/testQueryProject.sql`](https://github.com/bil004/progettodb/blob/main/SQL/testQueryProject.sql) (Example queries)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_territory["Parks & Territory"]
  node_parks["Parks & territories"]
  node_administration["Park administration"]
end

subgraph group_tourism["Tourism & Recreation"]
  node_accommodation["Accommodation"]
  node_trails["Trails & tours"]
  node_guides["Tour guides"]
end

subgraph group_services["Visitor Services"]
  node_visitor_centers["Visitor centers"]
  node_news["Park news"]
end

subgraph group_interaction["Users & Bookings"]
  node_users["Visitor profiles"]
  node_bookings["Reservations"]
  node_feedback["Trail reviews"]
end

node_operator(("Database operator"))
node_schema_script["Schema DDL<br/>[scriptProject.sql]"]
node_sample_script["Sample data<br/>[dataProject.sql]"]
node_query_script["Example queries"]
node_database[("National parks database")]

node_operator -->|"runs"| node_schema_script
node_schema_script -->|"creates schema"| node_database
node_operator -.->|"optionally runs"| node_sample_script
node_sample_script -.->|"inserts sample data"| node_database
node_operator -->|"runs"| node_query_script
node_query_script -->|"queries"| node_database

click node_schema_script "https://github.com/bil004/progettodb/blob/main/SQL/scriptProject.sql"
click node_sample_script "https://github.com/bil004/progettodb/blob/main/SQL/dataProject.sql"
click node_query_script "https://github.com/bil004/progettodb/blob/main/SQL/testQueryProject.sql"
click node_database "https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md"
click node_parks "https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md"
click node_administration "https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md"
click node_accommodation "https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md"
click node_trails "https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md"
click node_guides "https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md"
click node_visitor_centers "https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md"
click node_news "https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md"
click node_users "https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md"
click node_bookings "https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md"
click node_feedback "https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.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_parks,node_administration toneBlue
class node_accommodation,node_trails,node_guides,node_operator,node_database toneAmber
class node_visitor_centers,node_news toneMint
class node_users,node_bookings,node_feedback toneRose
class node_schema_script,node_sample_script,node_query_script toneTeal
```

## Components

### Parks & Territory

- [Parks & territories](https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md): `Schema/Schema_Relazionale.md`
- [Park administration](https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md): `Schema/Schema_Relazionale.md`

### Tourism & Recreation

- [Accommodation](https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md): `Schema/Schema_Relazionale.md`
- [Trails & tours](https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md): `Schema/Schema_Relazionale.md`
- [Tour guides](https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md): `Schema/Schema_Relazionale.md`

### Visitor Services

- [Visitor centers](https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md): `Schema/Schema_Relazionale.md`
- [Park news](https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md): `Schema/Schema_Relazionale.md`

### Users & Bookings

- [Visitor profiles](https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md): `Schema/Schema_Relazionale.md`
- [Reservations](https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md): `Schema/Schema_Relazionale.md`
- [Trail reviews](https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md): `Schema/Schema_Relazionale.md`

### Other components

- **Database operator**
- [Schema DDL](https://github.com/bil004/progettodb/blob/main/SQL/scriptProject.sql): `SQL/scriptProject.sql`
- [Sample data](https://github.com/bil004/progettodb/blob/main/SQL/dataProject.sql): `SQL/dataProject.sql`
- [Example queries](https://github.com/bil004/progettodb/blob/main/SQL/testQueryProject.sql): `SQL/testQueryProject.sql`
- [National parks database](https://github.com/bil004/progettodb/blob/main/Schema/Schema_Relazionale.md): `Schema/Schema_Relazionale.md`

## Connections

- Database operator → Schema DDL: runs
- Schema DDL → National parks database: creates schema
- Database operator → Sample data: optionally runs
- Sample data → National parks database: inserts sample data
- Database operator → Example queries: runs
- Example queries → National parks database: queries