All categories

1 year 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]1 year 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

The president of the Micro Brewing Corporation asks you, as the company economist, to forecast changes in consumer beer purchase

umka21 [38]

Answer:

It is more profitable to raise the selling price by $2.

Explanation:

To determine whether the company should raise the selling price, we need to determine the effect on income. <u>The best option is the one with the higher sales revenue.</u>

Sales revenue= selling price * number of units

<u>Current:</u>

Sales revenue= 5.5*2,200= $12,100

<u>Proposal:</u>

Sales revenue= 7.5*1,800= $13,500

It is more profitable to raise the selling price by $2.

7 0

3 years ago

Mara is a management consultant for a soda manufacturer that wants to expand into health drinks such as green tea and after-work

kirill115 [55]

Answer:

B. "Carefully consider the entry choices over time before making a decision."

Explanation:

Since Mara company specializes in manufacturing sodas, venturing into health drinks is risky and therefore would need a lot of planning, thorough analysis of the target market . Looking into whether there's sufficient demand for it and forecasting future trends with regards to health drinks is also important . Mara should therefore, test venture into this by testing the market and considering entry choices over time before making a decision.

6 0

3 years ago

Inventory Ratio Calculations

tatuchka [14]

Answer:

Inventory Turnover Ratio for 2008= 3.223 Times

Inventory Turnover Ratio for 2009= 3.91 times

Explanation:

Inventory Turnover Ratio= Cost of Goods Sold / Average Inventories

Inventory Turnover Ratio for 2008= $632,000/ $201,000 + 191,100/2

Inventory Turnover Ratio for 2008= $632,000/196,050

Inventory Turnover Ratio for 2008= 3.223 times

Inventory Turnover Ratio for 2009= $ 731,000/191,100 + 182,600/2

Inventory Turnover Ratio for 2009= $ 731,000/ 186,850

Inventory Turnover Ratio for 2009= 3.91 times

7 0

3 years ago

100 million diluted shares outstanding trading at $37.50 per share. The company has $1 billion of debt outstanding with a cost o

Pepsi [2]

Answer:

$4,650,000,000

Explanation:

We will use the formula below to calculate the enterprise value of Correct inc.

Enterprise value = Market value capital and debts - Cash and investments

= 100 million diluted shares × 37.50 per share + $1 billion of debt outstanding - $100 million cash

= $3750m + $1000m - $100m

= $4,650,000,000.

4 0

3 years ago

The Dulac Box plant works two 8-hour shifts each day. In the past, 500 cypress packing boxes were produced by the end of each da

Alex787 [66]

The level of productivity is now approximately 40.6 boxes/hr

<h3>What is Productivity</h3>

Productivity refers to a ratio between a output volume and volume of input.

<u>Given data</u>

Working hours = 2*8 hours = 16 hours

New productivity = 500 + 0.3*500

New productivity = 650 box/day

New productivity =650/16 box/hour

New productivity = 40.625 box/hour

Hence, the level of productivity is now approximately 40.6 boxes/hr

Therefore, the Option B is correct.