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.

Apply the concept of sustainability in business through eco-efficiency measures.

Determine the flow of costs in the manufacturing process, including beginning and ending inventories.

Understand the role and calculation of work in process inventory in manufacturing costs.

Distinguish between manufacturing and non-manufacturing costs in a business setting.

---

Definitions:

Non-Controlling Interest

The portion of equity interest in a subsidiary not attributable to the parent company, reflecting the minority shareholders' ownership.

Shareholders' Equity

The amount that would be returned to shareholders if all the company's assets were liquidated and all its debts repaid.

Identifiable Net Assets

The assets of a company that can be clearly identified and quantified on the balance sheet, excluding goodwill.

Shareholders' Equity

The residual interest in the assets of a corporation after deducting its liabilities, representing the owners' claim on the company's assets.