All categories

3 years ago

Assuming that all the table and column names are spelled correctly, what's wrong with the INSERT statement that follows?

Business

1 answer:

Nezavi [6.7K]3 years ago

3 0

Answer:

(VendorID = 97

InvoiceNumber = 456789

InvoiceTotal = 8344.50

PaymentTotal = 0

CreditTotal = 0

TermsID = 1

InvoiceDate = 2006-08-01

InvoiceDueDate = ?

You cannot have PaymentTotal = 0. The sales value was $8,344.50, and since the sales was paid with cash (no invoice due date), the payment should record the same amount as the invoice.

InvoiceTotal = PaymentTotal + CreditTotal, since you were paid with cash or you gave credit to the client.

You might be interested in

East Corp., a calendar-year company, had sufficient retained earnings in 20X3 as a basis for dividends, but was temporarily shor

yarga [219]

Answer:

D. Debit retained earnings for $100,000 on April 1, 20X3, and debit interest expense for $7,500 on December 31, 20X3.

Explanation:

As East declared a dividend of $100,000 on April 1, 20X3, the journal entry to record the transaction -

Retained earnings debit $100,000

Dividend payable credit $100,000

As east issued promissory notes and the maturity date of March 31, 20X4, an interest rate of 10% arose. Seance the physical year ended in December 2004, the interest rate was accrued for December 2004 (9 months). The journal entry is

Interest expense debit $7,500 (Note - 1)

Interest payable credit $7,500

Calculation: $100,000 × 10% × (9 ÷ 12)

Calculation: $10,000 × (9 ÷ 12) = $7,500

Therefore, option D is correct.

5 0

3 years ago

Your Economics instructor assigns your class to investigate factors associated with the gross domestic product (GDP) of nations.

emmainna [20.7K]

Answer:

The Correlation analysis “R” is measured to compute the strength of relationship among variables. Moreover, the value of correlation is calculated among -1 to +1. Which implies that if the computed value is near to -1 then there will be strong but negative relation and if near to +1 then it is strong but relation among the variable. However zero is consider as neutral point.

A. The computed value of correlation is - 0.772. The value identifies that that there is a strong but negative association among the variables (GDP and infant mortality rate).

B. The correlation analysis cannot computed among the variables continent and GDP because "continent" is a categorical variable not quantitative.

C. The computed value of correlation is higher than 1. Thus, the statement implies that there is a very strong relationship among life expectancy and GDP which is incorrect. As the association cannot be higher than 1.

D. There is a strong relationship among literacy rate and GDP as the relationship is nearer to 1. Furthermore, the association among literacy rate and GDP doesn’t suggest the causation.

E. The computed correlation among the variables is 0.90. Which indicated that the variables goes up. That is, when the GDP goes down the import is also decrease and when GDP increases the import increases Thus, the there is a positive correlation.

3 0

3 years ago

Computer-mediated learning products-whether they are guided practice exercises, tutorials, simulations, games, hypertext, multim

enot [183]

The tutor and students. a computer system is a medium it's about business ethics class

6 0

3 years ago

The __________ shows how the capital is structured in the business, including the value of assets and the amount the firm owes a

PIT_PIT [208]

Answer:

balance sheet

Explanation:

The balance sheet shows how the capital is structured in the business, including the value of assets and the amount the firm owes at a specific point in time.

4 0

2 years ago

When and where were the first vending machines introduced in the united states?.

Svet_ta [14]

In 1888, Thomas Adams was the first person to build a vending machine that dispensed chewing gum. The gum, named Tutti-Frutti, was available around New York City subway stations.

5 0

3 years ago