1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Brut [27]
2 years ago
14

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

<h3>What is SQL?</h3>

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.

Read more about SQL here:

brainly.com/question/25694408

#SPJ1

You might be interested in
21. What are the benefits that may accrue to a community from busi
Ket [755]

Major benefits of business in the local economy include a boost in employment and discretionary income in the community, tax income increases for local governments and a loyal customer base for businesses.

4 0
3 years ago
American Inc. had gross sales of $925,000. Cost of goods sold and selling expenses were $490,00 and $220, 000 respectively Ameri
drek231 [11]

Answer:

a. Particulars                                Amount

Gross sales                                  $925,000

Less: COGS                                 <u>$490,000</u>

EBITDA                                        $435,000

Less: Depreciation                      <u>$120,000</u>

EBIT                                              $315,000

Less: Interest on notes payable <u>$8,800   </u>  (220000*4%)

EBT                                               $306,200

Less: Tax (35%*306200)             <u>$107,170</u>

Net Income                                   <u>$199,030</u>

<u />

b. Operating cash flow = Net income + Depreciation

Operating cash flow = $199,030 + $120,000

Operating cash flow = $319,030

6 0
3 years ago
Which of the following describes the function of geodemographic segmentation? It determines the type of lifestyles that consumer
Svet_ta [14]

Answer: <u><em> It identifies the specific households in a market by focusing on local neighborhood areas and creates classifications of neighborhoods where people live and shop</em></u>.

Explanation:

Geo-demographic segmentation is a classification technique used in marketing to discover whether the entity of a population fall into different groups by making comparing various characteristics with certain assumption.  

Geo-demographic segmentation is based on principles such as:

People who live in the same neighborhood have similar characteristics.  

Neighborhoods can be classified in terms of the characteristics of the population.

4 0
3 years ago
The perfectly competitive firm's short-run supply curve is the Group of answer choices upward-sloping portion of its average tot
allochka39001 [22]

Answer:

Portion of its marginal cost curve that lies above its average variable cost curve.

Explanation:

This is explained to be the portion of its marginal cost curve because marginal gross benefits exceeds marginal cost, the firm can earn greater profits by increasing its output.

These profits are been maximized by choosing to supply the level of output where its marginal revenue equals its marginal cost. When this revenue is below the said marginal cost, money is lost, and consequently, it must reduce its output. Profits are however utilized when the firm chooses the level of output where its marginal revenue equals its marginal cost.

4 0
3 years ago
PEZ Candy Inc. produces the popular small candy that is dispensed in collectible flip-top dispensers. In the United States, PEZ
aleksandrvk [35]

Answer:

PEZ Candy Inc.

1. PEZ Candy Inc. would be more likely to use process costing for the manufacture of its PEZ candies.

The reason is that the manufacturing of candies involves continuous processing of materials that results into candies.  The processes are not customizable for separate orders.

2. PEZ Candy Inc. would incur these types of costs in the manufacture of its PEZ candies:

a. Direct material = sugar

b. Direct labor = wages of factory workers

c. Manufacturing overhead = utilities expenses

i. indirect materials = cleaning supplies

ii. indirect labor = factory supervisor's salary

iii. other manufacturing overhead = depreciation expense of factory equipment

3. PEZ Candy Inc. would be more likely to use job costing to calculate the cost of one particular birthday party hosted at the PEZ Visitor Center.  The reason is that it is a specific event.  It does not involve a continuous process.

Explanation:

a) Data and Calculations:

Materials for PEZ candy include:

Direct materials:

Sugar (95%)

Fruit flavoring

Coloring

Corn syrup

Product = PEZ candies

Services: customized birthday parties

6 0
3 years ago
Other questions:
  • You borrowed $185,000 for 30 years to buy a house. The interest rate is 4.35 percent, compounded monthly. If you pay all of your
    13·1 answer
  • If you are interested in general management, the best career cluster for you might be: A: Education and Training. B: Architectur
    10·2 answers
  • Which of the following ratios indicates the percentage of each sales dollar that is available to cover fixed costs and to provid
    8·1 answer
  • Richards Corporation had net income of $166,152 and paid dividends to common stockholders of $48,100. It had 51,600 shares of co
    6·1 answer
  • Which factor should influence the organizational pattern you choose? a. your number of section headings b. all responses are cor
    14·1 answer
  • In accordance with 1926.21(b)(2), the employer is required to instruct each employee in the _______________ of unsafe conditions
    14·1 answer
  • President Ronald Reagan
    8·1 answer
  • Which best describes which careers would work in offices? O Marketing Information Management and Research, Distribution and Logi
    15·2 answers
  • do you think bitcoin or another cyber currency will replace existing traditional currency? why or why not?
    15·1 answer
  • A(n) ________ strategy is the approach a functional area takes to achieve corporate and business unit objectives and strategies
    10·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!