VISVESVARAYA TECHNOLOGICAL UNIVERSITY

BELAGAVI - 590018

DBMS Mini Project Report on

BLOOD BANK MANAGEMENT SYSTEM

Submitted in partial fulfillment of the requirement for the award of the degree of
Bachelor of Engineering
in
Computer Science and Engineering

Submitted By

AKANKSHA PRIYA 1DT21CS009

ANKITA JAISWAL 1DT21CS015

Under the Guidance of

Prof. Shylaja B
Assistant Professor, Department of CSE

DAYANANDA SAGAR ACADEMY OF TECHNOLOGY AND MANAGEMENT

Udayapura, Kanakapura Road, Bangalore-560082
(Affiliated to VTU, Belagavi and Approved by AICTE, New Delhi), CE, CSE, ECE, EEE, ISE,
ME Courses Accredited by NBA, New Delhi, NAAC A+

Department of Computer Science and Engineering

Academic Year : 2023-24
DAYANANDA SAGAR ACADEMY OF TECHNOLOGY AND MANAGEMENT
Udayapura, Kanakapura Road, Bangalore-560082
Department of Computer Science and Engineering

CERTIFICATE
Certified that the Mini Project titled “BLOOD BANK MANAGEMENT SYSTEM”
carried out by AKANKSHA PRIYA, bearing USN 1DT21CS009, ANKITA JAISWAL,
bearing USN 1DT21CS015, bonafide students of Dayananda Sagar Academy 0f Technology and
Management, is in partial fulfillment for the award of the BACHELOR OF ENGINEERING in
Computer Science and Engineering from Visvesvaraya Technological University, Belagavi
during the year 2023-2024. It is certified that all the corrections/suggestions indicated for Internal
Assessment have been incorporated in the report submitted to the department. The Project report has
been approved as it satisfies the academic requirements in respect of the Mini Project Work
prescribed for the said Degree.

Prof. Shylaja B Dr. Kavitha C Dr. M. Ravishankar

Assistant Professor Professor & HOD Principal
Department of CSE Department of CSE DSATM, Bengaluru.
DSATM, Bengaluru. DSATM, Bengaluru.

Examiner 1: Name…………………….

…….....

Signature………………………..………

Examiner 2:

Name…………………………….

Signature………………………….
DECLARATION
We, AKANKSHA PRIYA, bearing USN 1DT21CS009, ANKITA JAISWAL bearing
USN 1DT21CS015, students of Fifth Semester B.E, Department of Computer Science and
Engineering, Dayananda Sagar Academy 0f Technology and Management, Bengaluru,
declare that the Mini Project Work titled “BLOOD BANK MANAGEMENT SYSTEM”
has been carried out by us and submitted in partial fulfilment of the course requirements for
the award of degree in Bachelor of Engineering in Computer Science and Engineering
from Visvesvaraya Technological University, Belagavi during the academic year 2023-
2024.

1. AKANKSHA PRIYA 1DT21CS009 Signature

2. ANKITA JAISWAL 1DT21CS015 Signature

Place: Bengaluru
Date:
ABSTRACT

The Blood Bank Management System optimizes blood donation, storage, and distribution
processes. It features donor registration, blood screening, inventory management, and cross-
matching functionalities. Through real-time monitoring, it ensures optimal blood stock
levels, minimizing shortages and wastage. Automated alerts prevent shortages. It rigorously
screens donated blood for safety, including compatibility testing. The system facilitates
seamless integration with laboratory equipment for efficient data exchange. Comprehensive
reporting capabilities aid in performance monitoring and regulatory compliance. Ultimately,
the system enhances operational efficiency, accuracy, and safety in blood banking,
contributing to improved patient care and resource management.

i
v
ACKNOWLEDGEMENT

The satisfaction and the euphoria that accompany the successful completion of any task
would be incomplete without the mention of the people who made it possible. The constant
guidance of these people and encouragement provided, crowned us with success and glory.
We take this opportunity to express our gratitude to one and all.

