Part 2 (For part two, use your default database and the existing Vendors-Invoices-Terms schema.)

Items 1 through 4 are weighted at 5% each.

Write SQL code to accomplish the following tasks:

1) Insert the following record into the vendors table:

VendorID	0
VendorName	Pooh
VendorAddress1
VendorAddress2,
VendorCity	Frisco
VendorState	TX
VendorZipCode	76209
VendorPhone	1234
VendorContactLName	Orphans
VendorContactFName	Parent of
DefaultTermsID	0
DefaultAccountNo	100

2) Write an SQL statement that would change the TermsID to 7 for all of the invoices for VendorID 115. (Don't worry about the error message, just write the code.)

3) Now you can start worrying about the error message. Problem #2 produced an error... why was there an error (be specific!)

/*

Place your text inside a comment.

*/

4) Zip code 93711 has changed to 93710. Write a single SQL statement to update the Vendors table to reflect the change.