You Have a Database Containing Customer Information, Including Orders, for a Small

question 47

Essay

You have a database containing customer information, including orders, for a small retail store where you work. The database is relational and the database designer organized the tables so that the columns contain only single pieces of information. For example, the names of customers take up to three fields (First, Middle, and Last Name). Naming conventions in the database use uppercase characters for each word in a field name.
Describe how you can create a report that lists only the Last Name and Phone Number for each customer in your database.

---

Definitions:

Selling Price

The amount of money a buyer pays to purchase a product or service from a seller.

LIFO Cost Flow

An inventory valuation method, "Last In, First Out", where the last items placed in inventory are the first ones to be recorded as sold, affecting the company's inventory cost on financial statements.

Ending Inventory

The cumulative worth of a company's entire stock inventory at the conclusion of a financial accounting period.

Inventory Items

Goods or materials a company holds for the ultimate purpose of resale.