Recall that you are working on a database for the intramural department at Hershey College, under…

Recall that you are working on a database for the intramural
department at Hershey College, under the direction of Marianna Fuentes. The
department is preparing for its first semester of operation and needs to set up
teams for each sport, manage the equipment and fields for each sport, keep
track of coaches and team captains, and allow students to sign up for the
sports offerings.

Marianna has interviewed the intramural staff to determine
the data needs of the department. She has prepared a list of those needs. Your
next task is to create lists that meet the operational needs of the
»

Recall that you are working on a database for the intramural
department at Hershey College, under the direction of Marianna Fuentes. The
department is preparing for its first semester of operation and needs to set up
teams for each sport, manage the equipment and fields for each sport, keep
track of coaches and team captains, and allow students to sign up for the
sports offerings.

Marianna has interviewed the intramural staff to determine
the data needs of the department. She has prepared a list of those needs. Your
next task is to create lists that meet the operational needs of the department.
For each list, Marianna asks you to give the columns a descriptive name so that
it is clear what each column contains.

Complete the following:

Recall that students must sign a waiver of liability and
maintain academic approval before they can play an intramural sport. The
department wants to have a list showing students and these two ratings. If a
student has submitted a signed waiver and academic approval forms, indicate
that they are approved to play. If the student has not submitted both forms,
indicate that they are not approved to play. Organize the list so that those
with approval are grouped at the beginning. Save the query as qryApprovalStatus.

»