Examlex

Solved

Case-Based Critical Thinking Questions Case 4-2

question 29

Multiple Choice

Case-Based Critical Thinking Questions Case 4-2
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.
Case-Based Critical Thinking Questions Case 4-2 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
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?


Definitions:

Francis Crick

A British molecular biologist, biophysicist, and neuroscientist, best known for co-discovering the structure of the DNA molecule in 1953 with James Watson.

Hereditary Material

Genetic information passed from parents to offspring, primarily consisting of DNA or RNA in certain viruses.

DNA

A double-stranded molecule consisting of nucleotides arranged in a helical structure, serving as the hereditary material in most organisms.

Purines

Nitrogenous bases found in DNA and RNA that include adenine (A) and guanine (G), playing a crucial role in encoding genetic information.

Related Questions