The following problem is based on the class scheduling 3NF relations along with some sample data shown in Figure 5-11. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections. Note that values of the SectionNo column do not repeat across semesters.

A. Write SQL data definition commands for each of the following queries: a. How would you add an attribute, Class, to the STUDENT table? b. How would you remove the REGISTRATION table? c. What would you need to take into account if you wanted to remove the COURSE table? d. How would you change the FacultyName column from 25 characters to 40 characters? B. 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 this student from the STUDENT table. c. How would your command look like if your task was to remove any student with the last name Lopez from the STUDENT table? d. Create an SQL command that will modify the name of course ISM 4212 from Database to Introduction to Relational Databases.

STUDENT (StudentID, StudentName) QUALIFIED (FacultyID, CourselD, DateQualified) FACULTY (FacultyID, FacultyName) SECTION (SectionNo, Semester, CourselD) COURSE (CourselD, CourseName) REGISTRATION (StudentID, SectionNo) Figure 511 Class scheduling relations (missing ASSIGNMENT)