Visvesvaraya Technological University

Belagavi, Karnataka-590 018

A MINI PROJECT REPORT

On

‘BLOOD BANK MANAGEMENT SYSTEM’

Submitted
In partial fulfilment requirments for the award of the Degree
of
BACHELOR OF ENGINEERING
IN
INFORMATION SCIENCE AND ENGINEERING

by

MOWLYA K.S 4NM21IS089

NEHA SHETTY 4NM21IS094
PARINITHA 4NM21IS101

Under the Guidance of

Preethi Salian K
Assistant Professor

Department of Information Science and Engineering

 DEPARTMENT OF INFORMATION SCIENCE & ENGINEERING

CERTIFICATE
This is to certify that Ms. Mowlya K.S(4NM21IS089) ,Ms. Neha Shetty(4NM21IS094) and Ms.
Parinitha (4NM21IS101) as satisfactorily completed the Application Development Mini Project work
entitled “BLOOD BANK MANAGEMENT SYSTEM” of Third Year, Bachelor of Engineering in
Information Science and Engineering at NMAMIT, Nitte in the academic year 2023 - 24.

Project Guide Head, Dept. of ISE

Ms. Preethi Salian K Dr. Ashwini B
Assistant Professor Associate Professor
1
 DEPARTMENT OF INFORMATION SCIENCE & ENGINEERING

CERTIFICATE

This is to certify that Ms. Mowlya K.S(4NM21IS089), Ms. Neha Shetty(4NM21IS094) and Ms.
Parinitha(4NM21IS101) has satisfactorily completed the Application Development Mini Project
work entitled “BLOOD BANK MANAGEMENT SYSTEM” of Third Year, Bachelor of
Engineering in Information Science and Engineering at NMAMIT, Nitte in the academic year 2023
- 24.

Project Guide Head, Dept. of ISE

Ms. Preethi Salian K Dr. Ashwini B

Assistant Professor Associate Professor

2
 ABSTRACT
The Blood Bank Management System in Java is a sophisticated DBMS project designed to
revolutionize the operational landscape of blood banks. Featuring an intuitive Java interface, it
excels in donor management by seamlessly capturing and maintaining comprehensive donor
records, ensuring compliance with eligibility criteria, and facilitating hassle-free appointment
scheduling. The system offers real-time blood inventory tracking, complete with alerts for low
stock levels and impending expirations, ensuring a constant and secure blood supply. Beyond basic
functionalities, this system excels in patient records and transfusion management, enabling
seamless integration of patient data with donor information for a comprehensive overview of
transfusion history. Robust user authentication, authorization, and an audit trail ensure secure
access and accountability. The system's advanced reporting and analytics empower stakeholders
with customizable reports on donor demographics, blood utilization trends, and inventory statuses,
facilitating informed decision-making for optimized blood bank operations. In essence, this Blood
Bank Management System not only meets the essential requirements of donor and inventory
management but also exceeds expectations by incorporating advanced security measures and
analytical capabilities.

3
 TABLE OF CONTENTS
CONTENTS PAGE NO.

1. INTRODUCTION

2. ANALYSIS AND REQUIREMENT SPECIFICATION

2.1 PURPOSE

2.2 SCOPE

2.3 FUNCTIONAL REQUIREMENTS

2.4 NON-FUNCTIONAL REQUIREMENTS

3. DESIGN

3.1 ER DIAGRAM

3.2 SCHEMA DIAGRAM

4. IMPLEMENTATION

4.1 MySQL CODE

4.2 RESULTS

5. CONCLUSIONS

6. REFERENCES

4
1. INTRODUCTION
In the realm of healthcare, efficient management of blood donation and distribution stands as a
critical component in saving lives. The Blood Bank Monitoring System aims to streamline the
intricate process of blood inventory management, ensuring the availability of safe and compatible
blood units for patients in need.

This project serves as an intersection of technology and humanitarian aid, striving to bridge the
gap between blood donors and recipients. By providing a user-friendly platform that facilitates
donor engagement, tracks inventory in real-time, and ensures stringent quality control measures,
the Blood Bank Monitoring System aims to bolster the healthcare infrastructure by optimizing
blood donation processes. In essence, this system also redefines efficiency, ensuring a reliable,
secure, and streamlined blood supply chain within healthcare institutions.

• Safety and Quality Assurance: Implementation of stringent screening and testing

protocols to ensure the safety and quality of donated blood.
• Security Measures: Utilization of robust data encryption techniques to safeguard sensitive
donor information and medical records and access control mechanisms to ensure only
authorized personnel can view or modify critical data.
• Inventory Availability: Real-time tracking and monitoring of blood inventory levels
across multiple blood banks or storage locations.
• Accessibility: User-friendly interfaces for donors, healthcare institutions, and
administrators, facilitating easy navigation and interaction with the system and Mobile
responsiveness and compatibility across devices for seamless access to blood availability
information.
• Order Management: Efficient deletion of outdated or canceled orders from the system to
maintain accurate inventory records. Streamlined update mechanisms for modifying or
adjusting existing orders based on healthcare institutions' requirements.
• Donor Identification and Specific Blood Group Search: Database filters enabling quick
identification of eligible donors based on specific criteria such as blood group, location,
and donation history.

5
2. ANALYSIS AND REQUIREMENT SPECIFICATION

The Blood Bank Management System requires thorough analysis and detailed requirement
specifications. Key considerations include donor management, real-time blood inventory tracking,
patient records, robust user authentication, and advanced reporting capabilities. This ensures a
comprehensive system that meets the precise needs of blood banks, promoting efficient operations
and reliable blood supply.

