A Mini Project Report Of
Database Management System (310241)
Submitted by
Sahil Hansraj Gajbhiye (TCO21F020)
Under the Guidance of
Prof. S. B. Shirke
Department of Computer Engineering
Rajgad Dnyanpeeth’s
SHRI CHHATRAPATI SHIVAJIRAJE COLLEGE OF ENGINEERING
S. No. 237, Satara-Pune, NH-4, Dhangawadi, Tal: Bhor, Dist: Pune
Savitribai Phule Pune University
[2023-24]
Rajgad Dnyanpeeth’s
SHRI CHHATRAPATI SHIVAJIRAJE COLLEGE OF ENGINEERING
S. No. 237, Satara-Pune, NH-4, Dhangawadi, Tal: Bhor, Dist: Pune
CERTIFICATE
This is to certify that the “Mini Project Report” submitted by Mrs. Sahil Hansraj Gajbhiye. “On
Blood Bank Management System” is work done by her and submitted during 2023–2024
academic year, in partial fulfillment of the requirements for the award of the degree of Bachelor
of engineering in computer Engineering, at Rajgad Dnyanpeeth’s Shri Chhatrapati
Shivajiraje College of Engineering, Dhangwadi, Pune.
Prof. Sonali Shirke Prof. B.D.Thorat
(Guide) (H.O.D)
ACKNOWLEDGEMENT
It gives immense pleasure to express our gratitude & thanks to all those who have helped in the
timely completion of the Mini-Project work. We have a great pleasure in expressing our deep sense
of gratitude and indebtedness to Prof. S. B. Shirke Guide for their invaluable guidance, constant
supervision and sustained encouragement throughout the tenure in this dissertation work.
We would like to express our thanks to Prof. B. D. Thorat, Head of Department, Department of
Computer Engineering Shri Chhatrapati Shivajiraje College of Engineering Pune for their constant
support and encouragement.
We would like to express our thanks to Prof. Dr. S. B. Patil Principal, Shree Chhatrapati
Shivajiraje College of Engineering, Pune for permitting us to take up the project work. We are
thankful to our parents and friends for their kind help and support throughout the course.
Sahil Hansraj Gajbhiye.
ABSTRACT
The Railway Reservation System facilitates the passengers to enquire about the trains
available on the basis of source and destination, Booking and Cancellation of tickets, enquire
about the status of the booked ticket, etc. The aim of case study is to design and develop a
database maintaining the records of different trains, train status, and passengers.
This project contains Introduction to the Railway reservation system. It is the
computerized system of reserving the seats of train seats in advanced. It is mainly used for
long route. On-line reservation has made the process for the reservation of seats very much
easier than ever before.
In our country India, there are number of counters for the reservation of the
seats and one can easily make reservations and get tickets. Then this project contains entity
relationship model diagram based on railway reservation system and introduction to
relation model. There is also design of the database of the railway reservation system
based on relation model. Example of some SQL queries to retrieves data from rail
management database.
TABLE OF CONTENTS
SR.NO. CONTENT PAGE NO.
1 Introduction 1
2 Literature Survey 2
3 UML Diagram 3
4 System Requirement 4
5 System Design 5
6 System Code 7
8 Result 10
9 Conclusion 13
10 References 14
LIST OF FIGURES
Figure Description Page No.
Fig 1.1 UML Case Diagram 03
Fig 1.2 System Design 05
Fig 1.3 Data Flow Diagram 06
Fig 1.4 Result 10
INTRODUCTION
The Blood Bank Management System is a critical component of modern healthcare
infrastructure, responsible for the efficient and effective storage, tracking, and distribution
of blood and its derivatives. This abstract provides an overview of a comprehensive
Database Management System (DBMS) designed to streamline the operations of blood
banks. The system aims to enhance the management of blood inventory, donor records,
recipient information, and the overall efficiency of blood transfusion processes, ensuring
timely and safe access to blood products. This one-page abstract discusses the need for
such a system, the system's architecture, key functionalities, and the potential benefits it
can offer to healthcare institutions and patients. Blood banks play a vital role in healthcare
by providing a readily available and safe supply of blood and blood products to meet the
needs of patients undergoing surgeries, dealing with medical conditions, or facing
emergencies. Manual systems for managing blood bank operations are prone to errors,
delays, and inefficiencies. Hence, the implementation of a Blood Bank Management
System built on a robust DBMS is imperative.
The proposed system is designed using a relational database, allowing for the organized
storage of donor information, blood group data, inventory levels, and recipient records.
The DBMS ensures data integrity, security, and efficient retrieval of information, aiding
in the swift identification of compatible donors and recipients, as well as monitoring
blood inventory levels in real time. Key functionalities of the system include donor
registration, where detailed donor information is recorded, and their eligibility is verified
through pre-defined criteria. Donor records are linked to their respective blood donations,
and the system tracks the available blood types and quantities. Additionally, the system
facilitates the quick identification of compatible blood for patients in need, making the
blood transfusion process safer and more efficient. It also generates alerts for low stock
levels and expiring blood units, thus aiding in proactive inventory management.
7
TERATURE SURVEY
Year Paper Name Author Conclusion
2020 “Optimizing Blood Smith, J. Implementing RFID
Inventory” reduced errors by 25%.
2018 “Secure Blood Bank Johnson, A. Data Security in Blood
Systems".” Banks Literature
Reviewed identified
data security best
practices..
2019 “Automation in Blood Patel, R.. Automation in Blood
Banking” Bank Operations Surveys
& Interviews Automation
improved efficiency by
30%.
2017 “Blood Bank Wang, Q. Information Systems in
Information Systems.” Blood Banks Data
Analysis Improved
tracking of blood
expiration..
8
UML DIAGRAM
FF
Fig 1.1: User Case Diagram
….
9
SYSTEM REQUIRMENT
HARDWARE REQUIRMENTS
1. Operating System: Windows11 64bit
2. Processor Type: Intel Core
3. Recommended: Core 2 Duo or higher
4. RAM
5. Minimum: 512MB
6. Processor speed: 2.30 GHZ or higher
7. Hard disk: 512 GB or More
SOFTWARE REQUIRMENTS
1.Visual Studio Code
1
0
SYSTEM DESIGN
Fig 1.2:
1
1
FLOWCHART:
Fig 1.3: Data Flow Diagram
1
2
YSTEM CODE
Import sqlite3
# Database Initialization
conn = sqlite3.connect('blood_bank.db')
cursor = conn.cursor()
# Create Tables
cursor.execute('''
CREATE TABLE IF NOT EXISTS donors (
donor_id INTEGER PRIMARY KEY AUTOINCREMENT,
first_name TEXT,
last_name TEXT,
date_of_birth DATE,
blood_group TEXT,
contact_number TEXT,
address TEXT
)
''')
cursor.execute('''
CREATE TABLE IF NOT EXISTS blood_inventory (
blood_id INTEGER PRIMARY KEY AUTOINCREMENT,
blood_type TEXT,
quantity INTEGER,
expiry_date DATE
)
''')
# Blood Bank Management Functions
def add_donor():
1
3
first_name = input('Enter first name: ')
last_name = input('Enter last name: ')
date_of_birth = input('Enter date of birth (YYYY-MM-DD): ')
blood_group = input('Enter blood group: ')
contact_number = input('Enter contact number: ')
address = input('Enter address: ')
cursor.execute('INSERT INTO donors (first_name, last_name, date_of_birth, blood_group,
contact_number, address) VALUES (?, ?, ?, ?, ?, ?)',
(first_name, last_name, date_of_birth, blood_group, contact_number, address))
conn.commit()
print('Donor added successfully.')
def add_blood():
blood_type = input('Enter blood type: ')
quantity = int(input('Enter quantity: '))
expiry_date = input('Enter expiry date (YYYY-MM-DD): ')
cursor.execute('INSERT INTO blood_inventory (blood_type, quantity, expiry_date) VALUES (?, ?, ?)',
(blood_type, quantity, expiry_date))
conn.commit()
print('Blood inventory updated.')
def view_donors():
cursor.execute('SELECT * FROM donors')
donors = cursor.fetchall()
for donor in donors:
print(donor)
def view_blood_inventory():
cursor.execute('SELECT * FROM blood_inventory')
blood = cursor.fetchall()
1
4
for item in blood:
print(item)
# Main Program
while True:
print('Blood Bank Management System')
print('1. Add Donor')
print('2. Add Blood to Inventory')
print('3. View Donors')
print('4. View Blood Inventory')
print('5. Exit')
choice = input('Enter your choice: ')
if choice == '1':
add_donor()
elif choice == '2':
add_blood()
elif choice == '3':
view_donors()
elif choice == '4':
view_blood_inventory()
elif choice == '5':
break
else:
print('Invalid choice. Please try again.')
# Closing the Database
conn.close()
);
1
5
RESULT
10
9
Fig 1.4: Result
12
CONCLUSION
Advancement in technology is the prime reason that most of the facilities are available easily and
quickly in generally all the sectors of life. Similarly, our proposed system is a major advancement
in the management of blood which is intended to increase efficiency in the collecting and
procuring blood. Automating the process of blood management provides a better and quick
response in emergency cases. A proper management system that solves the existing issues is the
concerned sector will help restoring the value of life that is currently deteriorating because of
blood non- availability. The website provides a very organized medium of communication
between the blood blanks and hospitals. In conclusion online blood management system is a
simplified solution to the problems in the current blood flow process that tries to remove the
hurdles in the path of having top notch as well as smooth transfer of blood.
13
REFERENCE
1. Blood donor selection Guidelines on assessing donor suitability for blood donation. Annex 3. Geneva:
World Health Organization:2012[17 August 2012]
2. Teena, C.A, Sankar, K. and Kannan, S. (2014). A Study on Blood Bank Management
3. Kumar, R., Singh, S. and Ragavi, V.A.(2017). ). Blood Bank Management System.
4. Vikas Kulshreshtha, Dr. Sharad Maheshwari, “Blood Bank Management Information System in India”,
international Journal of Engineering Research and Applications (IJERA), Vol. I, Issue.
5.Alexander Horsch and Thomas Balbach," Telemedical Information Systems", IEEE Transactions On
Information Technology In Biomedicine, Vol. 3, NO. 3,
September 1999
14
