Consider the following relation:
CLASS-LIST (STUDENT#, CLASS#, STUDENT-NAME, STUDENT-MAJOR, CLASS-TIME, CLASSROOM)
Required
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?
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.