Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Draw an ERD diagram like picture i loaded by using this: ERD ( Entity - Relationship Diagram ) Tables and their attributes: Patient ID (
Draw an ERD diagram like picture i loaded by using this: ERD EntityRelationship Diagram
Tables and their attributes:
Patient ID primary key
Patient Name
Patient Blood Group
Patient Disease
Hospital ID foreign key
Donors
Donor ID Primary Key
Donor Name
Donor Blood Group
Donor Medical Report
Donor Address Donor
Contact Number
Blood Bank ID Foreign Key
Blood banks
Blood Bank ID Primary Key
Blood Bank Name
Blood Bank Address
Blood Bank Contact Number
Doctors
Doctor ID Primary Key
Doctor Name
Doctor Specialization
Hospital ID Foreign Key
Blood Inventory
Inventory ID primary key
blood bank id foreign key
blood group units available expiration date
blood tests
Test ID Primary Key
Donor ID Foreign Key
Test Date
Test Results
Hospitals
Hospital ID primary key
Hospital Name
Hospital Address
Hospital Contact Number
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started