GQ2) (15 points) Convert the attached ER diagram to a Relational Database (i.e. a set of...

Transcribed Image Text:

GQ2) (15 points) Convert the attached ER diagram to a Relational Database (i.e. a set of relation schemas). Reservation Agreement id payment Room number. capacity Contract contract_id date signed details signs has date total area Unstaffed Venue Page 1 of 5 reserves name address organizer Venue id name --Total budget Staff_Member Staffed Venue first name last_name phone_number) parent company date_acquired owned by child company employs K start_date works_on Company name location end_date Job job_id payment GQ2) (15 points) Convert the attached ER diagram to a Relational Database (i.e. a set of relation schemas). Reservation Agreement id payment Room number. capacity Contract contract_id date signed details signs has date total area Unstaffed Venue Page 1 of 5 reserves name address organizer Venue id name --Total budget Staff_Member Staffed Venue first name last_name phone_number) parent company date_acquired owned by child company employs K start_date works_on Company name location end_date Job job_id payment

Answer rating: 100% (QA)

To convert the attached EntityRelationship ER diagram to a Relational Database schema you need to create a set of relational tables that represent the ... View the full answer