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

Manufactured truck parts are part of which industry

qwelly [4]

Answer:

Explanation:

4 0

2 years ago

Read 2 more answers

The Outpost, a sole proprietorship currently sells short leather jackets for $369 each. The firm is considering selling long coa

Cloud [144]

Answer:

$134,546

Explanation:

Calculation to determine the projected operating cash flow for this project

Projected operating cash flow=

{[820 × ($719 − 435)] + [(1,040 − 1,120) × ($369 − 228)] − $23,100} × {1 − .34} + {$10,400 × .34}

Projected operating cash flow={[820 × $284)] + [$80 × $141] − $23,100} × {.66} + {$3,436}

Projected operating cash flow= $134,546

Therefore the projected operating cash flow for this project is $134,546

3 0

2 years ago

Whipple Corp. just issued 280,000 bonds with a coupon rate of 6.02 percent paid semiannually that mature in 25 years. The bonds

sesenic [268]

Answer:

529.64 million or $529,639,600 was received from the sale of bonds.

Explanation:

Money Raised from the sale is based on the current value of the bond. Price of bond is the present value of future cash flows, to calculate Price of the bond use following formula:

Price of the Bond = C x [ ( 1 - ( 1 + r )^-n ) / r ] + [ F / ( 1 + r )^n ]

As per given data

Face Value = $2,000

Coupon payment = $2,000 x 6.02% = $120.4 /2 = $60.2 semiannually

Number of period = n = 25 years x 2 period per year = 50 period

Yield to maturity = 6.46% annually = 6.46% / 2 = 3.23% semiannually

Price of the Bond = C x [ ( 1 - ( 1 + r )^-n ) / r ] + [ F / ( 1 + r )^n ]

Price of the Bond = $60.2 x [ ( 1 - ( 1 + 3.23% )^-50 ) / 3.23% ] + [ 2,000 / ( 1 + 3.23% )^50 ]

Price of the Bond = $1,483.51 + $408.06 = $1,891.57

Cash received = Number of bonds x Price per bond = 280,000 x $1,891.57 = $529,639,600

3 0

3 years ago

(Chapter Supplement) Under the gross method of recording sales discounts discussed in this chapter, is the amount of sales disco

UkoKoshka [18]

At the time of collection, if the amount is paid within the discount period, the following entry is recorded:

Cash (+A).......................xxx

Sales discount(+XR,-R,-SE)........xxx

R. Jones (Accounts Receivables)(-A)….xxx

If the account is paid in full before the end of the discount period, the customer can be eligible for a cash discount rate. The duration of the trade credit is known as the credit period, and up until the end of the credit term, no interest is applied to the outstanding balance.

You use it to illustrate how a company's cash flow is distributed equally throughout the year rather than arriving in full at the end. We would use discount period numbers of 1 for the first year, 2 for the second year, 3 for the third year, and so on in a DCF without the mid-year convention.

Learn more about discount period here

brainly.com/question/2264363

#SPJ4

8 0

1 year ago

Known as ____________________________________________ these ethical standards emphasize preventing unlawful behavior by increasi

QveST [7]

Known as <u>compliance-based ethic codes</u> these ethical standards emphasize preventing unlawful behaviour by increasing control and by penalizing wrongdoers.

Compliance-based ethical codes are those that outline moral requirements with an emphasis on preventing unethical activity by tightening regulations and punishing offenders. Integrity-based ethical codes are those that specify an organization's guiding principles and foster a culture that encourages moral behavior. A compliance-based code of ethics is created to ensure that the company and its personnel abide by all rules and regulations properly. The prevention, detection, and punishment of non-compliant conduct are three important components. For instance, Jeremy's compliance-based code might forbid his employees from materially misrepresenting the truth when acting in the course of their job.

Learn more about Compiance based Ethic code here:

brainly.com/question/14260293

#SPJ4

5 0

1 year ago