Question: I need an ERD Diagram using ERDplus please The primary goal of the Blood Donation Database project is to create a comprehensive database system that
I need an ERD Diagram using ERDplus please
The primary goal of the Blood Donation Database project is to create a comprehensive database system that efficiently manages the process of blood donation, including donor registration, blood inventory management, and tracking of blood donations.
The objectives of the project are as follows:
To create a centralized system for managing donor information, including personal details, medical history, and donation records. To develop a robust inventory management system for tracking blood units, including storage location, expiration dates, and donation type whole blood, plasma, platelets
To establish a streamlined process for scheduling donation appointments, managing donor eligibility, and sending reminders for followup donations. To facilitate efficient communication between blood donation centers, hospitals, and recipients for timely blood transfusions.
Donor: dID dname, dsex, dage, dBtype, dmh dtNo
Recipient: recID recname, recage, recBtype, recTh recsex, rectNo, rectransh
Appointment: Atime, AName, AtNo, Adate, ALocation
Donation: Bdondate, Bdontype, Bdonquantity
Inventory: InvBunit, InvBtype, Invstatus
Hospital: hospID hospname, hosptNo, MidHospphNo
CenterInfo : CID Cname, CtNo
Relation Schemas
Donor table:
tableiddname,dage,dsex,dBtype,dmhdtNonoura,FABclear,muneera,FA Clear,fahad,MB Clear,Kmonath,MRClear,
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
