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.
-The relationship between the Bus Number and the Bus Routes tables is one-to-many which means that each Bus Route record is connected to _____ Bus Number record(s).
A)at most one
B)at least one
C)exactly one
D)zero, one, or more

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.
-The relationship between the Bus Number and the Bus Routes tables is one-to-many which means that each Bus Route record is connected to _____ Bus Number record(s).
A)at most one
B)at least one
C)exactly one
D)zero, one, or more

Quizplus · Accepted Answer

The relationship between the Bus Number and the Bus Routes tables is one-to-many, which means that each Bus Route record is connected to at most one Bus Number record.