All categories

2 years ago

1) Write an SQL statement for the HAPPY INSURANCE database that adds the column ClientPhone to the table CLIENT.

Business

1 answer:

Sindrei [870]2 years ago

7 0

An SQL statement for the HAPPY INSURANCE database that adds the column ClientPhone to the table CLIENT is:

ALTER TABLE dbo.CLIENT

ADD ClientPhone

This refers to the use of databases to perform computations such as UPDATE, ADD, ALTER TABLE, etc.

Hence, the use of Structured Query Language would help to add to a database and this would be done using the ALTER TABLES function as shown above.

You might be interested in

Cement Company, Inc. began the first quarter with 1,000 units of inventory costing $25 per unit. During the first quarter, 3,000

3241004551 [841]

Answer:

Calculation of Cost of Goods sold under LIFO:

For 3,000 units (3000*40) $120,000

For 400 units (400*25) $10,000

Add: Excess of replacement cost over historical $8,000

cost of LIFO liquidation (400*(45-25))

Cost of Goods sold under LIFO $138,000

Journal entry

Date Account Titles and Explanation Debit Credit

Cost of Goods sold $138,000

Inventory (120000+10000) $130,000

Excess of replacement cost over $8,000

historical cost of LIFO liquidation

3 0

3 years ago

Which of the following would be an example of mechanical convection?

sdas [7]

Hi!

Option A is correct.

In cooking, convection is the phenomena that causes molecules with a higher energy at the bottom of a container to travel upwards, and the molecules at the top with a lower energy to sink to the bottom and replace them.

Mechanical convection describes this phenomena as a result of the application of an external force.

This phenomena is restricted to substances that are in liquid, or gaseous state, as molecules of a substance in solid state have a very restricted movement.

Hence, options B, C and D are incorrect.

Hope this helps!

3 0

3 years ago

Adel wants to get $100 immediately to pay for concert tickets. He currently has no cash or income, but he has a nice gold watch

mojhsa [17]

Adel could easily just pawn the watch from cash but might not have a 500$ even, I say its B.

3 0

3 years ago

Books Brothers stock was priced at $15 per share two years ago. The stock sold for $13 last year and now it sells for $18. What

qaws [65]

Answer:

D) 38%

Explanation:

The computation of the total return during the most recent year is shown below:

= (Price of stock at the year end 2 - Price of stock at the year end 1) ÷ (Price of stock at the year end 1)

= ($18 - $13) ÷ ($13)

= ($5) ÷ ($13)

= 38.46%

Basically we deduct the price of year end 1 from the price of year 2 and then divide it by price of year end 1 so that the total return could come

7 0

3 years ago

What contractionary monetary policy actions may be used to help reduce inflation?

Nadya [2.5K]

Answer:

The answer is B.

Explanation:

Contractionary monetary policy is a policy adopted by Central banks when the economy is heating up i.e when the economy is moving faster than it can withstand. So this is used to slow down the economy.

There is always a higher inflation and money supply is high when the economy is heating up.

So to contract or slow down the economy, the central banks increase the interest rate, this increase in interest rate discourages borrowing from households, businesses and even commercial banks and when there is a low demand for borrowed fund, money supply (total quantity of money in circulation) decreases.

3 0

4 years ago

Read 2 more answers