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.
-Parents of some of the beginning soccer players have requested that their children be moved to a team that plays at the field closest to their home. To modify the team field in the current Beginner Soccer League database, Keisha can run a(n)____ query.
A)delete
B)update
C)make-table
D)append

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.
-Parents of some of the beginning soccer players have requested that their children be moved to a team that plays at the field closest to their home.  To modify the team field in the current Beginner Soccer League database, Keisha can run a(n)____ query.
A)delete
B)update
C)make-table
D)append

Quizplus · Accepted Answer

To modify the team field in the current Beginner Soccer League database, Keisha can run an UPDATE query. This query will allow her to change the field information for specific teams, based on the preferences of the parents. The other options (delete, make-table, and append) would not be appropriate for this task. Delete would remove data from the database, make-table would create a new table rather than modify an existing one, and append would add new data rather than changing existing data.