Use the Database Below to Answer the Following Question CUSTOMER

question 60

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}$

Using the CUSTOMER.Balance 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:

Historical Architectural Styles

refer to the distinct characteristics in the design and construction of buildings and structures over various periods and cultures throughout history.

Houses of Parliament

The iconic building located in London, containing the House of Commons and the House of Lords, central to the UK's parliamentary democracy.

Neo-Gothic

The revival of the Gothic style in architecture, especially in the 19th century.

Crystal Palace

A large glass and iron structure built in London for the Great Exhibition of 1851, showcasing the latest technology of the time.