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

Question

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

Quizplus · Accepted Answer

An inner join is used to combine only the matching records from both tables based on a common field, in this case, the Bus ID. It is the most common type of join used in database queries. The other options, outer join, self join, and common join, are not applicable in this scenario as they either include non-matching records or involve the same table being joined with itself.