Case-Based Critical Thinking Questions

question 72

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

---

Definitions:

Data Entry

The process of inputting data or information into a computer system or electronic database.

Specified Guidelines

Guidelines or rules that have been outlined or defined with specific details or for a particular purpose.

Table

A structured arrangement of data made up of rows and columns, which can be used in documents, databases, or HTML code for displaying information.

Related Records

Records in a database that are connected to one another through a common piece of information, facilitating the organization and retrieval of information.