Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a. Write an INSERT statement that adds these rows to the Invoice_Line_Items table: (All in MySQL) invoice_sequence: 1 2 Account_number: 160 527 line_item_amount: $180.23 $254.35

a. Write an INSERT statement that adds these rows to the Invoice_Line_Items table: (All in MySQL)

invoice_sequence: 1 2

Account_number: 160 527

line_item_amount: $180.23 $254.35

line_item_description: Hard Drive Exchange Server Update

Set the invoice_id column of these two rows to the invoice ID that was generated by MySQL for the invoice you added in exercise 4.

b. Write an UPDATE statement that modifies the invoice you added in exercise 4. This statement should change the credit_total column so it\\\'s 10% of the invoice_total column, and it should change the payment_total column so the sum of the payment_total and credit_total columns are equal to the invoice_total column.

The invoice from #4 (Mentioned above) (Done in MySQL)

invoice_id: The next automatically generated ID

Vendor_id: 32

invoice_number: AX-104-027

invoice_date:8/1/2014

invoice_total:$434.58

payment_total:$0.00

credit_total:$0.00

terms_id: 2

invoice_due_date: 8/31/2014

payment_due: null

Step by Step Solution

3.51 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

Assuming invoiceid generated in exercise is ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practicing Statistics Guided Investigations For The Second Course

Authors: Shonda Kuiper, Jeff Sklar

1st Edition

321586018, 978-0321586018

More Books

Students also viewed these Programming questions