Chapter 5, Problem 5.39PAE

 
Write SQL commands for the following:

1. Create two different forms of the INSERT command to add a student with a student ID of 65798 and last name Lopez to the STUDENT table.
2. Now write a command that will remove this student from the STUDENT table.
3. HOW would your command 100k like if your task was to remove any student With the last name Lopez from the STUDENT table?
4. Create an SQL command that Will modify the name Of course ISM 4212 from Database to Introduction to Relational Databases.