Case-Based Critical Thinking Questions
Case 9-2
Latham works in the logistics department for a large city bus system. As routes are changed, Latham accesses the internal database to ensure all records are accurate. The Bus Route System database includes a one-to-many relationship between the Bus Number and the Bus Routes with Bus ID as the common field. This allows the two tables to be joined to create a query based on data from both tables: Bus Number and Bus Routes.
-Latham often has to look up bus routes based on specific bus stops. To speed up the search process in this large database, he might want to create a(n)____ for the Bus Stop field in the Bus Routes table.
A)update query
B)outer join
C)index
D)self-join

Question

Case-Based Critical Thinking Questions
Case 9-2
Latham works in the logistics department for a large city bus system.  As routes are changed, Latham accesses the internal database to ensure all records are accurate.  The Bus Route System database includes a one-to-many relationship between the Bus Number and the Bus Routes with Bus ID as the common field.  This allows the two tables to be joined to create a query based on data from both tables:  Bus Number and Bus Routes.
-Latham often has to look up bus routes based on specific bus stops.  To speed up the search process in this large database, he might want to create a(n)____ for the Bus Stop field in the Bus Routes table.
A)update query
B)outer join
C)index
D)self-join

Quizplus · Accepted Answer

Latham should create an index for the Bus Stop field in the Bus Routes table to speed up the search process. An index is a data structure that improves the speed of data retrieval operations on a database table at the cost of slower writes and increased storage space. In this case, creating an index for the Bus Stop field would allow for quicker lookups based on specific bus stops. Neither an update query, outer join, nor self-join would improve the search process in this scenario.