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 first report Carmen would like to create will include all participants and the balance due to participate in the Spring Fling. Which two tables should Carmen use to create the report?
A) ParticipantAccount and RequestedResources
B) ParticipantAccount and Location
C) ParticipantInformation and ParticpantAccount
D) Location and RequestedResources

Question

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 first report Carmen would like to create will include all participants and the balance due to participate in the Spring Fling. Which two tables should Carmen use to create the report?
A) ParticipantAccount and RequestedResources 
B) ParticipantAccount and Location 
C) ParticipantInformation and ParticpantAccount 
D) Location and RequestedResources

Quizplus · Accepted Answer

Carmen should use the ParticipantInformation table to retrieve participant names and the ParticipantAccount table to retrieve the balance due from each participant. The other tables do not contain the necessary information for the report.

Carmen and Sergio Have Created a Database for the Spring