It gives us immense pleasure to present before you our project titled “BLOOD BANK
MANAGEMENT SYSTEM”. The joy and satisfaction that accompanies the successful
completion of any task would be incomplete without the mention of those who made it possible.
We are glad to express our gratitude towards our prestigious institution DAYANANDA SAGAR
ACADEMY OF TECHNOLOGY AND MANAGEMENT for providing us with utmost
knowledge, encouragement and the maximum facilities in undertaking this project.

We wish to express a sincere thanks to our respected Principal Dr. M Ravi Shankar,
Principal, DSATM for all his support.

We express our deepest gratitude and special thanks to Dr. Kavitha C, H.O.D, Dept. of
Computer Science Engineering, for all her guidance and encouragement.

We sincerely acknowledge the guidance and constant encouragement of our mini-project guide,
Prof. LAKSHMI M R, Assistant Professor, Dept. of Computer Science & Engineering.

Akanksha Priya 1DT21CS009

Ankita Jaiswal 1DT21CS015

v
TABLE OF CONTENTS

Chapter No. Chapter Name Page No.

1 INTRODUCTION 8
1.1 Purpose 8
1.2 Scope 8
2 REQUIREMENT SPECIFICATION 9
2.1 Hardware configuration 9
2.2 Software configuration 9
3 SYSTEM ANALYSIS AND DESIGN 10
3.1 Analysis 10
3.2 Design Introduction 10
3.2.1 Control flow diagram 11
3.2.2 Schema diagram 12
3.2.3 ER diagram 13
3.2.4 Data Tables 14
4 IMPLEMENTATION 16
4.1 Modules 16
4.2 Database connectivity 17
4.3 Source code 18
5 TESTING 22
5.1 System testing. 22
5.2 Module Testing 22
5.3 Integration Testing 22
5.4 Unit Testing 22
6 RESULT ANALYSIS & SCREENSHOTS 23
7 CONCLUSION 32

v
i
LIST OF TABLES

SL NO. TABLE NO. TABLE NAME PAGE NO.

1 Table 3.1 EMS database 14

2 Table 3.2 Users Table 14
3 Table 3.3 Users Registration 14
4 Table 3.4 Accounts Table 14
5 Table 3.5 Transaction 15
6 Table 3.6 Transaction history 15
7 Table 3.7 Payment Options 15
8 Table 3.8 Rewards 15

v
ii
LIST OF FIGURES

SL NO. FIGURE NO. FIGURE NAME PAGE NO.

1 Figure 3.1 Control flow diagram 11
2 Figure 3.2 Schema diagram 12
3 Figure 3.3 E R Diagram 13
4 Figure 6.1 Admin Login Page 31
5 Figure 6.2 Admin Landing Page 31
6 Figure 6.3 Add A New User 32
7 Figure 6.4 Add An Admin 32
8 Figure 6.5 User Login 33

9 Figure 6.6 User Landing Page 33

10 Figure 6.7 Add Transaction 34
11 Figure 6.8 Add Money 35
12 Figure 6.9 See Rewards 36

v
ii
Project Title

CHAPTER 1
INTRODUCTION

Dept. of CSE, DSATM 2023-24 8

Project Title

1.1 PURPOSE

1. Efficient Blood Inventory Management: Ensure optimal stock levels,

minimizing wastage while meeting demand through organized tracking and
monitoring.

2. Facilitate Donor Management: Streamline donor registration, scheduling,

and communication to encourage regular donations and maintain a robust blood
supply.
Of course, here are the next two points:

3. Ensure Blood Safety: Rigorous screening, testing, and quality control

procedures to safeguard recipients from transfusion-related risks and maintain
the integrity of the blood supply chain.

4. Streamline Transfusion Processes: Efficiently match and distribute blood

products to recipients, ensuring timely and accurate transfusions while
minimizing administrative burdens and errors.

1.2 SCOPE

1. Donor Registration and Management: Capture and maintain donor data,

facilitate appointments, and encourage donation to sustain the donor pool.

2. Inventory Tracking and Management: Monitor blood product levels,

expiration dates, and storage conditions to ensure availability and compliance
with safety standards.

3. Blood Testing and Quality Assurance: Conduct comprehensive testing

procedures to ensure the safety and quality of donated blood, adhering to
stringent regulatory standards and protocols.

4. Transfusion Management: Coordinate the efficient distribution and

