Problems and Exercises 1 through 9 are based on the class scheduling 3NF relations...

Problems and Exercises 1 through 9 are based on the class scheduling 3NF relations along with some sample data shown in Figure 6-11. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to- any relationship between faculty and sections.

Write SQL commands for the following:

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

b. Now write a command that will remove Lopez from the Student table.

c. Create an SQL command that will modify the name of course ISM 4212 from Database to Introduction to Relational Databases.