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
A car crash woke john from his afternoon nap. when he looked out of his apartment window, he saw several people milling around t
Ronch [10]
John's reaction is an example of the bystander effect.
It means that he will just continue staring at the accident because he is curious as to what happened and he wants to see how the event is resolved, however, he is not really willing to do anything to help the people involved - he will just assume someone else will do that.
4 0
3 years ago
Definition of pre customer contact​
Alinara [238K]

Answer and Explanation:

As the name suggests the pre customer contact means contacting the customer before selling the product so that the firm could able to find out the requirement of the customer what he or she needs

The firm has the responsibility to provide the information about their products and services so that the customer could able to decide what he or she actually wants

After the selling the person could become the customer

8 0
3 years ago
Jessica is a one-third owner in Bikes-R-Us, an S corporation that experienced a $45,000 loss this year (year 1).
Arlecino [84]

Answer:

a. $15,000

b. $10,000 & $3,000

c.  $3,000

Explanation:

a. The amount of loss deducted in a year will be equal to the stock basis in the company.

The excess amount of loss will be carry to the future years and deducted, if there is conditional stock basis in the company.

The amount is Jessica allowed to deduct in year 1: ($45,000 x 1/3) = $15,000

b. Her stock and debt bases in the corporation at the end of year 1:

=> Stock basis at the end of year 1: $10,000 - $10,000 = 0

=> Remaining amount of loss: $15,000 - $10,000 = $5,000 => Remaining loss: $5,000 - $3,000 = $2,000

So, Jessica has a suspended loss of $2,000 at the end of year 1

c. The profit is $12,000

Share of J: $12,000 x 1/3 = $4,000

Out of this $4,000, the $3,000 (one-third) will be its debt basis and $1,000 will be stock basis.

The amount of $2,000 loss will first be deducted from the stock basis and then from the debt basis.

3 0
3 years ago
In 1 or 2 sentences, explain how consumers affect which goods and services are produced. WRITER
san4es73 [151]
Answer;
Based on Supply and demand; If a more people want a commodity, it is in greater demand, thus the price will be higher, and if less people want a commodity, the price will be lower.
Explanation;
In a market the price is determined using the law of demand and supply in that particular market. Demand is the quantity of goods that consumers are willing and able to buy at a given price while supply is the quantity supplied by suppliers at a particular price. 
If a more people want a commodity, it is in greater demand, thus the price will be higher, and if less people want a commodity, the price will be lower. 
8 0
3 years ago
Read 2 more answers
Dave has arranged a catered lunch for his team members to celebrate the completion of their work so they can see one another for
PSYCHO15rus [73]

Answer:

Dave's team is now in the fifth and the last stage.

Explanation:

There are a total of five stages in  team development are as follows  

1. Forming: At this stage, the creation of a new group starts, where the members appear collectively and become to understand each other during the communications.  

2. Storming: Once the forming stage is completed, the people will start communicating with each other in the context of the responsibility to be performed.

3. Norming: Once the duty of each member is cleared along with the power and responsibility, the group members begin settling in a society.

4. Performing: At this stage, synergy gets built between the group members, where each and everyone acts towards the fulfillment of an objective.

5. Adjourning: This is the fifth and the last stage of group development, where the group is eliminated, and the group members are isolated from each other.

Thus, Dave's team is now in the fifth and the last stage of team development as Dave has arranged a catered lunch for his team members to celebrate last time with his group before separated from each other which is done in the fifth stage is Adjourning stage of team development.

4 0
3 years ago
Other questions:
  • Daryl enjoys his job because he gets to analyze the security systems in different organizations and provide recommendations to i
    14·2 answers
  • According to the Zippo standard, websites that provide information but do not provide the opportunity to conduct online transact
    5·1 answer
  • ____ is a set of attitudes, values, and behaviors shared by a group of people?
    9·2 answers
  • Small-business investment companies (SBICs): a. take a more balanced approach in their choices than venture capital companies. b
    9·1 answer
  • For planning control, and decision-making purpose:
    5·1 answer
  • The advantages of affiliate marketing include _____.  
    7·1 answer
  • Outsourcing: Question 19 options: Transfers traditional internal activities to outside vendors. Utilizes the efficiency which co
    7·1 answer
  • . If Canace Company, with a break-even point at $313,500 of sales, has actual sales of $570,000, what is the margin of safety ex
    5·1 answer
  • Which is the best example of ethical investing?
    7·1 answer
  • Updating accounts receivable is part of which transaction cycle?
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!