Use the Database Below to Answer the Following Question CUSTOMER

question 47

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}$$
Using the CUSTOMERBalance column as the column providing the data,create a view to display the results of a computed column.Specifically,assume that all customers are required to maintain a minimum balance of 100,and use the view to display customer name and a number named BalanceOverMinimum that calculates (Balance - 100)for all customers in the GENERAL SALES DATABASE.

---

Definitions:

Autonomous Motivation

The drive to engage in an activity out of genuine interest or internal value, rather than external pressures or demands.

Cultures

The collective norms, values, beliefs, and customs of a group of people that distinguish them from other groups.

Equality Norm

A principle that advocates for equal treatment and fairness among members of a group or society.

Reward Allocation

A system or process in which rewards such as bonuses, promotions, or other incentives are distributed to employees based on their performance or achievements.