administration of blood products to healthcare facilities, ensuring accurate
matching with patient needs and adherence to transfusion protocols.

Dept. of CSE, DSATM 2023-24 8

CHAPTER 2

REQUIREMENT SPECIFICATION

2.1 Hardware Configuration

Client side

RAM: 512MB

Hard disk:10GB Processor: 1.0Ghz

Server side

RAM: 1GB

Hard disk: 20GB

Processor: 2.0Ghz

2.2 Software Configuration

Web browser: Chrome or any other equivalent browser

Operating System: Windows or any equivalent OS

Dept. of CSE, DSATM 2023-24 9

CHAPTER 3

SYSTEM ANALYSIS AND DESIGN

3.1 ANALYSIS

Manual calculations of expenses are very much tedious and time consuming process. Due to the
growth of technology in a rapid way people expect everything to be online and easy-going. This
project aims at providing an easy access to the users to view their transactions . Allows the
admin to monitor the expenses of users registered under the admin. The system allows the user to
claim free rewards that comes as an incentive of using the app.

Disadvantages of present system:

 Not user friendly

 Too much clutter

 Time consuming

 Less Efficient

3.2 DESIGN INTRODUCTION

Design is the first step in the development phase for any techniques and principles for the
purpose of defining a device, a process or system in sufficient detail to permit its physical
realization. Once the software requirements have been analyzed and specified the software
design involves three technical activities-design, coding, implementation and testing that are
required to build and verify the software.

Dept. of CSE, DSATM 2023-24 10

3.2.1 CONTROL FLOW DIAGRAM

Figure 3.1: shows the flow of control through different entities in the system

Dept. of CSE, DSATM 2023-24 11

3.2.2 SCHEMA DIAGRAM

Figure 3.2: skeleton structure that represents the logical view of the entire database

Dept. of CSE, DSATM 2023-24 12

3.2.3 ER DIAGRAM

Figure 3.3: shows the relationships of entity sets stored in a database and theirrelationship

Dept. of CSE, DSATM 2023-24 13

3.2.4 DATA TABLES

Table 3.1 User Registration Table

Table 3.2 Donor Table

Dept. of CSE, DSATM 2023-24 14

Table 3.5 Transaction

Table 3.6 Transaction history

Table 3.7 Payment Options

Table 3.8 Rewards

Dept. of CSE, DSATM 2023-24 15

CHAPTER 4

IMPLEMENTATION

4.1 MODULES

The PLACEMENT MANAGEMENT SYSTEM contains two modules. They are:

 The Admin module

 The User Module

Admin Module

Home Page: Admin can view and update his/her profile in this page.

View User List: Admin can view the list of users registered.

View And Update User Details: Admin can view the details of each user and delete the users.

Add Users: Admin can register users.

Add Admin: Admin can register a new admin.

User Module

Home Page: Users can view and update their profile details in this page.

Transactions : Users can view all the transactions made and the current available balance.

Add Transaction: Users can add new transactions to the list.

Add Money: Users can add the received money to the list.

See Rewards: Users can view and claim rewards.

Dept. of CSE, DSATM 2023-24 16

4.2 DATABASE CONNECTIVITY

A database connection is a facility in computer science that allows client software to talkto
database server software, whether on the same machine or not. A connection is required to send
and receive commands.
DB Connectivity

 Localhost: Localhost is often used in web scripting languages like JavaScript when
defining what server the code should run from or where database is located a database is
located.

 Mysql2_connect(): The connect()/mysql_connect() function opens a newconnection to the

MySQL server
 root: The JavaScript document root is the folder where a JavaScript script is running. When
installing a script web developers often need to know the document root. Although many pages
scripted with JavaScript run on an Apache server, some run under MicrosoftIIS on Windows
 dbms_mini_project: It is the project folder name

Dept. of CSE, DSATM 2023-24 17

CHAPTER 5

TESTING
Software testing is a process of checking whether the actual software product matches expected
requirements and to ensure that software product is defect free.It involves execution of
software components using manual or automated tools toevaluate one or more properties of
interest.

5.1 SYSTEM TESTING

