# sushmithameduri/blood-bank-database-management-system architecture

> Architecture diagram of the GitHub repository sushmithameduri/blood-bank-database-management-system, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-06-30). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/sushmithameduri/blood-bank-database-management-system
- Repository: https://github.com/sushmithameduri/blood-bank-database-management-system

## Overview

##### Project Type and Purpose
- This is primarily a database design & analytics project (no frontend/backend application code).
- It covers three phases: conceptual ER modeling (MySQL Workbench), logical implementation (SQL DDL & queries), and physical analytics (data dumps, Jupyter analysis, Tableau dashboards).

##### File Structure
- Top-level modeling artifacts:
- MILESTONE3.mwb (physical MySQL Workbench model)
- SQL scripts:
- MILESTONE2QUERY.sql (DDL for schema creation)
- MILESTONE3DUMP.sql (data population dump)
- Analytics:
- MILESTONE3code.ipynb (Jupyter Notebook with Python analysis)
- cool_things_in_our_project/mysql_to_mongodb_migration.py (optional migration script)
- cool_things_in_our_project/storing_website_data_into_mysql_table.ipynb (demo ingestion)
- Presentation & dashboards:
- MILESTONE3 .pptx (slide deck)
- milestone3tableaulinks.docx (links to Tableau dashboards)
- Config & dependencies: requirements.txt

##### README for Architecture Insights
- Confirms use of MySQL Server/Workbench, Python 3.8+, Tableau Desktop.
- Workflow: ER design → forward‐engineer DDL → load sample data → run Jupyter analysis → view dashboards.

##### Main Components and Their Interactions
a. MySQL Workbench (Modeling Tool)
– Inputs: ER model files (.mwb)
– Outputs: DDL scripts via Forward Engineer
b. MySQL Server (Database Instance)
– Receives: MILESTONE2QUERY.sql (schema), MILESTONE3DUMP.sql (data)
– Hosts: tables for Donor, BloodUnit, Hospital, Transfusion, etc.
c. Python Analytics Pipeline
– Jupyter Notebook (MILESTONE3code.ipynb)
– Libraries: pandas, numpy, matplotlib (from requirements.txt)
– Connects to MySQL to run queries, performs EDA & generates charts
d. Data Migration Script (optional)
– mysql_to_mongodb_migration.py
– Extracts from MySQL → Loads to MongoDB (highlight as an offshoot)
e. Visualization Layer
– Tableau Desktop / Dashboards (links in docx)
– Connects live to MySQL or to exported data extracts

##### Architectural Patterns & Design Principles
- Layered data‐pipeline:
1) Design Layer (Workbench ER models)
2) Storage Layer (MySQL schema & data)
3) Processing Layer (Python Jupyter EDA)
4) Presentation Layer (Tableau dashboards, slide deck)
- Separation of concerns: each milestone builds on the prior without overlapping responsibilities.
- Extensibility point: migration script shows how you might add a NoSQL component.

## Diagram (Mermaid)

```mermaid
flowchart TD
    subgraph "Design & Modeling (Milestone 1)"
        MySQLWorkbench["MySQL Workbench"]:::design
    end

    subgraph "Storage Layer (Milestone 2)"
        MySQLServer["MySQL Server"]:::storage
    end

    subgraph "Processing / Analytics (Milestone 3)"
        PythonAnalytics["Python Analytics Pipeline"]:::analytics
        StoringWebsite["Website Data Ingestion Notebook"]:::analytics
    end

    DataMigration["Data Migration Script"]:::optional

    subgraph "Visualization Layer"
        Visualization["Tableau / Presentation"]:::viz
    end

    MySQLWorkbench -->|"DDL scripts"| MySQLServer
    MySQLServer -->|"SQL queries"| PythonAnalytics
    MySQLServer -->|"data ingestion"| StoringWebsite
    PythonAnalytics -->|"visual configs"| Visualization
    MySQLServer -->|"live connection"| Visualization
    PythonAnalytics -.->|"optional migration"| DataMigration

    click MySQLWorkbench "https://github.com/sushmithameduri/blood-bank-database-management-system/blob/main/Final_ER_Model.mwb"
    click MySQLWorkbench "https://github.com/sushmithameduri/blood-bank-database-management-system/blob/main/Final_ER_Model.mwb.bak"
    click MySQLWorkbench "https://github.com/sushmithameduri/blood-bank-database-management-system/blob/main/MILESTONE3.mwb"
    click MySQLServer "https://github.com/sushmithameduri/blood-bank-database-management-system/blob/main/MILESTONE2QUERY.sql"
    click MySQLServer "https://github.com/sushmithameduri/blood-bank-database-management-system/blob/main/MILESTONE3DUMP.sql"
    click PythonAnalytics "https://github.com/sushmithameduri/blood-bank-database-management-system/blob/main/MILESTONE3code.ipynb"
    click PythonAnalytics "https://github.com/sushmithameduri/blood-bank-database-management-system/blob/main/requirements.txt"
    click StoringWebsite "https://github.com/sushmithameduri/blood-bank-database-management-system/blob/main/cool_things_in_our_project/storing_website_data_into_mysql_table.ipynb"
    click DataMigration "https://github.com/sushmithameduri/blood-bank-database-management-system/blob/main/cool_things_in_our_project/mysql_to_mongodb_migration.py"
    click Visualization "https://github.com/sushmithameduri/blood-bank-database-management-system/blob/main/MILESTONE3 .pptx"
    click Visualization "https://github.com/sushmithameduri/blood-bank-database-management-system/blob/main/milestone3tableaulinks.docx"

    classDef design fill:#add8e6,stroke:#000
    classDef storage fill:#90ee90,stroke:#000
    classDef analytics fill:#ffa500,stroke:#000
    classDef viz fill:#dda0dd,stroke:#000
    classDef optional fill:#d3d3d3,stroke:#000,stroke-dasharray: 5 5
```
