Latham Works in the Logistics Department for a Large City

Multiple Choice

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