System testing is a level of testing that validates the complete and fully integratedsoftware
product. The purpose of system test is to evaluate the end to end system specifications. Usually,
the software is only one element of a larger computer based system.

5.2 MODULE TESTING

Module testing is defined as a software testing type, which checks individual subprograms,
subroutines, classes, or procedures in a program. Instead of testing whole software program at
once, module testing recommends testing the small building blocks of the program code.

5.3 INTEGRATION TESTING

Testing is a systematic technique or construction the program structure while atthe same time
conducting tests to uncover error associated with the interfacing.Scope of testing summarizes the
specific functional, performance and internal design characteristics that are to be tested.

5.4 UNIT TESTING

Unit testing focuses verification efforts on the smallest unit of software design module. The unit
test is always white box oriented. The tests that occur as a part of unit testing are testing the
module interface, examining the local data structureand testing error handling path.

Dept. of CSE, DSATM 2023-24 18

CHAPTER 6

RESULT ANALYSIS AND SCREENSHOTS

Admin Login Page: Where the Admin can login .

Figure 6.1: Admin Login

Admin Landing Page: Here admin can view all the users who have registered , view each
user details and delete the users.

Figure 6.2: Admin Landing Page

Dept. of CSE, DSATM 2023-24 19

Add A New User : Here the admin can register a new user.

Figure 6.3: Add New User

Add An Admin : Here the admin can add a new admin.

Fig 6.4: Admin Registration Form

Dept. of CSE, DSATM 2023-24 20

User Login : User can login .

Figure 6.5: User Login

User Landing Page : User can view all the transactions made and the available current
balance in each account.

Figure 6.6: Transaction History

Dept. of CSE, DSATM 2023-24 21

Add Transaction : User can add the transaction details to list.

1. Transaction entering form

2. Transaction List After Updation

Figure 6.7: Add Transaction

Dept. of CSE, DSATM 2023-24 22

Add Money: User can add money that have been received

1. Adding money details

2. User page after adding the details

Figure 6.8: Add Money

Dept. of CSE, DSATM 2023-24 23

See Rewards: Here the user can view the rewards and claim the rewards.
1. My Rewards.

2. Claimed Rewards

Figure 6.9: See Rewards

Dept. of CSE, DSATM 2023-24 24

CONCLUSION AND FUTURE ENHANCEMENTS
The EXPENSE MANAGEMENT SYSTEM is a great improvement over the manualsystem
which uses lots of manual work. The computerization of the system speeds up theprocess. This
system was thoroughly checked and tested with dummy data and found to be reliable.

MERITS

• The EXPENSE MANAGEMENT SYSTEM is fast, efficient and reliable.

• Avoids data redundancy and inconsistency

• Web-based

• Any number of users can use it

• Provides more security and integrity to data

FUTURE ENHANCEMENTS

As the technology emerges, it is possible to upgrade the system and can be adaptable todesired
environment. Based on the future security issues, security can be improved usingemerging
technologies. Sub admin module can also be added.

Dept. of CSE, DSATM 2023-24 25

BIBLIOGRAPHY

REFERENCES:

 https://youtu.be/DUpNn59TVbQ?si=5P7t_5saKRpILMlB

VIJAY THAPA:

BLOOD BANK MANAGEMENT SYSTEM in C# and MS SQL

SERVER

https://youtube.com/playlist?
list=PLBLPjjQlnVXW18XGLC2yjimoNA6ugNBQQ&si=_BdXTMfR
SJHOEb-T

Dept. of CSE, DSATM 2023-24 26

Personal Details:
 NAME: AKANKSHA PRIYA

USN: 1DT21CS009
SEMESTER: 5TH SEM, ‘A’ SECTION

COLLEGE: DAYANANDA SAGAR ACADEMY OF TECHNOLOGY AND

MANAGEMENT
EMAIL-ID: [email protected]

 NAME: ANKITA JAISWAL

USN: 1DT21CS015
SEMESTER: 5TH SEM, ‘A’ SECTION

COLLEGE: DAYANANDA SAGAR ACADEMY OF TECHNOLOGY AND

MANAGEMENT
EMAIL-ID: [email protected]

Dept. of CSE, DSATM 2023-24 27