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
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 with AI-Powered 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