Case-Based Critical Thinking Questions

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.
-A join that relates records from the Bus Number table with the Bus Routes table based on the same Bus ID is an example of a(n) ____ join.

A) inner
B) outer
C) self
D) common