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:

Manufacturing Process

A series of steps involved in the production of goods, typically involving raw materials, machinery, and labor to create finished products.

Day-to-Day Operations

Routine activities and tasks necessary for the ongoing functioning of a business or organization.

Work in Process Inventory

Goods that are partially completed in the production process, including the accumulation of labor, material, and overhead costs.

Manufacturing Costs

Expenses related to the production of goods, including direct materials, direct labor, and manufacturing overhead.