2.1 Purpose

The purpose of this project is to enhance the efficiency and organization of blood banks. It
facilitates seamless donor management, real-time tracking of blood inventory, and comprehensive
patient records. By providing secure user authentication and advanced reporting capabilities, the
system ensures the reliable and timely availability of blood products. Ultimately, it streamlines
operations, optimizes resource utilization, and contributes to the overall effectiveness of blood
bank management within healthcare institutions.

2.2 Scope

The scope of this system extends to transforming the operations of blood banks. It encompasses
donor management, real-time blood inventory tracking, patient records, and robust user
authentication. The system's scope also includes seamless integration with healthcare systems,
ensuring interoperability. With advanced reporting capabilities, it aids decision-making and
strategic planning. The project's reach spans beyond basic functionalities, aiming to provide a
comprehensive and secure platform for blood bank operations. Its scope lies in optimizing
processes, ensuring a reliable blood supply, and contributing to the efficient management of
resources within healthcare institutions.

2.3 Functional requirements

• The system shall allow new donors to register by providing personal information such as
name, contact details, blood type, and eligibility criteria verification.
• It enables existing donors to update their information or donation history.

6
 • The system provides detailed availability information, including quantities, expiration
dates, and locations of available blood units.
• The system should have a high level of uptime (availability), ensuring access to blood
availability information 24/7.
• Security and ability to gain user trust, the site is entirely password protected for any kind
of access.

2.4 Non-Functional Requirements

Software requirements:

• Frontend- Java swing (JFrame)

• Backend- Operating System: Windows 11

MySQL database

Google Chrome/Internet Explorer

NetBeans IDE

Hardware requirements:

• Computer with a 1.1 GHz or faster processor

• Minimum 2GB of RAM or more
• 2.5 GB of available hard-disk space
• 5400 RPM hard drive
• 1366 × 768 or higher-resolution display
• DVD-ROM drive

7
3. DESIGN
3.1 The ER Diagram

8
 Fig 3.1 ER Diagram

3.2 The Schema Diagram

Fig 3.2 Schema Diagram

9
4. IMPLEMENTATION
In this project, an "implementation" can be understood as the development and deployment of a
system or application that provides support for the execution of the code.

The chosen technologies (Java Swing, NetBeans, MySQL) complement each other, offering a
cohesive development environment. Swing integrates well with NetBeans IDE, simplifying GUI
development, and MySQL's JDBC compatibility facilitates seamless interaction with the database.
Java served as the primary programming language, enabling the system's functionalities and
interactions while ensuring cross-platform compatibility and scalability.

4.1 MySQL Code

Creating the following tables in SQL:

CREATE TABLE DOCTOR

DOCTOR_ID INT PRIMARY KEY NOT NULL ,

DOCTOR_NAME VARCHAR(30),

DOC_ADD VARCHAR(50),

DOC_PHNO INT,

);

CREATE TABLE DONOR

DONOR_ID INT PRIMARY KEY NOT NULL,

DONOR_NAME VARCHAR(20),

DONOR_FATHER_NAME VARCHAR(20),

DONOR_MOTHER_NAME VARCHAR(20),
10
DOB DATE,

PHONE_NO INT,

GENDER CHAR(1),

EMAIL VARCHAR(20),

BLOOD_GROUP VARCHAR(5),

CITY VARCHAR(20),

D_ADDRESS VARCHAR(30),

DOCTOR_ID INT REFERENCES DOCTOR(DOCTOR_ID),

);

CREATE TABLE BLOOD_BANK

BLOOD_BANK_ID INT PRIMARY KEY NOT NULL,

BLOOD_BANK_NAME VARCHAR(50),

B_ADDRESS VARCHAR(30),

);

CREATE TABLE BLOOD

BLOOD_TYPE VARCHAR(30),

DONOR_ID INT REFERENCES DONOR(DONOR_ID),

BLOOD_BANK_ID INT REFERENCES BLOOD_BANK(BLOOD_BANK_ID ),

);

CREATE TABLE PATIENT

11
PATIENT_ID INT PRIMARY KEY NOT NULL,

PATIENT_NAME VARCHAR(20),

P_PHNO INT,

P_ADD VARCHAR(30)

);

5. RESULTS

12
• Addition of donor details

• Updating of the donor details

13
• Stored Procedure

14
15
 CONCLUSION
In conclusion, the Blood Bank Management System in Java, functioning as a robust Database
Management System (DBMS) project, presents a multifaceted approach with far-reaching
implications. Its immediate applications in real-time are evident through efficient donor data
management, rapid blood categorization, and seamless inventory tracking. This system not only
expedites response times during emergencies but also establishes a foundation for improved
healthcare service delivery.

Looking forward, the scope of the Blood Bank Management System extends beyond its current
applications. Future work could explore integration with emerging technologies such as
blockchain for enhanced security and traceability of blood products. Additionally, incorporating
machine learning algorithms could refine predictive models for blood demand, optimizing
inventory levels and reducing wastage. Integration with mobile platforms can facilitate easier
donor, fostering a more engaged and active donor community. The adaptability of the Blood Bank
Management System scalable solution ready to embrace advancements in technology and
healthcare practices, ultimately contributing to the ongoing enhancement of blood bank operations.

Future scope of the project

• Integration with AI for predictive blood demand analysis.

• Mobile app development for donor engagement and alerts.
• Enhanced data analytics for inventory optimization.
• Expansion for telemedicine partnerships.
• User interface upgrades for better accessibility.

16
 REFERENCES

• [Link]
• [Link]

17