5. Write an INSERT statement that adds these rows to the Invoice_Line_Items tabl

Question

5. 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.

6. 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.

7. Write an UPDATE statement that modifies the Vendors table. Change the default_account_number column to 403 for the vendor with an ID of 44.

8. Write an UPDATE statement that modifies the Invoices table. Change the terms_id column to 2 for each invoice that's for a vendor with a default_terms_id of 2.

9.Write a DELETE statement that deletes the row that you added to the Invoices table in Exercise 4. When you execute this statement, it will produce an error since the incoice has related rows in the Invoice_Line_items table. To fixc that, precefe the DELETE stateent with another DELETE statement that deletes the line items for this invoice. (Remember that to code two or more statements in a script, you must end each statement with a semicolon.)

The invoice from #4 (Mentioned above)

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

Explanation / Answer

7.The MySQL UPDATE statement that modifies the Vendors table by Changing the default_account_number column to 403 for the vendor with an ID of 44:-

UPDATE Vendors
SET default_account_number = 403
WHERE vendor_ID = 44;

8.The MySQL UPDATE statement that modifies the Invoices table by Changing the terms_id column to 2:-

UPDATE Invoices
SET terms_id = 2
WHERE default_terms_id = 2;

Related Questions

Navigate

• Browse (All)
• Browse 5
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.