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:

Popular Democracy

A form of governance where the power lies directly in the hands of the people, typically exercised through voting and participation in policy-making.

Epistemological

Relating to the theory of knowledge, especially with regard to its methods, validity, and scope, and the distinction between justified belief and opinion.

Interpretation

The process of explaining or understanding the meaning of something, often used in contexts of law, literature, art, and data analysis.

Elite Democracy

A model of democracy in which a small number of people, usually those who are wealthy or well-educated, influence political decision making.