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.
-After the first week of beginning soccer, some children have decided not to continue playing and children on the wait list have been added to teams with openings. What type of query would help Keisha add the new players to her current Participant table?
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.
-After the first week of beginning soccer, some children have decided not to continue playing and children on the wait list have been added to teams with openings.  What type of query would help Keisha add the new players to her current Participant table?
A)make-table
B)append
C)delete
D)update

Quizplus · Accepted Answer

An append query would add new records (in this case, new participants) to an existing table. This would allow Keisha to easily add the new children to the database without having to manually enter their information. The other options (make-table, delete, update) do not apply to this situation.