Case-Based Critical Thinking Questions
Case 9-1
Keisha is completing an internship with the local parks and recreation department. She has been asked to update and maintain the beginning soccer league database for children ages 3-4. The league consists of over 150 children and 10 soccer teams. The teams play at two different soccer fields in the city. The database already exists from last year so Keisha will not be developing the database. She will only make changes as necessary to the current database.
-Keisha's supervisor has asked that she provide her with a table showing all of the soccer teams and the team schedules. This table will only be used once to schedule coaches. Which type of query should Keisha run?
A)make-table
B)append
C)delete
D)update

Question

Case-Based Critical Thinking Questions
Case 9-1
Keisha is completing an internship with the local parks and recreation department.  She has been asked to update and maintain the beginning soccer league database for children ages 3-4.  The league consists of over 150 children and 10 soccer teams.  The teams play at two different soccer fields in the city.  The database already exists from last year so Keisha will not be developing the database.  She will only make changes as necessary to the current database.
-Keisha's supervisor has asked that she provide her with a table showing all of the soccer teams and the team schedules.  This table will only be used once to schedule coaches.  Which type of query should Keisha run?
A)make-table
B)append
C)delete
D)update

Quizplus · Accepted Answer

Keisha needs to create a new table showing all of the soccer teams and their schedules. The make-table query will allow her to create a new table from the existing database, which she can then modify and use to schedule coaches. The other query options (append, delete, and update) do not apply to Keisha's task of creating a new table.