Consider the following relation: CLASS- LIST (STUDENT#, CLASS#, STUDENT- NAME, STUDENT- MAJOR, CLASS- TIME, and CLASSROOM)
a. Suppose that we wish to add a new class time and room (i. e., a new section) for a particular class number (#). Is this possible? If not, what is necessary before we can add a new class time and room to the file?
b. Suppose that all students drop a particular class number (#) from their schedules. What effect would this have on the data stored in the CLASS- LIST relation?
c. Is CLASS- LIST in first, second, or third normal form?