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.
-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
Correct Answer:

Verified
Correct Answer:
Verified
Q2: Case-Based Critical Thinking Questions<br>Case 9-2<br>Latham works in
Q6: Matching
Q8: Records deleted using a Delete query are
Q9: Case-Based Critical Thinking Questions<br>Case 9-3<br>Taylor manages a
Q20: To access the Edit Relationships dialog box
Q21: Inner,outer,and self are all types of <u>queries</u>.
Q49: A(n)_ value is not allowed in an
Q57: Is it a good idea to save
Q64: A new table created by a(n)_ query
Q68: A make-table query is a(n)_ query that