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

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

Creating an index for the Bus Stop field in the Bus Routes table will improve the search speed for Latham when looking up bus routes based on specific bus stops. This will create an efficient way to access the data in the large database, making Latham's job easier and faster. The options of update query, outer join, and self-join are not relevant in this scenario.

Latham Works in the Logistics Department for a Large City