transfusion blood bank

8/12/2019 Transfusion Blood Bank

http://slidepdf.com/reader/full/transfusion-blood-bank 1/49

TRANSFUSION BLOOD BANK

We are always there to help YOU….



FINAL YEAR PROJECT

BBLLOOOODDBBAANNKK MMAANNAAGGEEMMEENNTT

SSYYSSTTEEMM

PPRROOJJEECCTT RREEPPOORRTT

Group Members are-

Snedden de Souza

Altaf Hussain

Tanvi Palkar

Lynessa Rodrigues

Prodosh Shirgaokar



ACKNOWLEDGEMENT

While presenting this project, we would like to express our deep sense of gratitude and

sincere thanks to all the people who took keen interest in our work and without whose help

this project would not have been possible.

First and foremost, we are obliged and express our sincere gratitude and indebtedness to our

project guide Ms. Stephanie Rodrigues for her valuable advice, guidance and immense

support and encouragement throughout the course for our work. We are extremely thankful to

her for her unique contribution in helping us make this project a success.

And not forgetting Dr. Sydney Pinto do Rosario, Gynecologists for giving us his valuable

time and information on the Blood Bank Management process which enabled us to develop

our software.

We also thank Dr. (Fr.) Walter De Sa for his kind support and encouragement for the

success of our project.

We thank all our friends and coordinators for their valuable directives and inputs for the

project and not to forget our dear parents for their financial support.



TABLE OF CONTENT

SR.NO CONTENTS PAGE NO

1. Introduction to the system

2. Existing system and its limitation

3. Features of proposed system

4. Entity relationship diagram

5. Tables

6. Use case diagram

7. Class diagram

8. Activity diagram

9. System configuration

10. Validation test report

11. System integration test report

12. Future enhancement

13. Bibliography

14. Appendix



INTRODUCTION TO THE

SYSTEM



INTRODUCTION TO THE SYSTEM

In today’s world most number of deaths are caused to fatal accidents and negligence by

people. The demand for blood is become an emergency as the number of patients admitted to

the hospitals per day is high. If this essential component is not given to patient on time it

could risk their life.

Transfusion Blood Bank is designed to cater to the needs of people in times of such situation.

It is a 24x7 website serving the purpose of checking the availability of blood and ordering it

instantly when needed. This Blood Bank is a cache or bank of blood or blood components,

gathered as a result of blood donation, stored and preserved for later use in blood transfusion.

Thus consuming less time and easing the mind of the customers during distress.



EXISTING SYSTEM AND

ITS LIMITATION



EXISTING SYSTEM AND ITS LIMITATION

The existing system is a manual system in which all the records are maintained manually.

The steps involved In the existing system are:

Patient is admitted in the hospital.

Doctor gives a certificate demanding for blood.

Certificate is submitted in the blood bank.

Blood is produced and a bill is generated manually.

The record is updated manually on the register.

LIMITATIONS OF THE SYSTEM

This system is designed in such a way, in which all the shortcomings are taken into

consideration. But still it has some limitations which are as follows:

Time consuming

A lot of cost required for paper work.

Finding of a specific record can prove to be very difficult.

The bill has to be prepared manually and is calculated using calculator.

The speed of maintaining this system is very low.

Updating information, report generation is done manually which is a tedious and

time consuming job.



FEATURES OF

PROPOSED SYSTEM



FEATURES OF PROPOSED SYSTEM

Blood bank management system is a 24 x 7 online system which enables customers to

purchase blood when need arises. The new system will contain the following features:

A strong and secured database.

Adding/Deleting/Updating/Finding the Donor Details and Inventory.

Automated generation of bill.

Easy to use.

Avoiding of data redundancy.



ENTITY RELATIONSHIP

DIAGRAM



ENTITY RELATIONSHIP DIAGRAM



TABLES



TABLES

Table name: Login

Description: This table contains username and password to Login.

Primary key: Username

Sr.no Field Name Description Constraints DataType Size

1 Username Stores the Unique name of the User Primary key Varchar (45)

2 Password Stores the Password of the User Null Varchar (45)

Table name: Customer Details

Description: This table contains the Customer Details.

Primary key: First Name

Sr.no Field Name Description Constraints DataType Size

1 Username Reference to table login Foreign key Varchar (45)

2 First Name Stores the first name of the customer Primary Key Varchar (45)

3 Last Name Stores the last name of the customer Null Varchar (45)

4 Email Stores the Email address of the

customer

Null Varchar (45)

5 Password Stores the Password of the customer Null Varchar (45)

6 Address Stores the Address of the customer Null Varchar (45)



Table name: Patient Details

Description: This table contains the Patient Details.

Primary key: Patient ID

Sr.no Field Name Description Constraints Data type Size

1 Patient ID Stores the unique Id of the

patient

Primary Key Integer

