Use the Database Below to Answer the Following Question CUSTOMER

question 50

Essay

Use the database below to answer the following question.
GENERAL SALES DATABASE:
SALESREP
$$\begin{array} { | l | l | l | } \hline \text { SalesRepNo } & \text { RepName } & \text { HireDate } \\\hline 654 & \text { Tones } & 01 / 02 / 1999 \\\hline 734 & \text { Smith } & 02 / 03 / 2000 \\\hline 345 & \text { Chen } & 01 / 25 / 1998 \\\hline 434 & \text { Tohnson } & 11 / 23 / 1998 \\\hline\end{array}$$
CUSTOMER
$$\begin{array} { | l | l | l | l | } \hline \text { CustNo } & \text { CustName } & \text { Balance } & \text { SalesRepNo } \\\hline 9870 & \text { Winston } & 500 & 345 \\\hline 8590 & \text { Gonzales } & 350 & 434 \\\hline 7840 & \text { Harris } & 800 & 654 \\\hline 4870 & \text { Miles } & 100 & 345 \\\hline\end{array}$$
What is an SQL view,and what is it used for? Include an example based on the CUSTOMER table of the General Sales Database.

---

Definitions:

Reader's Attention

The focus or interest of a reader that is captured by compelling content, design, or subject matter.

Deliver Bad News

The process of communicating unfavorable information in a sensitive and thoughtful manner.

Indirect Approach

A communication strategy that involves presenting the main message after providing the background information, rationale, or reasoning.

Emotional Investment

The extent of emotional energy, interest, or commitment one puts into a task, relationship, or issue.