# sebastianwin01/cis3400-gym-database architecture

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

- Interactive diagram: https://gitdiagram.com/sebastianwin01/cis3400-gym-database
- Repository: https://github.com/sebastianwin01/cis3400-gym-database

## Overview

This is a coursework project for designing and analyzing a MySQL database for a multi-location gym, not a running gym-management application. Its documented workflow moves from business requirements through entity and schema design to SQL implementation and business analysis. The README describes six core tables and five analytical questions, but the supplied tree contains no SQL scripts or source excerpts, so the graph reflects documented scope rather than verified runtime behavior.

Main entry points: [`docs/02_entities_and_attributes.md`](https://github.com/sebastianwin01/cis3400-gym-database/blob/main/docs/02_entities_and_attributes.md) (Entities and fields), [`docs/03_database_design.md`](https://github.com/sebastianwin01/cis3400-gym-database/blob/main/docs/03_database_design.md) (Database design), [`README.md`](https://github.com/sebastianwin01/cis3400-gym-database/blob/main/README.md) (Business questions), [`docs/01_Business_Requirements.md`](https://github.com/sebastianwin01/cis3400-gym-database/blob/main/docs/01_Business_Requirements.md) (Gym requirements)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_planning["Business planning"]
  node_requirements["Gym requirements"]
end

subgraph group_schema["Data design"]
  node_entities["Entities and fields"]
  node_database_design["Database design"]
  node_normalization["Normalization"]
  node_implementation["MySQL implementation"]
  node_gym_schema[("Six-table schema")]
end

subgraph group_analysis["SQL analysis"]
  node_analysis["Business questions<br/>[README.md]"]
  node_results["Attendance and revenue insights<br/>[README.md]"]
end

node_analyst(("Business analyst"))

node_requirements -->|"defines entities"| node_entities
node_entities -->|"informs design"| node_database_design
node_database_design -->|"guides review"| node_normalization
node_database_design -->|"guides creation"| node_implementation
node_entities -->|"specifies tables"| node_gym_schema
node_analyst -->|"poses questions"| node_analysis
node_analysis -->|"queries tables"| node_gym_schema
node_analysis -->|"summarizes findings"| node_results

click node_requirements "https://github.com/sebastianwin01/cis3400-gym-database/blob/main/docs/01_Business_Requirements.md"
click node_entities "https://github.com/sebastianwin01/cis3400-gym-database/blob/main/docs/02_entities_and_attributes.md"
click node_database_design "https://github.com/sebastianwin01/cis3400-gym-database/blob/main/docs/03_database_design.md"
click node_normalization "https://github.com/sebastianwin01/cis3400-gym-database/blob/main/docs/04_normalization.md"
click node_implementation "https://github.com/sebastianwin01/cis3400-gym-database/blob/main/docs/05_database_implementation.md"
click node_gym_schema "https://github.com/sebastianwin01/cis3400-gym-database/blob/main/docs/02_entities_and_attributes.md"
click node_analysis "https://github.com/sebastianwin01/cis3400-gym-database/blob/main/README.md"
click node_results "https://github.com/sebastianwin01/cis3400-gym-database/blob/main/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_requirements toneBlue
class node_entities,node_database_design,node_normalization,node_implementation,node_gym_schema toneAmber
class node_analysis,node_results toneMint
class node_analyst toneIndigo
```

## Components

### Business planning

- [Gym requirements](https://github.com/sebastianwin01/cis3400-gym-database/blob/main/docs/01_Business_Requirements.md): `docs/01_Business_Requirements.md`

### Data design

- [Entities and fields](https://github.com/sebastianwin01/cis3400-gym-database/blob/main/docs/02_entities_and_attributes.md): `docs/02_entities_and_attributes.md`
- [Database design](https://github.com/sebastianwin01/cis3400-gym-database/blob/main/docs/03_database_design.md): `docs/03_database_design.md`
- [Normalization](https://github.com/sebastianwin01/cis3400-gym-database/blob/main/docs/04_normalization.md): `docs/04_normalization.md`
- [MySQL implementation](https://github.com/sebastianwin01/cis3400-gym-database/blob/main/docs/05_database_implementation.md): `docs/05_database_implementation.md`
- [Six-table schema](https://github.com/sebastianwin01/cis3400-gym-database/blob/main/docs/02_entities_and_attributes.md): `docs/02_entities_and_attributes.md`

### SQL analysis

- [Business questions](https://github.com/sebastianwin01/cis3400-gym-database/blob/main/README.md): `README.md`
- [Attendance and revenue insights](https://github.com/sebastianwin01/cis3400-gym-database/blob/main/README.md): `README.md`

### Other components

- **Business analyst**

## Connections

- Gym requirements → Entities and fields: defines entities (evidence: `README.md`)
- Entities and fields → Database design: informs design (evidence: `README.md`)
- Database design → Normalization: guides review (evidence: `README.md`)
- Database design → MySQL implementation: guides creation (evidence: `README.md`)
- Entities and fields → Six-table schema: specifies tables (evidence: `README.md`)
- Business analyst → Business questions: poses questions (evidence: `README.md`)
- Business questions → Six-table schema: queries tables (evidence: `README.md`)
- Business questions → Attendance and revenue insights: summarizes findings (evidence: `README.md`)