Use the Database Below to Answer the Following Question CUSTOMER

question 71

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 \\\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:

Productivity

The effectiveness in producing outcomes or results; can refer to the rate at which work is completed or the efficiency of resource use.

Output

The total amount of goods or services produced by a firm, industry, or economy within a specific period.

MRP Schedule

A document or plan that outlines the marginal revenue product of an input, showing how changes in quantity of the input affect revenue generated.

Perfect Competitor

An individual or company that cannot influence the market price because the market is saturated with similar products, acting within a perfectly competitive market.