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
Sam closed the doors to her home-based consulting company only two years after opening because she was tired of working 80-hour
blondinia [14]

Answer:

There is sacrifice to having your own business. Sam wasn't ready to invest the hours needed to make it on his own.

Explanation:

There are many advantages to opening a new business. When you are an entrepreneur it is easy to get lost in all the benefits and don't pay attention to many os its disadvantages.

A big disadvantage is that you are always at work, you are working everywhere at all times. There are no off days, if you’re not working, then you’re not earning. You don’t need to be engaged 24/7 to have a chance at success in the world of entrepreneurship, but you will be working a lot more often.

Most people who find success in the world of entrepreneurship are working longer, harder days than the average “traditional” employee. You do have some flexibility when putting in those hours, so you can structure medical appointments, school visits, and other family needs within your day. You do not have the luxury of cutting back on your hours most days.

There is sacrifice to having your own business. Sam wasn't ready to invest the hours needed to make it on his own.

3 0
3 years ago
A corporation declares a cash dividend on Friday, December 5th, payable to holders of record on Friday, December 19th. The local
andrew11 [14]

Answer: Thursday December 18

Explanation:

The ex date for regular way trades will be set at Thursday December 18. The ex date for regular way trades is typically set a day before the record date.

In this case, we are told that the corporation declares a cash dividend on Friday, December 5th, which was payable to the holders of record on Friday, December 19th.

Since the record date is the question is Friday, December 19th, then the ex date for the regular way trades will be set at Thursday December 18 which is a day before the 19th.

5 0
3 years ago
Ahmad owns an apartment building and has recently had to lower the rent he charges, not only to attract new tenants but also to
Yanka [14]

Answer: Interest rate risk

Explanation:

Interest rate risk is described as the potential for investment loss which result from a change in interest rates. The increase in interest rate declines tell value if a bond or other fixed-income investment, the change that occurs in these bond price is known as duration. Generally, it is the risk that arises for bond owners from fluctuating interest rates. The interest rate risk of a bond depends on how sensitive it's price is to interest rate changes in the market

5 0
3 years ago
An employee that has integrity is
damaskus [11]

Explanation:

Integrity is the quality of having strong ethical or moral principles and following them at all times, no matter who's watching. A person with integrity acts with honesty, honor, and truthfulness.

5 0
2 years ago
Facial Cosmetics provides plastic surgery primarily to hide the appearance of unwanted scars and other blemishes. During 2021, t
valentina_108 [34]

Answer: Please see explanation for answers

Explanation:

Age Group            Amount           Estimated Percent     Estimated  Amount

                              Receivable      Uncollectible                 Uncollectible

Not yet due             $ 32,000              4 %                          $1,280

0-30 days past due 10,200                 6 %                          $612  

31–60 days past due 7,200                 12 %                        $864

More than 60 days past due 2,600      30 %                      $780

Total                                  $ 52,000                                    $3536

Calculation

1) Estimated Amount Uncollectible = Amount Receivable x Estimated Percent      Uncollectible    =

4% x 32,000= $1,280

6% x 10,200=$612

12% x 7,200=$864

30% x2600=$780

Total = $3,536

The allowance for uncollectible accounts = $3,536

2) Journal to  Record the December 31, 2021, adjustment for a debit of $400

Estimated Amount Uncollectible =$3,536

Adjusted = $3536 + debit $400=$3,936

Date                   Account                  Debit             Credit

Dec 31, 2021,  Bad debts Expense    $3,936

Allowance for uncollectible accounts                    $3,936

3) Journal to  Record the write-off of $500

Date                   Account                              Debit             Credit

April 3, 2022,  Allowance for uncollectible

                             accounts                             $500

                         Accounts receivable                                     $500

4a)Journal to  reinstate  the account previously wrtten off  On July 17, 2022

Date                   Account                              Debit             Credit

July 17, 2022,   Accounts receivable             $100

Allowance for uncollectible  accounts                             $100

4b)Journal to record collection of cash  

Date                   Account                              Debit             Credit

July 17, 2022,   Cash                                    $100

     Accounts receivable                                                     $100

                                                                                                                   

5 0
3 years ago
Other questions:
  • the table you're working at keeps wobbling you decide to fix it by making a thick pad of paper from folded sheets of paper. each
    5·1 answer
  • The principle benefit of tariff protection goes to a. foreign consumers of the good produced. b. domestic consumers of the good
    12·1 answer
  • In which situation would a savings bond be the best investment to eam interest
    8·1 answer
  • If the type of departmentalization used by an organization tends to emphasize departmental units rather than the organization as
    8·1 answer
  • A business owner who wants to make adjustments to her company's production would make use
    6·1 answer
  • Xyz corporation has suffered a major downturn in business and will not be able to pay interest on its bonds. this is an example
    12·1 answer
  • The ledger of Claudell Company includes the following unadjusted normal balances: Prepaid Rent $1,000, Services Revenue $55,600,
    15·1 answer
  • Sound Company reported the following amounts for May: Raw materials purchased $254,000 Beginning raw materials inventory 12,000
    9·1 answer
  • Which are the two best examples of long-term needs that people need to save for?
    7·1 answer
  • Compared to rail transportation, one of the advantages of shipping by truck is that trucks
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!