Organ Donation and Transplant Management System

A Flask + MySQL based DBMS project to manage users, donors, patients, organizations, transplantation transactions, and admin workflows.

This project includes:

• A Flask server for application logic and routing
• HTML frontend pages for admin and user workflows
• Statistics visualizations for donor/patient/transplant insights

Features

• Admin operations for add, update, remove, and search flows
• Donor and patient registration and detail management
• Organization and organization head management
• Transaction management and history views
• Statistics page with generated charts

Tech Stack

• Backend: Python, Flask
• Database: MySQL
• Data visualization: Matplotlib, NumPy
• Frontend: HTML, Bootstrap

Project Structure

dbmsProject/
|- server.py
|- create_tables.sql
|- frontend/
|- static/
|- ER diagrams/
|- PK_FK_Constraint.md
|- verification.txt

Prerequisites

• Python 3.9+
• MySQL Server 8+
• pip

Setup and Run

1. Clone the repository and open the project folder.
2. Create and activate a virtual environment.
3. Install Python dependencies.
4. Create a MySQL database named dbms_project.
5. Execute create_tables.sql and seed files from seed_inserting_data/.
6. Update database credentials in server.py if needed.
7. Run the app.

Example commands (Windows PowerShell):

python -m venv .venv
.\.venv\Scripts\Activate.ps1
pip install flask mysql-connector-python matplotlib numpy
python server.py

App will run on:

• http://127.0.0.1:5000

Security Notes

• Do not commit real credentials to source control.
• Move database credentials from server.py to environment variables for production.
• Run the Flask app with debug=False outside development.
• Follow the process in SECURITY.md to report vulnerabilities.

Governance and Community Files

• License: see LICENSE (MIT License)
• Security Policy: see SECURITY.md
• Code of Conduct: see CODE_OF_CONDUCT.md
• Contributing Guide: see CONTRIBUTING.md

Academic Note

This appears to be an academic DBMS project. Use responsibly and follow your institute's submission and collaboration policies.