Case-Based Critical Thinking Questions

question 2

Multiple Choice

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

---

Definitions:

Duration

The length of time that something lasts or continues, often used in contexts ranging from events and activities to the effectiveness of a product.

Continuous Contemplation

Involves persistent and prolonged thought or reflection on a subject or concept.

Focused Contemplation

Deep reflection or concentration on a specific thought or idea, often for the purpose of reaching a deeper understanding or a decision.

Meditation

A practice of focused concentration or mindfulness, often involving deep breathing, to promote relaxation, awareness, and mental clarity.