Use the Database Below to Answer the Following Question CUSTOMER

question 36

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 { Jones } & 01 / 02 / 1999 \\\hline 734 & \text { Smith } & 02 / 03 / 2000 \\\hline 345 & \text { Chen } & 01 / 25 / 1998 \\\hline 434 & \text { Johnson } & 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\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:

Defamation

A false communication, either spoken (slander) or written (libel), that injures someone's reputation by lowering them in the estimation of the community.

Misrepresentation

The act of giving a false or misleading statement about a material fact, with the intent to deceive or mislead.

Observable Behaviors

Actions or reactions of an individual in various situations, that are visible and can be measured or recorded.

Reference Checks

The process of contacting a job applicant's previous employers, colleagues, or other contacts to gain insights into their employment history, qualifications, and character.