Answer:
a- How many customer records are stored in the database
SQL Command for knowing number of customer records are stored is
SELECT COUNT(Customer Name) FROM tbl Customer ;
b- List customers who live in New york.
SQL Command for knowing number of customers who live in New york
SELECT Customer State, FROM tbl Customer WHERE CITY = 'New york' ;
c- List customers who credit limits grater than $50,000.
SQL Command for knowing number of customers who's credit limit is grater than $50,000
SELECT Customer Credit Limit, FROM tbl Customer WHERE Credit limit > 50,000 ;
d. List sales transaction made in July - 18
SQL Command for knowing sales in July - 18
SELECT InvoiceDate, FROM tbl Sales ;
e. What the number of total sales transactions made to each customer
Answer:
a. It focuses on generating new revenue by offering new products and services.
Explanation:
An information system or technology can be defined as a set of components or computer systems, which is used to collect, store, and process data, as well as dissemination of information, knowledge, and distribution of digital products. Thus, an information system or technology interacts with its environment by receiving data in its raw forms and information in a usable format.
Information technology is an integral part of human life because individuals, organizations, and institutions rely on information technologies in order to perform their duties, functions or tasks and to manage their operations effectively. For example, all organizations make use of information systems for supply chain management, process financial accounts, manage their workforce, and as a marketing channels to reach their customers or potential customers.
Additionally, an information system comprises of five (5) main components;
1. Hardware.
2. Software.
3. Database.
4. Human resources.
5. Telecommunications.
Hence, in the context of using information technologies for a competitive advantage over rivals in the industry, the statement which is true of a top-line strategy is that, it focuses on generating new revenue by offering new products and services. The top-line strategy ensures that the company continues to generate gross revenue or sales.
Based on the scenario, the group is definitely still in the Oriented stage of team development.
Orientation stage of team development is also called the Forming Stage because idea or policy are just getting introduced to the new or current employees.
The Orientation stage also entails the introduction of the current employees to new technologies, procedures and policies.
Therefore, the group described in the question is still in the orientation stage of team development.
Read more about orientation stage:
<em>brainly.com/question/14831726</em>
The common denominator for decisions on service processes is customer contact while but for manufacturing processes, it is product variety.
<h3>What is a common denominator?</h3>
This refers to the feature that is shared by all members, item, quantity of a subject matter.
Hence, the common denominator for decisions on service processes is customer contact while but for manufacturing processes, it is product variety.
Read more about common denominator
<em>brainly.com/question/542317</em>
#SPJ12
Answer:
Number of units needed to reach the operating income of 80,000: 5,200 units
Explanation:
Please find the below for detailed calculations and explanations:
To achieve $80,000 of operating income, denote the number of units needs to be sold is x.
For each unit sold, the incremental in profit will be 20.
Thus, to achieve the profit of 80,000, the amount of x units sold will generate the profit before fixed cost that covers 24,000 fixed cost and 80,000 targeted profit. So, we have:
80,000 + 24,000 = 20x <=> x = 5,200 units.
* For quick calculation purpose, we may apply the formular: Units need to be sold to achieve targeted income = (Fixed cost + targeted income)/ Contribution margin per unit in monetary form.
