# adi-200/hospital_management_system_sql_project architecture

> Architecture diagram of the GitHub repository adi-200/hospital_management_system_sql_project, 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/adi-200/hospital_management_system_sql_project
- Repository: https://github.com/adi-200/hospital_management_system_sql_project

## Overview

This is a small MySQL hospital-data project, not an application with a documented service layer. Its stated purpose is to manage hospital records and analyze hospital data. The README names seven database tables; the repository also includes separate database and query SQL files. Their contents were not provided, so table relationships and specific query behavior cannot be established. The graph therefore shows only the documented database-and-query scope.

Main entry points: [`Hospital_Query.sql`](https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Query.sql) (Hospital Queries), [`Hospital_Database.sql`](https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql) (Hospital Database)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Hospital Data"]
  node_hospital_db[("Hospital Database")]
  node_physician["Physician"]
  node_affiliation["Affiliated With"]
  node_department["Department"]
  node_nurse["Nurse"]
  node_patient["Patient"]
  node_diagnosis["Patient Diagnosis"]
  node_procedures["Procedures"]
end

subgraph group_sql["SQL Operations"]
  node_hospital_queries["Hospital Queries<br/>[Hospital_Query.sql]"]
end

node_hospital_queries -->|"analyzes data"| node_hospital_db

click node_hospital_db "https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql"
click node_physician "https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql"
click node_affiliation "https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql"
click node_department "https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql"
click node_nurse "https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql"
click node_patient "https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql"
click node_diagnosis "https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql"
click node_procedures "https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql"
click node_hospital_queries "https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Query.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_hospital_db,node_physician,node_affiliation,node_department,node_nurse,node_patient,node_diagnosis,node_procedures toneBlue
class node_hospital_queries toneAmber
```

## Components

### Hospital Data

- [Hospital Database](https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql): `Hospital_Database.sql`
- [Physician](https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql): `Hospital_Database.sql`
- [Affiliated With](https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql): `Hospital_Database.sql`
- [Department](https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql): `Hospital_Database.sql`
- [Nurse](https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql): `Hospital_Database.sql`
- [Patient](https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql): `Hospital_Database.sql`
- [Patient Diagnosis](https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql): `Hospital_Database.sql`
- [Procedures](https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Database.sql): `Hospital_Database.sql`

### SQL Operations

- [Hospital Queries](https://github.com/adi-200/hospital_management_system_sql_project/blob/main/Hospital_Query.sql): `Hospital_Query.sql`

## Connections

- Hospital Queries → Hospital Database: analyzes data (evidence: `README.md`)
