ASSIGNMENT NO 01
Project Name: BLOOD BANK SYSTEM
Session: 2023-2027
(Reg. No. Applied for)
Submitted to:
Sir Mehtab Mushtaq
Subject: DATABASE SYSTEMS
Submitted By:
Saim Haseeb(02), Araish Majid(04), Abdullah Amjad(51)
DEPARTMENT OF AI
BLOOD BANK SYSTEM
Registration No:
(2023-UOK-04847); (2023-UOK-04804); (2023-UOK-04802); (2023-
UOK-04851)
Submitted to:
Prof. Mehtab Mushtaq
Subject: DATABASE SYSTEMS
Session:2023-2027
Submitted By:
Zafar iqbal(47), Araish Majid(04), Saim Haseeb(02),
Abdullah Amjad(51)
DEPARTMENT OF ARTIFCIAL INTELLIGENCE FACULTY OF
COMPUTING AND ENGINEERING UNIVERSITY OF KOTLI
AZAD JAMMU AND KASHMIR
Table of Contents
Entity………………………………………………………………………………………….01
Attribute………………………………………………………………………………………01
Relations….…………………………………………………………………………………..02
ERD diagram……..……………………………………………………………………….….03
Entities:
1. Admin
2. Donor
3. Blood Inventory
4. Blood Request
5. Hospital
6. Summary_Report
Attributes:
1. Admin (Admin _ID(pk),Full_name,Eamil.Phone_Number)
2.Donor(Donor_ID, Full_Name, Date_of _Birth,
- Blood _Group, Last _Donation Date, - Phone_Number, Address, Email, Weight, Pulse,
Hemoglobin (Hb), Blood Pressure (BP), Temperature, Previous Donation (Yes/No))
3.Blood Inventory( Inventor_ ID, Blood_Group, Quantity, Expiry_Date ,Date _of _Stock_ In
,Date _of _Stock _Out,Status)
4.Blood Request( Request_ ID , Request _Date, Hospital_Name, BloodGroup_Requested ,
Quantity_Requested, Status)
5.Hospital(Hospital_ID, Hospital_Name,Contact _Person, Phone_Number ,Email ,Address)
6.Summary Report (Report_ID, Report_Date, Blood _Donations, Blood _Requests,
BloodInventory _Status)
Relations:
Admin to Donor:
One-to-Many
Admin to Blood Inventory:
One-to-Many
Admin to Blood Request:
One-to-Many
Donor to Blood Inventory:
Many-to-One
Blood Request to Blood Inventory:
One-to-Many
1
Blood Request to Hospital:
One-to-One
ERD diagram:
