Assignment 6: Manage Data

1. Write an INSERT statement to add the row CategoryName = "Rowan" to the CATEGORY table (10%).
2. Write an UPDATE statement to modify the row you just added to the CATEGORY table and change the CategoryName column to Database (10%).
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 (10%).
4. Create two different forms of INSERT statements to add students whose StudentID is 65798 and LastName is Lopez to the STUDENT table (10%)
5. Write a DELETE statement to delete the student added in question 4 from the STUDENT table (10%).
6. Write a DELETE statement to delete any student with the last name Lopez from the STUDENT table (10%).
7. Write an UPDATE statement to change the CourseName of the course whose ClassID is ISM4212 from Database to Introduction to Relational Databases (10%).
8. Write an INSERT statement to add the row VendorState = "California" to the VENDOR table (10%).
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 (10%).
10. Write a DELETE statement that deletes all vendors in the state of Minnesota from the VendorCopy table (10%).