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:

Income Approach

A method of calculating GDP that sums up total national income, including wages, rent, interest, and profits.

Consumer Price Index (CPI)

An indicator used to gauge inflation by examining the weighted average prices of a selection of consumer products and services.

Circular Flow

A model that illustrates the movement of goods, services, and money among households, businesses, government, and the foreign sector in an economy.

Leakages

In economics, it refers to the withdrawal of potential spending from the economy's circular flow, primarily through savings, taxes, and imports.