Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Question
Use the database below to answer the following question.GENERAL SALES DATABASE:
SALESREP
| SalesRepNo | RepName | HireDate |
| 654 | Jones | 01/02/1999 |
| 734 | Smith | 02/03/2000 |
| 345 | Chen | 01/25/1998 |
| 434 | Johnson | 11/23/1998 |
CUSTOMER
| CustNo | CustName | Balance | SalesRepNo |
| 9870 | Winston | 500 | 345 |
| 8590 | Gonzales | 350 | 434 |
| 7840 | Harris | 800 | 654 |
| 4870 | Miles | 100 | 345 |
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.
Answer
This answer is hidden. It contains 174 characters.
Related questions
Q:
What are the elements of a graph database?
Q:
What is an XML DTD?
Q:
What is XML, and why is it significantly better than HTML?
Q:
Graph databases are composed of ________.
Q:
XML documents that conform to their DTD are said to be ________.
Q:
The CAP theorem defines the three properties of ________, ________, and ________.
Q:
The document type declaration for an XML document begins with the keyword ________.
A) XML
B) DTD
C) TYPE
D) DOCTYPE
E) TYPEDECL
Q:
An example of a document database is ________.
A) Dynamo
B) Couchbase Server
C) Bigtable
D) Neo4j
E) MySQL
Q:
Graph databases are composed of three elements, one of which is the edge.
Q:
In XML Schema, there are two types of elements, simple and composite.
Q:
XML documents and XML Schemas are created in different languages.
Q:
XML documents that conform to an XML Schema are validated against that schema.
Q:
XML documents that do not conform to their DTD are said to be non-type-valid XML documents.
Q:
JSON stands for Jason Script Object Notation.
Q:
The CAP theorem defines the three properties, one of which is authorization.
Q:
What is data mining application?
Q:
Market basket analysis, as described in the text, uses the statistical technique of ________.
Q:
A report that is sent to users on a predetermined schedule is called a(n) ________ report.
Q:
Refer to the table above. What is the confidence of Drug B being purchased given that Drug A has been purchased?
A) .200
B) .250
C) .333
D) .400
E) .500
Q:
Refer to the table above.What is the support for Drug A and Drug B?
A) .025
B) .075
C) .100
D) .125
E) .200
Q:
A report generated by a reporting system is delivered to the appropriate users via a printed report. This system uses which of the following report modes?
A) Push
B) Pull
C) Query
D) OLAP
E) None of the above
Q:
A BI reporting system:
A) creates meaningful information from disparate data sources.
B) delivers information to users on a timely basis.
C) uses statistical procedures to predict future events.
D) Both A and B
E) All of the above
Q:
In unsupervised data mining, explanations are created after patterns are found.
Q:
A report that is sent to users only upon the users' request is called an on-demand report.
Q:
A report that is sent to users on a predetermined schedule is called a push report.
Q:
Reports that rely on the most current data when they are prepared are called dynamic reports.
Q:
Report modes include dynamic and static.
Q:
Below installing the NetBeans IDE, we have to install ________.
A) the Java JRE
B) the Java SDK
C) the Java JDK
D) the Java SRE
E) Any of the above will work.
Q:
There is only one way to install PHP.
Q:
When running the NetBeans IDE for the first time, use a file workspace named NetBeansProjects.