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:

In some cases, students who have academic approval but not a
signed liability form can play intramural sports. However, students who do not
have academic approval cannot participate in intramural sports. At the
beginning of each semester, the department receives a list of students who are
not approved to play sports. The staff records that information in the student
table. They want to remove the students who do not have academic approval from
the table. Marianna asks you to identify students who do not have academic
approval, isolate them in a separate table named tblUnapprovedStudents, and
then remove them from the student table, which should contain only those
students who have been academically approved. Name the queries
qryUnapprovedStudents and qryDeleteUnapprovedStudents as appropriate.

»