# joaquizoe/music-database architecture

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

- Interactive diagram: https://gitdiagram.com/joaquizoe/music-database
- Repository: https://github.com/joaquizoe/music-database

## Overview

This repository is a CSC 370 music-database project, represented by SQL scripts and data files rather than an application with a visible runtime workflow. The filenames suggest schema/query work, music and Spotify datasets, and review/comment data. No SQL excerpts or documented relationships were provided, so the graph does not infer execution order, tables, or data flow.

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_sql_work["SQL Project"]
  node_codesprint["CodeSprint SQL<br/>[CodeSprint2.sql]"]
  node_project_sql["Project SQL<br/>[Project1.sql]"]
  node_queries["Create Queries<br/>[create_queries.sql]"]
  node_ternarylogic["Ternary Logic<br/>[ternarylogic.sql]"]
end

subgraph group_music_data["Music Data"]
  node_music_10k["Music Dataset"]
  node_spotify_users["Spotify Ratings"]
  node_featured_artists["Featured Artists"]
end

subgraph group_review_data["Reviews Data"]
  node_review_comments["Review Comments SQL"]
  node_review_data["Review Comments Data"]
  node_spotify_reviews["Spotify Reviews Data"]
end

click node_codesprint "https://github.com/joaquizoe/music-database/blob/main/CodeSprint2.sql"
click node_project_sql "https://github.com/joaquizoe/music-database/blob/main/Project1.sql"
click node_queries "https://github.com/joaquizoe/music-database/blob/main/create_queries.sql"
click node_ternarylogic "https://github.com/joaquizoe/music-database/blob/main/ternarylogic.sql"
click node_music_10k "https://github.com/joaquizoe/music-database/blob/main/music_database_10k.sql"
click node_spotify_users "https://github.com/joaquizoe/music-database/blob/main/spotify_5000_users_ratings.sql"
click node_featured_artists "https://github.com/joaquizoe/music-database/blob/main/spotify_5000_with_featured_artists_artist_name.sql"
click node_review_comments "https://github.com/joaquizoe/music-database/blob/main/create_review_and_comments.sql"
click node_review_data "https://github.com/joaquizoe/music-database/blob/main/music_reviews_comments_1500_3000.sql"
click node_spotify_reviews "https://github.com/joaquizoe/music-database/blob/main/spotify_5000_users_ratings.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_codesprint,node_project_sql,node_queries,node_ternarylogic toneBlue
class node_music_10k,node_spotify_users,node_featured_artists toneAmber
class node_review_comments,node_review_data,node_spotify_reviews toneMint
```

## Components

### SQL Project

- [CodeSprint SQL](https://github.com/joaquizoe/music-database/blob/main/CodeSprint2.sql): `CodeSprint2.sql`
- [Project SQL](https://github.com/joaquizoe/music-database/blob/main/Project1.sql): `Project1.sql`
- [Create Queries](https://github.com/joaquizoe/music-database/blob/main/create_queries.sql): `create_queries.sql`
- [Ternary Logic](https://github.com/joaquizoe/music-database/blob/main/ternarylogic.sql): `ternarylogic.sql`

### Music Data

- [Music Dataset](https://github.com/joaquizoe/music-database/blob/main/music_database_10k.sql): `music_database_10k.sql`
- [Spotify Ratings](https://github.com/joaquizoe/music-database/blob/main/spotify_5000_users_ratings.sql): `spotify_5000_users_ratings.sql`
- [Featured Artists](https://github.com/joaquizoe/music-database/blob/main/spotify_5000_with_featured_artists_artist_name.sql): `spotify_5000_with_featured_artists_artist_name.sql`

### Reviews Data

- [Review Comments SQL](https://github.com/joaquizoe/music-database/blob/main/create_review_and_comments.sql): `create_review_and_comments.sql`
- [Review Comments Data](https://github.com/joaquizoe/music-database/blob/main/music_reviews_comments_1500_3000.sql): `music_reviews_comments_1500_3000.sql`
- [Spotify Reviews Data](https://github.com/joaquizoe/music-database/blob/main/spotify_5000_users_ratings.sql): `spotify_5000_users_ratings.sql`