2 Patient Name Stores the name of patient Null Varchar (45)

3 Patient Age Stores the age of patient Null Integer

4 Blood Group Stores the bloodgroup of

patient

Null Varchar (45)

5 Gender Stores the gender of patient Null Varchar (45)

6 Hospital Name Stores the hospital name Null Varchar (45)

7 Doctor Name Stores the Doctor name of

patient

Null Varchar (45)

8 Blood

Components

Stores the blood component

of patient

Null Varchar (45)

9 No. of Units Stores the no.of units used Null Integer



Table name: Donor Details

Description: This table contains the Donor Details.

Primary key: Donor ID

Sr.no Field Name Description Constraints Data Type Size

1 Donor ID Stores the Id of the Donor Primary Key Integer

2 Donor Name Stores the name of the

Donor

Null Varchar (45)

3 Donor Age Stores the age of the Donor Null Integer

4 Donor Gender Stores the gender of the

Donor

Null Varchar (45)

5 Donor Address Stores the address of the

Donor

Null Varchar (45)

6 Donor BloodGroup Stores the bloodgroup of the

Donor

Null Varchar (45)

7 Donor Height Stores the height of the

Donor

Null Integer

8 Donor Weight Stores the weight of the

Donor

Null Integer

10 Donor Contact no. Stores the contact no. of the

Donor

Null Integer

11 Donor Email Stores the email id of the

Donor

Null Varchar (45)



Table name: Doctor Details

Description: This table contains the Doctor Details.

Primary key: Doctor ID


1 Doctor ID Stores the unique Id of the

doctor

Primary Key Integer

2 Doctor Name Stores the name of the doctor Null Varchar (45)

3 Doctor Hospital Stores the name of the doctors

hospital

Null Varchar (45)



Table name: Bill

Description: This table contains the Bill Details

Primary key: Bill_no

Sr. no Field Name Description Constraints Data

Type

Size

1. Bill_no Stores the unique Id of the

bill

Primary key Integers

2. Username Reference to table login Null Varchar (45)

3. Bill_date Stores the date of the bill Null Date

4. Bill_particulars Stores the particulars of the

bill

null Varchar (45)

5. BloodGroup Stores blood group of the

patient

Null Varchar (45)

6. BloodComponent Stores blood component of

the patient

Null Varchar (45)

7. Date Stores the date of the patient

when blood was ordered

Null Date

8. Time Stores the time of the

patient when blood was

ordered

Null Time

9. Rate Stores the rate of the blood

component

Null Integer

10. Amount Stores the amount to be paid Null Integer



by the customer to the blood

bank

11. Quantity Stores the quantity

purchased by the customer

Null Integer

Table name: Stock Details

Description: This table contains the Stock Details.


1. BloodGroup Stores the blood group

in the blood bank

Null Varchar (45)

2. BloodComponent Stores the blood

components in the

blood bank

Null Varchar (45)



USE CASE DIAGRAM



CLASS DIAGRAM



ACTIVITY DIAGRAM



SYSTEM

CONFIGURATION



SYSTEM CONFIGURATION

Hardware

Processor : Intel Pentium dual core.

RAM : 512 MB

Disk Space : 1 GB Free Space

Software

Front End : .Net (ASP)

Back End : MySQL

Operating System: Windows xp/windows 7



Validation Test Report



Validation Test Report

Description: This Validation occurs when invalid username or password is entered.



Description: This Validation occurs when a number is entered instead of alphabets.



Description: This Validation occurs when a alphabet is entered instead of number.



Description: This Validation occurs when a user by mistake enters a wrong password.



SYSTEM INTEGRATION

TEST REPORT



SYSTEM INTEGRATION TEST REPORT

Description: Bill is generated when blood is ordered by the customer.



Description: Bill is generated containing nil value when donor utilizes his donor card.



FUTURE ENHANCEMENT



FUTURE ENHANCEMENT

Blood Bank Management System can be enhanced by including features such as:-

Intimating the existing donors through emails when there is a request for blood.

Automated emails to all registered to users during blood donation camps.

Include SMS features to intimate customers for the same.



BIBLIOGRAPHY



BIBLIOGRAPHY

Websites:

www.google.com

www.bharatbloodbank.com

Books:

Applying UML and patterns 3rd edition by Craig Larman.

Visual basic 6 programming black book new edition by Steven Holzner.

http://www.google.com/

http://www.bharatbloodbank.com/

http://www.bharatbloodbank.com/

http://www.google.com/



APPENDIX



APPENDIX

Description: Welcome page of the website.



Description: Login page of the website.



Description: Administrator’s page.



Description: Customer sign in page.



Description: Donor details page.



Description: Here the customer asks for blood.



Description: Here the admin checks the Stock of various blood group and its component.



Description: Bill is generated for donors.



Description: Bill is generated for customers who are not donors.

transfusion blood bank

Documents