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 Bus Routes tables is one-to-many which means that each Bus Number record is related to ____ Bus Routes record(s) .
A) at most one
B) at least one
C) exactly one
D) zero, one, or more
Correct Answer:

Verified
Correct Answer:
Verified
Q6: The type of join in a relationship
Q11: When a new table is created using
Q17: _ queries are often used to append
Q46: A table created using the make-table query
Q55: Only one existing table may be used
Q66: In the design grid of an append
Q67: Case-Based Critical Thinking Questions<br>Case 9-1<br>Keisha is completing
Q71: Access databases may only contain<u> one-to-one </u>relationships
Q72: Case-Based Critical Thinking Questions<br>Case 9-2<br>Latham works in
Q75: Matching