Carmen and Sergio Have Created a Database for the Spring

Multiple Choice

Carmen and Sergio have created a database for the Spring Fling event at their college. Sergio created forms for Carmen to use when entering data into the database. Carmen needs to create some reports to update the faculty sponsor on the progress that has been made planning the event. The tables and fields for the database along with established relationships are illustrated in the figure below.

-The faculty sponsor has asked Carmen to create a report that includes the participant email address and the location site assigned to the participant. He would also like to know how many tables and chairs each participant needs. Which tables and fields does Carmen need to use to create the report?

A) ParticipantInformation:Email
ParticipantAccount:ParticipantID
RequestedResources:TableQuantity
RequestedResources:ChairQuantity
B) ParticipantInformation:Email
ParticipantAccount:LocationSite
RequestedResources:TableQuantity
RequestedResources:ChairQuantity
C) ParticipantInformation:ParticipantID
Location:LocationSite
RequestedResources:TableQuantity
RequestedResources:ChairQuantity
D) PatientAccount:LocationSite
Location:ParticipantID
RequestedResources:TableQuantity
RequestedResources:ChairQuantity