Blood Bank Software

The Blood Bank Software application for office automation. It is used to do all the office work computerized. The current system is graphical user interface. It does not support much functionality. It is partial automated system. The system will provide the user the option to look at the details of the existing Donor List, Blood Group and to add a new Donor. It also allows the user to modify the record. The administrator can alter all the system data.

Blood Bank Software

Limitations of the Current System

  • Attendance is taken manually.
  • It needs upgradation
  • The System encapsulates polymorphism.
  • The projects works in a structured model using procedures and functions.

Blood bank Table design

Table Name:-bloodgroup

Fields Data type Size Constraint
PK_BloodGroup Number 6 Foreign Key
BloodGroupname Text 35 Not Null
AvailableQty Number 6 Not Null
rate Number 15 Not Null

Table Name:-DonateTransaction

Fields Data type Size Constraint
PK_Donatetrans Number 6 Not Null
FK_Individualid Number 6 Not Null
Date Date/Time Not Null
Noofbags number 6 Not Null

Table Name:-HospitalMaster

Fields Data type Size Constraint
HospitalName Text 35 Not Null
PK_Hospitalid Number 6 Primary key
Address Text 40 Not Null
Phonenum Number 10 Not Null
City Text 20 Not Null
Pincode Number 10 Not Null

Table Name:-IndividualMaster

Fields Data type Size Constraint
PK_donorid Number 10 Primary key
Donorname Text 20 NotNull
Add Text 30 NotNull
Age Number 10 NotNull
Gender Text 10 NotNull
Telephone Number 10 NotNull
Mobile Number 10 NotNull
Date Number 10 NotNull
PK_bloodgroup Text 10 NotNull
City Text 10 NotNull
Pincode Number 10 NotNull
Bodyweight Number 10 NotNull
Temperature Number 10 NotNull
Pulse Number 10 NotNull
Bp Number 10 NotNull
Hb Number 10 NotNull
Wtofbag Number 10 NotNull

Table Name:-Login

Fields Data type Size Constraint
PK_userid Number 10 Primary key
username Text 20 NotNull
password Number 10 NotNull

 Table Name:-Outsider

Fields Data type Size Constraint
PK_outsiderid Number 10 Primary key
name Text 20 NotNull
phonenum Number 10 NotNull
hospname Text 20 NotNull
address Text 30 NotNull

Table Name:-Trans

Fields Data type Size Constraint
PK_transactionid Number 10 Primary key
typeofReceipet Number 20 NotNull
FK_Receipetid Number 10 NotNull
Transactiondate Number 10 NotNull
Transactionno Number 10 NotNull
Amount Number 10 NotNull

Table Name:-Transaction Details

Fields Data type Size Constraint
PK_transdetailid Number 10 Primary key
FK_Transid Number 10 NotNull
FK_Bloodgroup Text 10 NotNull
Nob Number 10 NotNull
FK_Receipetid Number 10 NotNull

Table Name:-Type Of Contact

Fields Data type Size Constraint
PK_tocid Number 10 Primary key
name Text 20 NotNull
Add Text 30 NotNull
Telephone Number 10 NotNull

Download project source code and Project report:

download complete project

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.