What term refers to the inherent value of the product in the marketplace?

Required: a. How many customer records are stored in the database? b. List customers who live in New York. c. List customers wit

Feliz [49]

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

5 0

3 years ago

How have embedded computers and the IoT impacted your daily life? What additional uses can you see yourself using? What security

Zigmanuir [339]

NOTE: Before discussing the impacts of embedded computers and the IoT, first, let me briefly explain what both of them are in simple words (without any complex jargon) for a better understanding.

Embedded computers are the programmable controllers (or loosely speaking, chips) designed to perform specific or dedicated tasks within a device. They take input (from sensors etc.), process it in a predefined steps (or instructions) and give an output.

The IoT, on the other hand, is the Internet of Things. It is the system of interconnected things that can communicate with one another directly over the network (internet). The word Things in the IoT incorporates an array of objects ranging from devices like digital and security cameras, wearable watches, GPS navigation systems, washing machines, refrigerators to buildings and even cities.

All in all, embedded computers enable the things with the automation capabilities, while the IoT empowers those things with the communication abilities.

(1) Impacts of Embedded Computers and the IoT

In the current era, almost all devices around us have embedded computer(s). Not only that, many of those devices have an ability to connect to the Internet through WiFi. The impacts of embedded computers and the IoT together can easily be understood by the some of the examples, as follows:

Nowadays, we have smart washing machines that not only be able to rinse, wash and dry clothes automatically, economically and efficiently—thanks to the embedded computers—but they can also be controlled remotely or can also send a notification to a mobile phone by the virtue of the IoT. It saves our energy (by automatically washing the clothes), our money (by efficiently using the detergent), resources (by rinsing and washing the clothes with the amount of water required—water conservation) and our time (by being controlled remotely or by sending a notification on a mobile phone when it’s done instead of us checking up its progress every ten minutes or so). In the past, however, laundry used to be done manually, which was not only a time consuming and tiring task, but it was also an ineffective way for the resource conservation.
Finding a nearby cab is now in the palm of our hands. Modern cab service providers, via their mobile applications, share the location of their cabs, in which the GPS navigation system (consists of GPS module and the embedded computer(s), connected with the internet). Hence, without any hassle, a nearby cab can be arranged and also at any time. The same applies on the most, modern bus services. Before that, one had to be physically on the road to find the cab with no surety of getting one. Now, beforehand, you can book your ride.
Smart door locking systems and smart security cameras inside or outside homes are able to notify the authorities or to the owners in the case of intrusion, and, thus, making lives and possessions safe and secure. Previously, although security cameras and locking systems were there, they couldn’t communicate with other devices (like mobile phones) remotely. A person had to be physically in the house to see the camera feed or to hear the intrusion alarm.
Embedded computers and the IoT is revolutionising the quality of life in terms of health. The IoT based smart-bands or watches can continuously monitor the blood pressure and heart rate in real time through the IoT based devices with embedded computers connected with the sensors. In the case of emergency, those IoT based devices send a notification to the emergency contacts. In the past, there was no way of checking your ECG at home—let alone the question of automatically sending ECG report to the emergency contacts.

In a nutshell, embedded computers and the IoT have impacted our daily lives in a meaningful and constructive way.

(2) Additional Uses

Well, this part of the question cannot be answered in a generic way; therefore, let me give you my opinion on that.

I am seeing myself using the IoT based learning devices like Google Nest thermostat. It uses machine learning to automatically set the optimal temperature of the home.

Ease: To change the temperature, there is no need to be physically there where the thermostat is installed.

Saving: It automatically turns off when there is no person in the home, which is a big plus for saving some extra bucks.

Furthermore, I can see myself using the smart IoT based weight machine that would warn me to stop getting out of shape based on my weight; in the case of non-compliance, it would send my weight as a post to all of my social media accounts. ;)

(3) Security or Other Risks

The privacy would be the major concern (and could be compromised with the usage of IoT). As in the IoT based systems, everything is connected to the internet. Therefore, all the cybersecurity risks and issues are applied on the IoT as well.

The more IoT based devices increase in number, the more the complexity of handling those devices would increase, which may become a bane instead of a boon to a user.

6 0

3 years ago

What is the effect on total assets and stockholders' equity of paying the telephone bill as soon as it is received each month?

Archy [21]

Answer:

Option C) Decrease in Total Assets , and No Effect on Equity

Explanation:

Telephone bill it's a Current Liability , if you decide to pay it as soon as you receive it you have to use Cash which is part of your Current Asset, so the impact it's a decreased in your Current Assets through the Cash component.

This movement has no impact in the Sotckholder Equity.

6 0

3 years ago

The COB Division of Northern Corp. produces and sells a product to both external customers and other Northern divisions. Per-uni

svetoff [14.1K]

Answer:

$425

Explanation:

Data provided as per the question

Direct material = $350

Direct labor = $75

The computation of transfer price should be set is shown below:-

Transfer price should be = Direct materials + Direct labor

= $350 + $75

= $425

Note :- The minimum transfer price shall be "Variable Rate" if there is an excess capacity to produce for internal transfer.

8 0

3 years ago

The price of wheatwould be â$nothingper bushelif there was no price support. In order to maintain the priceâ support, the govern

horrorfan [7]

Answer:

$5, 200 bushels of wheat

Explanation:

From the diagram the price support was at $6 per bushel, however if the government removes the price support or if there was no price support, then the price of the wheat will be $5 for a bushel. And in order to maintain the price support, from the diagram below, it is expected that the government would have to purchase 200 bushels of wheat.

4 0

3 years ago