USING THE BELOW PICTURE CREATING AN ER DIAGRAM AND SHOW THE RELATIONSHIP.

Identify entities: From the given tables, we can identify the following entities:

• Donor
• Blood Unit
• Blood Request
• Blood Donation Camp
• Blood Bank
• Staff

Identify relationships: After identifying entities, we need to identify the relationships between these entities. From the given tables, we can identify the following relationships:

• Donor donates Blood Unit
• Blood Unit belongs to Donor
• Blood Request needs Blood Unit
• Blood Unit fulfills Blood Request
• Blood Donation Camp organizes Blood Unit donation
• Blood Bank collects and distributes Blood Units
• Staff works at Blood Bank and Blood Donation Camps

 

1. . . Donor: Donor ID (Primary Key) Name Gender Age Blood type Contact information . 2. Blood Unit: . Entities and Attributes . 3. Blood Request: Blood Unit ID (Primary Key) Blood type Expiry date Volume Donor ID (FK) Request ID (Primary key) Patient name Blood type Volume Request date Delivery date Hospital name 4. Blood Donation Camp: Camp ID (Primary Key) Location Date . . . . . Organizer name Contact information 6. Staff: . Blood Bank: Bank ID (Primary Key) Name Location . Contact information 5. . . Staff ID (Primary Key) Name Gender Age Contact information Job position