Latham Works in the Logistics Department for a Large City

question 37

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

---

Definitions:

Strategies

Broad plans or sets of actions designed to achieve specific goals or outcomes within an organization or individual endeavor.

Commission-Based

A payment model where compensation is tied directly to performance, such as the amount of sales generated or the success in meeting specified goals.

Internet Business Model

A plan for earning revenue and profit through online operations, which includes various frameworks such as e-commerce, advertising, subscription services, and freemium.

Distribution Efficiencies

Refers to the optimization of processes and systems for distributing products or services to reduce costs and improve speed and reliability.