Translate the ER Diagram for the Animal Pet Rescue Database

Entities:

Donator

DonatorID (Primary Key)

Name

Address

Phone Number

Email

2. Pet

PetID (Primary Key)

Name

Type

Age

DonatorID (Foreign Key)

3. Staff

StaffID (Primary Key)

Name

Email

Phone Number

Employee Number

CenterID (Foreign Key)

4. Center

CenterID (Primary Key)

Name

Location

Phone

Contact Person

Email

5. Rescuer

RescuerID Primary Key)

Name

Email

Phone Number

Home Address

Internal ID

6. Transportation

TransportationID (Primary Key)

Vehicle Type

Pickup Point

Delivery Point

7. Pickup Schedule

PickupID (Primary Key)

DonatorID (Foreign Key)

StaffID (Foreign Key)

TransportationId (Foreign Key)

Pickup Date Time

8. Delivery Schedule

DeliveryID (Primary Key)

RescuerID (Foreign Key)

StaffID ( Foreign Key)

TransportID (Foreign Key)

Delivery Date Time

Relationships:

Donator to pet (One-to-many):

One donor can donate multiple Pets.

Pet has a foreign Key (DonatorID) to link to the Donator.

Center to Staff (One-to -Many):

One Center can have multiple staff members.

Staff has a foreign key (CenterID) to link to the center.

Rescuer to pickup Schedule(One-to-Many):

One rescuer can be scheduled for multiple pickups.

Pickup Schedule has a foreign key (RescuerID) to link to the Rescuer.

Staff to pickup Schedule One-to-Many):

One Staff member can schedule multiple pickups.

Pickup Schedule has a Foreign Key (StaffID) to link to the staff.

Transport to Pickup Schedule(One-to-many):

One Transportation can be associated with multiple pickups.

Pickup Schedule has a foreign key (TransportID) to link to the Transportation.

Rescuer to Delivery Schedule (One-to-Many):

One rescuer can be scheduled for multiple deliveries.

Delivery schedule has a foreign key (RescuerID) to link to the rescuer.

Staff to Delivery Schedule(One-to-Many):

One Staff member can schedule multiple deliveries.

Delivery schedule has a foreign key (StaffID) to link to the staff.

Transport to Delivery Schedule (One-to-Many):

One Transportation can be associated with multiple deliveries.

Delivery Schedule has a Foreign Key (TransportID)to link to the Transportation.