Reference no: EM133258477

Workbench:

Question 1. Write an INSERT statement to add the row CategoryName = "Columbia" to the CATEGORY table

Question 2. Write an UPDATE statement to modify the row you just added to the CATEGORY table and change the CategoryName column to "Database ."

Question 3. Write a DELETE statement to delete the rows you added to the CATEGORY table in question 2. The command should use the CategoryName column to identify the row .

Question 4. Create two different forms of INSERT statements to add students whose StudentID is 65798 and LastName is Lopez to the STUDENT table .

Question 5. Write a DELETE statement to delete the student added in question 4 from the STUDENT table .

Question 6. Write a DELETE statement to delete any student with the last name Lopez from the STUDENT table.

Question 7. Write an UPDATE statement to change the CourseName of the course whose ClassID is ISM4212 from "Database" to "Introduction to Relational Databases."

Question 8. Write an INSERT statement to add the row VendorState = "California" to the VENDOR table (10%).

Question 9. Write an UPDATE statement that modifies the VendorCopy table. Change the default account number to 403 for each vendor that has a default account number of 400 .

Question 10. Write a DELETE statement that deletes all vendors in the state of Minnesota from the VendorCopy table.