Case-Based Critical Thinking Questions

question 2

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.
-Latham often has to look up bus routes based on specific bus stops.  To speed up the search process in this large database, he might want to create a(n) ____ for the Bus Stop field in the Bus Routes table.

• A)update query
• B)outer join
• C)index
• D)self-join

Differentiate between revenue expenditures and capital expenditures.

Calculate and interpret total asset turnover.

Recognize the impact of obsolescence and inadequacy on plant assets.

Understand the treatment of leasehold improvements and their amortization.

---

Definitions:

Property Taxes

Taxes levied by local government on real estate properties, based on the assessed value of the property.

Vendor

A person or company offering something for sale, especially a trader in the goods or services sector.

Purchaser

An individual or entity that buys goods or services.

Prorated Refund

A return of a portion of a payment, calculated based on the proportion of a service or good that was not used or was unusable.