1 having M M Volunteer VolunteerShift Position hires M has Pending NonPending M Event 1 has Location M has 1 1 has has has VolunteerClass Workshop CommunityContact M GuestSpeaker has GuestSpeakerShift
Topic:
Please convert the below diagram to Crow's Foot notation. Here is the relational schema:
Relational Diagram (Schema)
Position:
Position_ID |
Title |
Volunteer:
Person_ID |
Gender_ID |
Occupation |
Status |
Notes |
Position_ID |
Location:
Location_id |
Location_Name |
Street_No |
Street_Name |
PostalCode |
Phone |
CommunityContact:
Organization_ID |
Person_ID |
Notes |
Location_ID |
Event:
Event_ID |
Type |
Event_Date |
Location_Name |
Location_ID |
VolunteerShift:
Shift_ID |
Start_Time |
End_Time |
Event_ID |
Person_ID |
Pending:
Pending_ID |
CV |
Cover_Letter |
Interview |
VolunteerClass:
VolunteerClass_ID |
Training_Graduation_Date |
NonPending:
Person_ID |
Active |
Date_Inactive |
VolunteerClass_ID |
Workshop:
Workshop_ID |
Event_ID |
Name |
GuestSpeaker:
Event_ID |
Person_ID |
Subject_ID |
GuestSpeakerShift:
Event_ID |
Person_ID |
Subject_ID |
Start_Time |
End_Time |
Step by step
Solved in 2 steps with 1 images