Angie and Neal Fry Are Department Managers in the Housewares

question 246

Essay

Angie and Neal Fry are department managers in the housewares and shoe departments, respectively, for Calhouns, a large department store. Neal has observed Angie taking inventory from her own department home, apparently without paying for it. He hesitates confronting Angie because he is due to be promoted, and needs Angie's recommendation. He also does not want to notify the company management directly, because he doesn't want an ethics investigation on his record, believing that it will give him a "goody-goody" image. This week, Angie tried on several pairs of expensive running shoes in his department before finding a pair that suited her. She did not, however, buy them. That very pair was missing this morning.
Calhouns recently replaced its old periodic inventory system with a perpetual inventory system using scanners and bar codes. In addition, the annual inventory is to be replaced by a monthly inventory conducted by an independent firm. On hearing the news of the changes, Neal relaxes. "The system will catch Angie now," he says to himself.
Required:
1. Is Neal's attitude justified? Why or why not?
2. What, if any, action should Neal take now?

---

Definitions:

Self Join

A join in SQL where a table is joined to itself to compare rows within the same table.

Parent Table

A table in a database that has one or more related child tables through a foreign key relationship, establishing a hierarchy.

Child Table

A table in a database that has a foreign key linking to the primary key of another table, known as the parent table.

Table Structure

The organization of data in rows and columns in a relational database or spreadsheet.