Blood Bank Management System (BBMS)

Table of Contents

Overview

Back to top

The Blood Bank Management System (BBMS) is an application designed to facilitate the querying and visualization of blood bank data. It provides a user-friendly interface to execute predefined SQL queries, access donor information, manage blood inventory, and visualize data analytics through integrated Tableau visualizations.

Features

Back to top

  • Database Connectivity: Offers secure login and connectivity to a MySQL database, ensuring data integrity and easy data retrieval.
  • Predefined Queries: Enables users to perform common blood bank-related SQL queries through a simple and intuitive interface.
  • Data Visualization: Integrates Tableau visualizations to offer comprehensive data analytics and reporting capabilities.
  • Interactive UI: Delivers a streamlined user experience with a clean and navigable graphical interface.

Visualizations

Back to top

BBMS integrates Tableau for advanced data analysis and visual reporting. Users can access various visualizations for insights into blood bank operations and trends.

Getting Started

Back to top

Follow these instructions to set up BBMS on your local environment for development and testing purposes.

Prerequisites

Back to top

Ensure you have the following prerequisites installed on your system:

  • Python 3.x
  • Tkinter library (usually included with Python installation)
  • MySQL Connector for Python
  • Access to Tableau Public (for embedded visualizations)

Installation

Back to top

  1. Clone the repository to your local machine using `git clone https://github.com/Ruqhaiya/Blood-Bank-Management-System.git’
  2. Navigate to the cloned directory and install the required dependencies by running pip install -r requirements.txt in your terminal.
  3. Start the application by running python bbms.py.

How to Use

Back to top

Upon launching BBMS, you will be greeted with a login prompt to connect to your MySQL database. After a successful login, the main interface allows you to:

  • Select and execute predefined SQL queries from the menu.
  • Access and interact with embedded Tableau visualizations for enhanced data analysis.

image

image

image

image

image

Versioning

Back to top

For the versions available, see the tags on this repository.