Scribd Logo
Upload

Welcome to Scribd!

  • 85 views

    Blood Bank Database Sheet

    Uploaded by

    abcxyz24
    The document defines the entities, attributes, and relationships for a blood donation management system. The key entities include Staff, Addresses, Donars, Recipients, Hospitals, Clinics, Regions, Diseases, Blood, and Donations. The entities have identifying attributes and relationships such as a Donar donating blood that is received by a Recipient. Staff can refer to staff categories and Donars, Recipients, and Hospitals can have address information.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd

    Blood Bank Database Sheet

    Uploaded by

    abcxyz24
    85 views6 pages
    The document defines the entities, attributes, and relationships for a blood donation management system. The key entities include Staff, Addresses, Donars, Recipients, Hospitals, Clinics, Regions, Diseases, Blood, and Donations. The entities have identifying attributes and relationships such as a Donar donating blood that is received by a Recipient. Staff can refer to staff categories and Donars, Recipients, and Hospitals can have address information.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document defines the entities, attributes, and relationships for a blood donation management system. The key entities include Staff, Addresses, Donars, Recipients, Hospitals, Clinics, Regions, Diseases, Blood, and Donations. The entities have identifying attributes and relationships such as a Donar donating blood that is received by a Recipient. Staff can refer to staff categories and Donars, Recipients, and Hospitals can have address information.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    85 views6 pages

    Blood Bank Database Sheet

    Uploaded by

    abcxyz24
    The document defines the entities, attributes, and relationships for a blood donation management system. The key entities include Staff, Addresses, Donars, Recipients, Hospitals, Clinics, Regions, Diseases, Blood, and Donations. The entities have identifying attributes and relationships such as a Donar donating blood that is received by a Recipient. Staff can refer to staff categories and Donars, Recipients, and Hospitals can have address information.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 6

    Entity Name

    Ref_staff_catagories

    Attribute
    staff_catagories_code (PK) staff_catagories_description eg. Doctor, nurse staff_id (PK) address_id (FK) staff_catagories_code(FK) gender staff_job_title staff_first_name staff_middle_name staff_last_name staff_dob other_staff_details address_id (PK) line_1_number_building line_1_number_street line_1_area_locality city zip_postcode state country other_details donar_id (PK) address_id (FK) gender dob first_name middle_name last_name home_phone mobile_phone email_id date_of_reg medical_condition region_id (FK) diseases_id (FK) recipients_id (PK) address_id (FK)

    Staff

    Addressess

    Donars

    Recipients

    gender dob first_name middle_name last_name home_phone mobile_phone email_id date_of_reg region_id (FK) diseases_id (FK) hospital_id (PK) hospital_name region_id (FK)

    Hospital

    Clinic

    clinic_id (PK) clinic_name region_id (FK) region_id (PK) region_name diseases_id (PK) diseases_name

    Region

    Diseases

    Blood

    blood_group (PK) donar_id (FK) recipients_id (FK) status

    Donation

    donation_id (PK) donar_id (FK) no_o_times_donate last_donate tot_unit_donated

    Description
    unique code for staff catagories detail description for staff catagories

    unique id for every staff members

    job name name of staff member date of birth

    Whole addres

    postal code

    unique id for every donar

    date of birth name of donar landline no. mobile no. email id date of registration when donar when donar register himself/herself first time whether he/she is medically fit or not

    unique id for every recipients who needs the blood

    date of registration when donar had registerd himself/herself first time

    unique id for every hospital hospital name

    unique id for every clinic clinic name

    unique id for every region or place region/place name Diseases identification no. Diseases name

    blood group

    status of donated blood whether infected or not

    unique donation id for every donation for every donar how many times the donar donate the blood last donated date by the donar total no unit donated

    S.no.
    1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

    Entity Name
    Staff Staff Diseases Hospital Clinic Donar Recipitants Blood Donar Region Region Region Region Staff Donar Recipitants Staff

    Relationship
    register register contained received received donates receives donated performs has has has has have have have refers

    Entity Name
    Donar Recipitant Blood Blood Blood Blood Blood Donar Donation Donar Recipitant Hospital Clinic Addresses Addresses Addresses Ref_staff_catagories

    You might also like