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 } \\\hline654 & \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 \\\hline\end{array}$$
Write the SQL statement to create a view named CustomerSalesRepView that displays the customer name as CustomerName and the associated sales rep name SaleRepresentativeName from the GENERAL SALES DATABASE.

---

Definitions:

Social Contract

A theoretical agreement within a society in which individuals consent to surrender some freedoms in exchange for protection of essential rights and social order.

Defend

To protect from harm, danger, or challenge through argumentation or physical measures.

Ethics

Principles and standards governing the conduct of individuals or organizations, often reflecting societal values of right and wrong.

Disagree

A situation where two or more parties have differing opinions, perspectives, or choices.