How sushmithameduri/blood-bank-database-management-system works
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.