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 follow-up donations. To facilitate efficient communication between blood donation centers, hospitals, and recipients for timely blood transfusions.
Donor: (d_ID, d_name, d_sex, d_age, d_Btype, d_mh, d_tNo)
Recipient: (rec_ID, rec_name, rec_age, rec_Btype, rec_Th, rec_sex, rec_tNo, rec_transh)
Appointment: (A_time, A_Name, A_tNo, A_date, A_Location )
Donation: (Bdon_date, Bdon_type, Bdon_quantity)
Inventory: (Inv_Bunit, Inv_Btype, Inv_status)
Hospital: (hosp_ID, hosp_name, hosp_tNo, M_idHosp_phNo)
Center_Info : (C_ID, C_name, C_tNo)
Relation Schemas
Donor table:
\table[[id,d_name,d_age,d_sex,d_Btype,d_mh,d_tNo],[3563,noura,23,F,AB+,clear,23467665],[3963,muneera,29,F,A +,Clear,546786785],[4547,fahad,56,M,B +,Clear,545686422],[K428,monath,12,M,R,Clear,21121548]]
I need an ERD Diagram using ERDplus please The

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!